AR Receipt Distribution Query: AR XLA GL - ORACLE MASTERMINDS

Home » Ar_cash_receipts_all Query » AR Receipt Distribution Query: AR XLA GL - ORACLE MASTERMINDS

Maybe your like

Sunday, 11 January 2015

AR Receipt Distribution Query: AR XLA GL

SELECT glcc.segment1 co, glcc.segment2 loc, glcc.segment3 cc, glcc.segment4 acct, glcc.segment5 prod, glcc.segment6 chan, glcc.segment7 proj, '' "CODECOMBO desc", xal.accounting_date, gjh.je_source, gjh.je_category CATEGORY, gjb.NAME batch, gjh.NAME "JOURNAL name", '' "JE SEQ name", '' "JE SEQ NUM", gjl.je_line_num "JE LINE", gjl.description "JE LINE DESCR", gjl.accounted_cr gl_cr, gjl.accounted_dr gl_dr, '' "VENDOR/CUSTOMER", acra.receipt_number "TRANSACTION NUM", xal.accounting_class_code "TRANSACTION TYPE", xal.accounted_cr xla_cr, xal.accounted_dr xla_dr, gjh.period_name period, (gb.begin_balance_dr - gb.begin_balance_cr) begin_balance, ( gb.period_net_dr - gb.period_net_cr + gb.project_to_date_dr - gb.project_to_date_cr ) end_balance, gl.NAME ledger_name FROM apps.gl_je_headers gjh, apps.gl_je_batches gjb, apps.gl_balances gb, apps.gl_ledgers gl, apps.gl_je_lines gjl, apps.gl_import_references gir, apps.gl_code_combinations glcc, apps.xla_ae_lines xal, apps.xla_ae_headers xah, apps.xla_distribution_links xdl, apps.ar_distributions_all ada, apps.ar_cash_receipt_history_all acrha, apps.ar_cash_receipts_all acra WHERE 1 = 1 AND gjh.ledger_id = gl.ledger_id AND gjh.je_batch_id = gjb.je_batch_id AND gjl.je_header_id = gjh.je_header_id AND gjl.je_header_id = gir.je_header_id AND gjl.je_line_num = gir.je_line_num AND gjl.code_combination_id = glcc.code_combination_id AND gir.gl_sl_link_id = xal.gl_sl_link_id AND gir.gl_sl_link_table = xal.gl_sl_link_table AND xal.ae_header_id = xah.ae_header_id AND xal.ae_header_id = xdl.ae_header_id AND xal.application_id = xah.application_id AND xal.ae_line_num = xdl.ae_line_num AND xal.application_id = xdl.application_id AND xdl.source_distribution_type(+) = 'AR_DISTRIBUTIONS_ALL' AND xdl.source_distribution_id_num_1(+) = ada.line_id AND ada.source_id = acrha.cash_receipt_history_id AND acrha.cash_receipt_id = acra.cash_receipt_id AND gb.code_combination_id = glcc.code_combination_id AND gb.period_name = gjh.period_name AND gb.currency_code = gl.currency_code AND glcc.segment4 = '13010' AND gjh.period_name = 'OCT-14' AND gl.NAME = 'Amazon.com, Inc.' AND gjh.je_source = 'Receivables'--and gjh.je_category = 'Receipts'--and GJH.name = 'OCT-14 Receipts USD' Posted by at 23:39 Labels: oracle receivables, SQL Queries

2 comments:

  1. saivenkat19 January 2021 at 20:30

    Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas. Expense Reports

    ReplyDeleteReplies
      Reply
  2. Anonymous26 June 2025 at 12:11

    Still helpful 10 years later. Thank you so much.

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

HOME

HOME

OTHER BLOGS

OTHER BLOGS - Powered by DOYENSYS

