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
Monday, 26 January 2015
Link Between Transaction Number and Receipt Number in 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
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
Subscribe to:
Post Comments (Atom)
Iam so thrilled because of finding your alluring website here.Actually i was searching for Oracle SQL.Your blog is so astounding and informative too..Iam very happy to find such a creative blog. Iam also find another one by mistake while am searching the same topicOracle APEX.Thank you soo much..
ReplyDelete