TRANS_COMBINED_VIEW appears to be doing a UNION ALL where both sides of the UNION ALL are doing Cartesian joins. That seems quite unlikely to be the best approach. Are you certain that the view isn't missing some join conditions?
I have only one account... Do you have any concerns to create any other account?
AS of now I don't have any plans to create multiple accounts. Because till I didn't face any issue with the current account I am getting good support like you people. SO why I do I go and create new accounts.