Yes, I already have posted the query with ORDERED hint. It runs for ever. Any other suggestions.

Thanks!
Patni