Oracle Error Message
QSM-02148: many to many subquery joins require 9.0 compatibility or higher
Reason for the Error
You have specified a many to many join in your materialized view while running in less than 9.0 compatibility mode.
Solution
Set your compatibility mode to 9.0 or higher or restructure the materialized view query.