ROWNO specifications are not allowed in a view definition.
Remove the ROWNO specification from the SQL statement.