QSM-01843
Materialized view defining query could not be transformed to a two table semijoin query block.
Cause
Materialized view definition was not eligible for join-specific materialized view rewrite because the query could not be transformed to a two table semijoin query block.
Action
Provide additional hints to get a semijoin in the materialized view defining query plan.