Oracle Error Message
QSM-02042: view or subquery in from list
Reason for the Error
The capability in question is not supported when the materialized view references a view or subquery in the FROM list.
Solution
Re-phrase the query to avoid the use of views or subqueries in in the FROM list.