Oracle Error Codes

cannot select ROWID from view with DISTINCT, GROUP BY, etc.

A SELECT statement attempted to select ROWIDs from a view containing columns derived from functions or expressions. Because the rows selected in the view do not correspond to underlying physical records, no ROWIDs can be returned.

How to Solve :

Remove ROWID from the view selection clause, then re-execute the statement.