I did try the query you suggested but it didn't help too much for the performance, but still thanks for your time and effort.

I replaced the 'EXISTS' with 'IN' in the sub-query and the entire query run very fast.