Oracle Message QSM-02018 - subquery present in the WHERE clause

ERRORsubquery present in the WHERE clause
CAUSEThe capability in question is not supported when the materialized view uses a subquery in the WHERE clause.
ACTIONRe-phrase the query to avoid the subquery in the WHERE clause.