Oracle Error Message
QSM-02113: expression in select list references multiple tables or views
Reason for the Error
The capability in question is not supported when the materialized view includes an expression in the select list that references multiple tables or views.
Solution
Re-phrase the query to avoid the use of the such expressions.