Oracle Error Message
QSM-02018: subquery present in the WHERE clause
Reason for the Error
The capability in question is not supported when the materialized view uses a subquery in the WHERE clause.
Solution
Re-phrase the query to avoid the subquery in the WHERE clause.
