ORA-01778

Error: ORA-01778: maximum subquery nesting level exceeded

Causa: An attempt was made to use more than 255 levels of nested subqueries.

Acción: Merge some of the subqueries into their containing queries, until there are less than 255 levels of nesting.