Oracle Error Message
ORA-22982: cannot create sub-view under this view
Reason for the Error
The view derives its OID from a table/view having primary key based OID and sub-views cannot be created under such views.
Solution
Specify view having system generated OID or a view created with the specification of attributes in the WITH OBJECT ID clause and retry the operation.
