Message Oracle QSM-02036 - in-list present in mv

ERRORin-list present in mv
CAUSEThe capability in question is not supported when the materialized view uses an IN list.
ACTIONRe-phrase the query to avoid the use of IN lists.