AR RECEIPT TO INVOICE QUERY - Oracle Concepts For You

Home » Ar_cash_receipts_all And Ra_customer_trx_all » AR RECEIPT TO INVOICE QUERY - Oracle Concepts For You

Maybe your like

Tuesday, 24 January 2012

AR RECEIPT TO INVOICE QUERY

Select * from GL_JE_HEADERS gjh, GL_JE_LINES gjl, AR_CASH_RECEIPT_HISTORY_ALL acrha, AR_CASH_RECEIPTS_ALL acra, AR_RECEIVABLE_APPLICATIONS_ALL araa, RA_CUSTOMER_TRX_ALL rcta, RA_CUSTOMER_TRX_LINES_ALL rctla, RA_CUST_TRX_LINE_GL_DIST_ALL rctlgda, GL_CODE_COMBINATIONS gcc WHERE gjh.JE_HEADER_ID = gjl.JE_HEADER_ID AND gjl.CODE_COMBINATION_ID = abaa.ASSET_CODE_COMBINATION_ID AND acrha.CASH_RECEIPT_ID = acra.CASH_RECEIPT_ID AND acrha.CASH_RECEIPT_HISTORY_ID = araa.CASH_RECEIPT_HISTORY_ID AND acrha.CASH_RECEIPT_ID = araa.CASH_RECEIPT_ID AND rcta.CUSTOMER_TRX_ID = araa.APPLIED_CUSTOMER_TRX_ID AND rcta.CUSTOMER_TRX_ID = rctla.CUSTOMER_TRX_ID AND rctlgda.CUSTOMER_TRX_LINE_ID = rctla.CUSTOMER_TRX_LINE_ID AND gcc.CODE_COMBINATION_ID = rctlgda.CODE_COMBINATION_ID Posted by at 13:58 Labels: AR_Query

1 comment:

  1. William20 July 2016 at 22:00

    What table is abaa?

    ReplyDeleteReplies
      Reply
Add commentLoad more... Newer Post Older Post Home Subscribe to: Post Comments (Atom)

About Me

My photo Elangovan Ragavan இளங்கோவன் ராகவன் எண்ணிய முடிதல் வேண்டும், நல்லவே யெண்ணல் வேண்டும்; திண்ணிய நெஞ்சம் வேண்டும், தெளிந்த நல் லறிவு வேண்டும்; பண்ணிய பாவமெல்லாம் பரிதி முன் பனியே போல, நண்ணிய நின்மு னிங்கு நசித்திட வேண்டும் அன்னாய்! View my complete profile

Oracle GRC

Oracle GRC Oracle Advanced Controls 11g Applications Certified Implementation Specialist

Followers

Live Viewers

Total Pageviews

