Thursday, September 27, 2018

Link Cash Receipt table and Transaction table

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

No comments:

Post a Comment