Oracle Error Message
QSM-02151: subquery or named view in FROM list and < 9.0 compatibility
Reason for the Error
You have specified a materialized view that references a subquery or named view in its top level FROM list while running in less than 9.0 compatibility mode.
Solution
Set compatibility mode to 9.0 or higher or restructure the materialized view query.