Labels

  • .lst file (1)
  • About Page in OAF (3)
  • ADF (2)
  • Advanced Collections (1)
  • Advanced PL/SQL (18)
  • AIGS (10)
  • AIM Document (3)
  • Alert (7)
  • AME (17)
  • AOL (6)
  • AP Functional Accounting (17)
  • AP Payments (6)
  • AP_Module (84)
  • APEX (70)
  • API'S / INTREFACES (77)
  • Application Short Name (2)
  • approved supplier list (2)
  • APPS (11)
  • AR Functional (10)
  • AR_Query (72)
  • Back-to-Back Order Cycle (2)
  • Bank Query (34)
  • BOM (2)
  • Cash Management (8)
  • concurrent program (49)
  • Contorl file ctl (7)
  • Contorl file SQL *Loader (4)
  • Current Login Users (1)
  • custom.pll (7)
  • Customer (13)
  • Data Extraction (57)
  • Data Model (2)
  • Date Format (7)
  • DBA (114)
  • DELETE_QUERY (3)
  • DFF (7)
  • Documents (1)
  • DROP SHIP Order Flow (1)
  • Dummy Table (1)
  • EAM (16)
  • elango (6)
  • ERROR (28)
  • Executable (21)
  • FA (18)
  • FlexFields (8)
  • FND LOG (1)
  • FND_LOAD (13)
  • form personalization (52)
  • Forms (23)
  • FSG Report (1)
  • FUNCTIONAL (130)
  • gl (84)
  • GL Accounting (12)
  • GL Flow (3)
  • Global (1)
  • GRC (31)
  • GRC Function (1)
  • GRC Gertification (1)
  • GRC Screen (13)
  • GRC Tech (20)
  • HRMS (87)
  • Hyperion (7)
  • HZ TO ORG (1)
  • ICX - Oracle Self-Service Web Applications (2)
  • iExpenses (8)
  • IF (1)
  • India Localization (5)
  • Inventory_Details (69)
  • iprocurement (4)
  • ITEM_TEMPLATE (1)
  • java (8)
  • Legal entity (1)
  • Lexical & Bind (2)
  • LINKS IN ALL TABLES (6)
  • Lookup value (1)
  • Materialized View (2)
  • MO:Security Profile (2)
  • Multi-Org (24)
  • My Favorited Links (2)
  • MY FAVOURITES (2)
  • O2C CYCLE (28)
  • OBIEE (74)
  • ODI (1)
  • OM (23)
  • OM Setup (9)
  • Oracle (2)
  • ORACLE -Orbital Relational Analytical Computing Logical Equation (5)
  • Oracle Certification (1)
  • Oracle Discoverer (4)
  • Oracle Interview Questions (45)
  • Oracle Pricing (9)
  • Oracle Property Manager (5)
  • Oracle Setup Steps (1)
  • Oracle Standard Reports (25)
  • org (5)
  • OUM Methodology (1)
  • Outlook (1)
  • Output type in Oracle (1)
  • P2P Cycle (17)
  • Password in EBS (3)
  • Payroll (2)
  • Personalize OAF Pages (16)
  • PL/SQL (53)
  • PO (83)
  • Printer Assign process (1)
  • profile (10)
  • Projects (58)
  • Pure Silence for Life... :) (1)
  • QUERY (3)
  • R12 (3)
  • RDF report (5)
  • Receipt (1)
  • Reconciled Payments (2)
  • REPORT (15)
  • REPORT NAMES (1)
  • REPORT_QUERY (12)
  • request group (2)
  • Request Set (3)
  • Reset the po (2)
  • Responsibility (24)
  • RICE (1)
  • Row count (1)
  • Shell Script (6)
  • Shortcut Key (1)
  • SLA (13)
  • SOB (3)
  • SQL (98)
  • SRW.user_exit (2)
  • SUB_QUERY (1)
  • Supplier (29)
  • sysadmin (17)
  • Tables (71)
  • TAX (17)
  • TCA R12 (7)
  • technical (4)
  • Time Formets (3)
  • TOAD (3)
  • Trace (3)
  • UPDATE QUERY (20)
  • User Hooks (1)
  • USER_RES_MENU (14)
  • Valueset (18)
  • Videos (6)
  • VPD in Oracle (1)
  • Web ADI in Oracle (4)
  • Windows XP (1)
  • WIP (2)
  • Workflow (5)
  • XLA_SUB_LEDGER (20)
  • xml (91)

Blog Archive

  • ▼  2012 (301)
    • ▼  January (34)
      • XLA_TRANSACTIONS
      • responsibility_prompt
      • JOIN CONDITIONS USED IN ORACLE APPS(GL,AP,AR,INV ETC)
      • R12 BANK TABLE AND QUERY
      • BANK TO SUPPLIER QUERY
      • BANK INFORMATION TO SUPPLIERS
      • R12 AP Tax Tables
      • gl drill down to ap invoice liablity account In R12
      • gl_drill_down_to_ap_invoice_liablity_account
      • USER_MENU AND RESPONSIBILITY_QUERY
      • NUMBER TO WARD
      • AR Salce Invoice
      • AR RECEIPT TO INVOICE QUERY
      • invoice to gl
      • invoice to gl
      • SEQUENCE_UPDATE_QUERY
      • gl_segment1_definition_query_in_11i
      • Unposted_Jurnales_in_gl
      • Inventory
      • SELECT AND UPDATE THE SAME QUERT
      • PO_RECEIPT_WITH_TAX
      • PO RECEIPT WITH ACCOUNT
      • ALL INVENTORY ORGANIZATION REPORT
      • CURSOR_UPDATE
      • ON HAND QUENTITY QUERY
      • CURSOR_USING_UPDATE
      • UPDATE_MORE_THEN_ONE_COLUMN_IN_TABLE
      • PO RECEIPT ACCOUNTING QUERY (CREDIT,DEPIT)
      • PURCHASE TAX DETAIL QUERT
      • REPORTS Interview Questions
      • which responsibility user has ran
      • Find the Responsibility name
      • How to find all Form Personalization through scrip...
      • REPORT INTERVIEW QUESTON

Tag » Ar_cash_receipts_all And Ra_customer_trx_all