Customer opening balance query in oracle apps

Customer opening balance query in oracle apps

In this post , We will discuss about sql query to extract the Customer Amount due in the oracle apps. This below sql query helps to extracts the Open balance of the Customer which is due. With the help of this Query we can also find the due amount on the month basis. Here blow is the detail sql query of Customer opening balance in oracle apps.

 

 

 

Complete Customer opening balance query in oracle apps

 

select rc.customer_number,
rc.customer_id,
sum(apl.amount_due_remaining) Amount_Due,
sum(apl.amount_due_remaining*nvl(apl.exchange_rate,1)) Amount_Due_Func_currency
from ar_payment_schedules_all apl,
ra_customers rc
where rc.customer_id=aps.customer_id
and apl.org_id=:p_org_id
and rc.customer_number=:p_customer_number
group by rc.customer_number,
rc.customer_id