Message Oracle QSM-02017 - subquery present in the HAVING clause

ERRORsubquery present in the HAVING clause
CAUSEThe capability in question is not supported when the materialized view uses a subquery in the HAVING clause.
ACTIONRe-phrase the query to avoid the subquery in the HAVING clause.