Message Oracle QSM-02008 - non-join filter condition in WHERE or HAVING clause

ERRORnon-join filter condition in WHERE or HAVING clause
CAUSEThe 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.
ACTIONRemove the selection filter expression.