DOYEN DOMAINS

  • -Supplier Creation (1)
  • Account (1)
  • Active Users find Query (1)
  • ADC (1)
  • ADF (3)
  • Advanced Pricing (1)
  • Aging Bucket (1)
  • AIM (1)
  • AME (2)
  • AP (7)
  • AP Invoice Interface (1)
  • AP Invoice to employee links in fusion (1)
  • AP_INVOICES_ALL to PER_ALL_PEOPLE_F links in fusion (1)
  • AP_SUPPLIERS (1)
  • APEX (94)
  • API (10)
  • API Create a valid category set (1)
  • API to Assign Item to Inventory (1)
  • API to Create Item Category in Oracle Inventory (1)
  • API to Delete Valid Category Set (1)
  • API to Update the category description (1)
  • Approval Chain (1)
  • Approved Supplier List (1)
  • AR (4)
  • AR Aging (1)
  • AR to PA link (1)
  • AR Transaction (4)
  • ASL (1)
  • Assets (1)
  • Back 2 Back Order (2)
  • Balances (1)
  • Bank (1)
  • BI Publisher (7)
  • Bills Of Material (1)
  • Blanket Purchase Agreement (3)
  • Blanket Sales Agreement - BSA (3)
  • Blob (1)
  • BOM (1)
  • Brazil Localization (2)
  • buyer setup (1)
  • Capital project hours - includes PTO (1)
  • Catalgoue (1)
  • Colombian Localization (1)
  • Content Zone (1)
  • Conversion (1)
  • Conversions (1)
  • CPA (1)
  • CRM (1)
  • CRM resource (1)
  • CSS Plan - Inventory Organization (1)
  • CSV File (1)
  • Custom Form (1)
  • Customer PO (1)
  • Customization (1)
  • cXML (1)
  • Data Loader (1)
  • Databank configuration (2)
  • Database Table (2)
  • DBA Hiring (1)
  • DIR file list VALUE SET (1)
  • DIR Files list LOV (1)
  • Directory (1)
  • Discrete Jobs Cycle with Cost Rolll-up (1)
  • Document Manager Failed with Error Number 3 while processing Purchase Requisition XXXX (1)
  • Dropship Order (1)
  • EBS (2)
  • EBS Functional (57)
  • EBS Functional- AR Trx & Receipt Creation (1)
  • EBS Technical (44)
  • EBS to FUSION table changes (1)
  • Email (1)
  • Email Attachment (1)
  • Employee (3)
  • Employee-Supervisor Hierarchy (1)
  • employer cost (1)
  • Excel (1)
  • Excise (1)
  • Expense reports (2)
  • External bank (2)
  • FA (1)
  • File move Unix Script (1)
  • File rename Unix Script (1)
  • Finally Closed PO (1)
  • Finance (3)
  • Fixed Assets (2)
  • Form Personalization (1)
  • FORMS ERROR ORA- 00980 (1)
  • Fusion (13)
  • FUSION AP invoice query (1)
  • FUSION AR Tables (2)
  • Fusion PA Tables (6)
  • Fusion Report (1)
  • GL (3)
  • GL CODE (3)
  • GL Exchange Rates Query (1)
  • GL Period and Exchange Rates in Fusion (1)
  • GL Periods Query (1)
  • GL Revaluation query in Fusion (1)
  • GL table links in Fusion (1)
  • GL transactions (5)
  • GST (1)
  • GUID (1)
  • HR (1)
  • HRMS (5)
  • iExpense (1)
  • Intercompany (1)
  • Interface (1)
  • Internal Sales Order (1)
  • Inventory (11)
  • iProcurement (2)
  • IR & ISO (1)
  • Iterations run (1)
  • Java (1)
  • Javascript (3)
  • Jquery (1)
  • Json (1)
  • JSON File (1)
  • Lease (2)
  • Link between Ledger and Legal entity (1)
  • load files (1)
  • Load Objects (1)
  • Lockbox interface (1)
  • Login URL (1)
  • MAIL from Database (1)
  • Manual Shipping (1)
  • Menu (1)
  • Messages (1)
  • Min-Max Planning Method (2)
  • Move Orders (1)
  • OAF (1)
  • OATS (5)
  • OATS 12.5.0.2.537 Installation Strcuk/Hang. (1)
  • OLT Non Admin User Creation (1)
  • OLT user creation (1)
  • Open Project with Terminated PMs or PDs (1)
  • Open Script (2)
  • OPM Process flow (1)
  • OPM Setups (1)
  • OPM Transactions (1)
  • OPM. Process Manufacturing (1)
  • ORA -00980 (1)
  • ORA -00980 Synonym (1)
  • ORA Errors (1)
  • Oracle (10)
  • Oracle Alerts (2)
  • Oracle Apps (1)
  • oracle apps form error ORA-00980 (1)
  • Oracle Apps R12 (1)
  • Oracle EBS (1)
  • Oracle Forms (5)
  • Oracle Fusion (4)
  • Oracle Fusion GUID (1)
  • Oracle Fusion HCM (1)
  • Oracle Fusion surrogate ID (1)
  • Oracle iProcurement (1)
  • oracle load Testing User Creation in Windows (1)
  • oracle payables (3)
  • Oracle Process Manufacturing Oracle Product Development. (1)
  • oracle receivables (4)
  • Oracle Reports (1)
  • oracle utl_smtp (1)
  • Order Management (17)
  • OTM (1)
  • PA Billing Events tables joins (1)
  • PA invoice details in Fusion (1)
  • PA Invoice tables in Fusion (1)
  • PA Revenue Tables in fusion (1)
  • PA Table changes (1)
  • PA to employee links (1)
  • PA to XLA links (1)
  • PA to XLA links in fusion (1)
  • Password (1)
  • Password of Application User (1)
  • Payment (1)
  • Payroll (1)
  • Performance tuning (1)
  • Physical Counting (1)
  • PL/SQL (16)
  • PLSQL Function in SQL Query Fusion (1)
  • PO (4)
  • PO Approval (1)
  • PO Category (1)
  • Preparer (1)
  • Price Tolerances (1)
  • Profile Option (3)
  • Program for Return to Vendor in Oracle purchasing (1)
  • Program to create receipts for approved Purchase order (1)
  • Project Accounting (1)
  • Project Contract Table Links in Fusion (1)
  • Project Cost query (1)
  • Project Details query Fusion (1)
  • Project Directory query in Fusion (1)
  • Project invoice query in fusion (1)
  • Project Manager query in Fusion (1)
  • Project Revenue query in fusion (1)
  • Project table to Project Revenue Table links (1)
  • Project to Revenue table links in fusion (1)
  • Project Unbilled (1)
  • Project Unbilled Balances query in Fusion (1)
  • Projects (1)
  • Property Management (4)
  • Punchout (1)
  • Punchout from Oracle iProcurement Directly to Supplier-Hosted Catalog (cXML) (1)
  • Purchase Order (2)
  • Purchase Requisition Approval (1)
  • Purchasing (17)
  • Purchasing News. Excel Link in iProc (1)
  • Purchasing. (1)
  • Query (1)
  • R12 Upgrade (1)
  • Receipt Register (1)
  • Receipt Register Report (1)
  • Receipt with Bank statement details (1)
  • Receiving (5)
  • Receiving Issues (1)
  • Repetitive Schedule (1)
  • Requisition (1)
  • Responsibilities and Users (1)
  • Returns/Cancellation (1)
  • Revenue transfer (1)
  • RMA (1)
  • Sales Quotes (1)
  • Sales Tax (1)
  • Salesrep (1)
  • Security Hierarchy (1)
  • Setup (1)
  • Setups (1)
  • SGA Details - JROD COPY (1)
  • Shipping Exceptions (1)
  • SLA (1)
  • smtp mail (1)
  • Source key (1)
  • Sourcing Rules (1)
  • SQL Queries (30)
  • SQL query (4)
  • Stores (1)
  • Submenu (1)
  • Supplier (3)
  • Supplier Hosted catalogue (1)
  • Supplier to AP invoices links (1)
  • Surrogate ID (1)
  • Tax (2)
  • TCS (1)
  • Tool Tip (1)
  • Transaction Type UTL Mail (1)
  • Type2b Punchout (1)
  • Under Tolerance Shipment (1)
  • UOM (1)
  • Update (1)
  • Upload (1)
  • Use with class in SQL (1)
  • User key (1)
  • Users and Responsibilities (1)
  • UTL_SMTP (1)
  • validation (3)
  • Vendor Ledger (1)
  • WHT (1)
  • WIP (3)
  • Workflow (3)
  • Workflow Status (1)
  • XLA (3)
  • XML (3)
  • XML Publisher (1)

