ORA-00166: remote/local nesting level is too deep

ORA-00166: remote/local nesting level is too deep
Cause: Too many remote table operations required a reverse trip back to the local  site, for example
to execute a local function on a remote table.
Action: Rearrange the query or co-locate the functions with the tables.