Thanks for the input Axr2.

I found it on Metalink as well but it doesn't change the behavior. Read in the 9i patch release that was supposed to be fixed already...

After torturing the view subquery for 2 hours, I come to the conclusion that scalar expressions referencing SQL factoring elements ( WITH ... AS ) are not fully supported within view's subqueries. Acessing it locally work fine but remote access via dblinks bombs out every time.

I hate it when they introduce a new feature but don't fully test the thing. Makes me feel like i'm on their debugging team...

Following you sugestion; a tar is on the way as I write this note...

Thanks again!

Vuzz