Oracle Message QSM-02106 - mv uses a filter condition in the WHERE or HAVING clause

ERRORmv uses a filter condition in the WHERE or HAVING clause
CAUSEThe capability in question is not supported when the materialized view includes a filter condition in the WHERE or HAVING clause.
ACTIONRe-phrase the query to avoid the use of filter conditions in the WHERE or HAVING clauses.