Popular Posts

  • Sales Order Dispatch details (Link between Material Transactions and Invoice)
  • IR & ISO - Internal Sales Order Cycle with Setup Steps in R12.2
  • How to Add or Assign the Printer to a desired Reports
  • ORACLE WORK IN PROCESS SETUP DOCUMENT IN R12.2
  • Oracle Order Management Setup Document in R12.2
  • API to Update a Customer Account TCA R12
  • Fusion HCM - Query for Personal Payment Method Details
  • Find the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Date Wise in Oracle Apps EBS R12
  • AR Receipt Distribution Query: AR XLA GL
  • AR Transactions Query: AR XLA GL

Blog Archive

  • ▼  2015 (96)
    • ▼  January (23)
      • AP Pre Payments Query: AP XLA GL
      • AP Distribution Query: AP XLA GL
      • AR Adjustments Query: AR XLA GL
      • AR Transactions Query: AR XLA GL
      • AR Receipt Query: AR XLA GL
      • AR Receipt Distribution Query: AR XLA GL
      • Report Builder Components
      • AIM Document Specifications
      • How to find error messages while doing Oracle work...
      • Setting Timeout for a Notification in Oracle Workflow
      • Displaying subtotal and grand total based on the g...
      • Implementing Search Functionality using LOV during...
      • Parsing Comma Separated string in WHERE Clause of ...
      • How to change a LOV query Using Forms Personalization
      • Problems while creating the New Locations in Oracl...
      • GENERAL LEDGER PRIMER ORACLE GENERAL LEDG...
      • AMEX Payment Process
      • Inventory Module Setup in Oracle EBS R12.2
      • Trigger Enhancements in Oracle Database 11g Release 1
      • Session State Protection in APEX
      • Clearing Session State in APEX
      • Multiple User Interface for Oracle APEX
      • Integrating With Fusion Application Using Services...

Contributors

  • Anand Kumar Palanisamy
  • Anand Rajendran
  • Beena Thomas
  • BlazeDream
  • Dhiraj
  • DoyenTeam
  • K Nikethan Reddy
  • Mohan G
  • Prathap Nagarajan
  • Prem Shanker Singh
  • SIVACHANDARAN
  • Tapas Kumar Sathua
  • Unknown
  • Unknown
  • Unknown
  • Unknown
  • Unknown
  • Vimal
  • gopikakuru

Total Pageviews

Tag » Ar_cash_receipts_all Query