Sunday, March 25, 2018

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 ;

No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...