ERROR | non-join filter condition in WHERE or HAVING clause |
CAUSE | The capability in question is not supported when the materialized view has a selection condition (an expression not representing a join) in the WHERE or HAVING clauses. |
ACTION | Remove the selection filter expression. |