Oracle Error Message
QSM-02019: mv references another mv in FROM clause
Reason for the Error
The capability in question is not supported when the materialized view is nested (i.e., when it references another materialized view in its FROM list).
Solution
Re-phrase the query to avoid reference to the other materialized view.