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

No comments:

Post a Comment

Query to Find Receipt Class and its GL Combinition Query

SELECT ARC.NAME ReceiptClass,        ARC.CREATION_METHOD_CODE Creation_Mehthod,        DECODE (ARC.REMIT_METHOD_CODE,             ...