Oracle Error QSM-02092: mv references a sequence number

Oracle Error Message

QSM-02092: mv references a sequence number

Reason for the Error

The capability in question is not supported when the materialized view references a sequence number.

Solution

Re-phrase the query to avoid the reference to sequence numbers.