Oracle Error Message
QSM-02050: subquery using the ALL clause in mv
Reason for the Error
The capability in question is not supported when the materialized view uses the ALL clause with a subquery.
Solution
Re-phrase the query to avoid the use of the ALL clause.