Oracle Error Message
ORA-30360: REF not supported with query rewrite
Reason for the Error
The statement contained a REF operator. Repeatable behavior cannot be guaranteed with the REF operator. Therefore, query rewrite cannot support the REF operator.
Solution
Remove the reference to the REF operator or disable the REWRITE option on the materialized view.