Link Between Transaction Number and Receipt Number in AR

Link Between Transaction Number and Receipt Number in AR


SELECT ACR.RECEIPT_NUMBER RECEIPT_NO,
RCT.TRX_NUMBER INVOICE_NO
FROM
 APPS.AR_RECEIVABLE_APPLICATIONS_ALL ARA,
APPS.AR_CASH_RECEIPTS_ALL ACR,
APPS.RA_CUSTOMER_TRX_ALL RCT
WHERE
 ARA.STATUS='APP'
AND ARA.CASH_RECEIPT_ID=ACR.CASH_RECEIPT_ID
AND ARA.APPLIED_CUSTOMER_TRX_ID=RCT.CUSTOMER_TRX_ID ;