Link Between Transaction Number And Receipt Number In AR

Home » Ar_cash_receipts_all Ar_receivable_applications_all » Link Between Transaction Number And Receipt Number In AR

Maybe your like

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 By - January 26, 2015 Labels: AR, Invoice, oracle, Receipt

No comments:

Post a Comment

Newer Post Older Post Home Subscribe to: Post Comments (Atom)

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,             ...

  • Account Recievables Module (AR) Explanation (Recievables Useful Information) Accounts Receivables useful information ACCOUNTS RECEIVABLES: ==================== ACCOUNTING METHOD , ACCRUAL OR CASH :     So do you...
  • Query to find Active Customer in Oracle Apps SELECT hou.name Organization_name,        ----------------------        --Customer Information        ----------------------    ...
  • Important Join conditions between Oracle apps modules GL AND AP GL_CODE_COMBINATIONS          AP_INVOICES_ALL               code_combination_id        =        acct_pay_code_combination_id G...

Search This Blog

Total Pageviews

Pages

  • Home
  • AR
  • AP
  • GL
  • OM
  • Inventory
  • Oracle Apps Tables
  • Others
  • Interface

Blog Archive

  • ▼  2015 (77)
    • ▼  January (26)
      • Order To Cash Cycle Explanation (Order To Cash Cyc...
      • General Ledger Module (GL) Explanation (General Le...
      • Inventory Module (INV) Transactions Explanation (I...
      • Purchasing Module (PO) Explanation (Purchasing Use...
      • Account Recievables Module (AR) Explanation (Recie...
      • Mapping Between AR and OM (Transaction Flex field)
      • Query to Join OM , WSH and AR table
      • Query to Join OM and PO Requisition table for Back...
      • Query to Join OM and Purchase Order tables for Bac...
      • Query to Join OM and requisition Interface table f...
      • Link Between Transaction Number and Receipt Number...
      • Query Sales Order Number Against AR Receipt No.
      • Query for Total Uncleared Receipt Amount
      • Query for Total Unapplied Receipt Amount
      • Query for Total On Account Receipt Amount
      • Query to retrive the Sales order and associate inv...
      • Query to retrive Account Receivable Invoice, Recei...
      • BULK COLLECT
      • Useful Queries for Order Management
      • FND_LOAD Commands
      • Inventory Valuation Report
      • FNDLOAD to Download and Upload for different AOL o...
      • FND tables for Reports
      • Query to check AP Invoice and Payments
      • Important Join conditions between Oracle apps modules
      • Procedure to check AP Invoice and Payments

About Me

Unknown View my complete profile

Report Abuse

  • Usefull Links

Tag » Ar_cash_receipts_all Ar_receivable_applications_all