Hi SVK,
I fine tuned the inline quaries and now whole query is taking over 5 minutes.Tried DECODE but response time is almost same.

Is doing count is expensive affiar ? In your openion what should be acceptable time for such type of queries ?

Note : Please use my previous post for context.

Thanks for your response.

Regards
Dinesh