I have written a below query it is getting executed without any error but sum(NVL()) function is making query run out of time

Question

I have written the below code and it is running fine after I added sum(nvl) function column the query is not giving error but when I run I am getting time limit exceeded.

sql query