Message Oracle QSM-02064 - subquery in mv

ERRORsubquery in mv
CAUSEThe capability in question is not supported when the materialized view uses a subquery.
ACTIONRe-phrase the query to avoid the use of the subqueries.