Need an help for SQL query.
I need some quick help in for my Bi Report which is for Receivables Module - I have query in which it has three corelated subqueries. I want to use the outer join for the correlation column (ps.customer_trx_id) at line no 74 but it is throwing an error:
ORA-01705: an outer join cannot be specified on a correlation column.
Attaching my SQL Query - Any suggestions will be much appreciated.