QSM-02221
File Change Tracking (FCT) FAST REFRESH is not possible if the WHERE clause includes a subquery.
Cause
This capability is not supported because the materialized view query WHERE clause includes a subquery.
Action
Avoid using a subquery in the WHERE clause.