Oracle Solution for Error ora-30360

ORA-30360: REF not supported with query rewrite

What triggered 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.

What should we do to fix it:

Remove the reference to the REF operator or disable the REWRITE option on the materialized view.