How to find the link between AR_CASH_RECEIPTS_ALL AND RA_CUSTOMER_TRX_ALL
Simple query find the transaction number(ar) from receipt number(ar)
SELECT ACR.RECEIPT_NUMBER RECEIPT_NO, RCT.TRX_NUMBER INVOICE_NO
FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA,
AR_CASH_RECEIPTS_ALL ACR,
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
Simple query find the transaction number(ar) from receipt number(ar)
SELECT ACR.RECEIPT_NUMBER RECEIPT_NO, RCT.TRX_NUMBER INVOICE_NO
FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA,
AR_CASH_RECEIPTS_ALL ACR,
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
No comments:
Post a Comment