Message Oracle QSM-01110 - query rewrite not possible with materialized view string because it contains a join between tables (string) that is not present in the query and that potentially eliminates rows needed by the query

ERRORquery rewrite not possible with materialized view string because it contains a join between tables (string) that is not present in the query and that potentially eliminates rows needed by the query
CAUSEAll lossy joins in the materialized view must be present in the query for query rewrite to occur.
ACTIONNone