Oracle Error Message
QSM-02152: subquery or named view in FROM list even after view merging
Reason for the Error
You have specified a materialized view that references a subquery ore named view in its top level FROM list that could not be merged during the view merging process.
Solution
Restructure the materialized view query.