Oracle Message QSM-02042 - view or subquery in from list

ERRORview or subquery in from list
CAUSEThe capability in question is not supported when the materialized view references a view or subquery in the FROM list.
ACTIONRe-phrase the query to avoid the use of views or subqueries in in the FROM list.