Oracle Error Message
QSM-02056: correlated variable and outer join in mv
Reason for the Error
The capability in question is not supported when the materialized view uses a correlated variable and an outer join.
Solution
Re-phrase the query to avoid the use of the correlated variables or outer joins.