Discussion in 'Oracle Apps Technical' started by jagadekara, Nov 21, 2014.
I need to display AR Invoice Status(Paid, Fully Paid, UN Paid) through SQL.
Is there any standard function for this?
Haven't seen any standard function for this specific requirement like you have in the following packaged functions:
Most probably you'll have to write some custom function based on at least (among other tables) AP_PAYMENT_SCHEDULES_ALL, AP_INVOICES_ALL ...
Some where I got this..
'Partially Paid') PAY_STATUS
FROM RA_CUSTOMER_TRX_PARTIAL_V RCTP, AR_RECEIVABLE_APPLICATIONS_V ARR
WHERE RCTP.CUSTOMER_TRX_ID = ARR.CUSTOMER_TRX_ID(+)
AND RCTP.BATCH_SOURCE_ID = 20
AND RCTP.TRX_NUMBER = 'XXX'
But this is not correct.
Thanks Jagadekara !
Oops ... I again mixed up AP and AR (may be because I've been recently very much engrossed in AP queries ) ... my reply was linked to AP, I'm sure you noticed that.