AR Receipt Query: AR XLA GL - ORACLE MASTERMINDS

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

Maybe your like

Sunday, 11 January 2015

AR Receipt Query: AR XLA GL

SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product, glcc.segment6 channel, glcc.segment7 project, (SELECT flex_value || ' ' || fvt.description FROM apps.gl_code_combinations glc, apps.fnd_flex_values fv, apps.fnd_flex_values_tl fvt WHERE glc.code_combination_id = gjl.code_combination_id AND glc.segment4 = fv.flex_value AND fv.flex_value_set_id = 1002653 -- AND ap1.invoice_id = aia.invoice_id AND fv.flex_value_id = fvt.flex_value_id) code_combo_desc, gjh.posted_date posted_on_dt, gjh.je_source, gjh.je_category, gjb.NAME je_batch_name, gjh.NAME journal_name, '' je_seq_name, '' je_seq_num, gjl.je_line_num je_line, gjl.description je_line_descr, xal.entered_cr global_cr, xal.entered_dr global_dr, xal.currency_code global_cur, ac.customer_name vendor_customer, acra.receipt_number transaction_num, acra.receipt_date transaction_date, xal.accounting_class_code transaction_type, xal.accounted_cr local_cr, xal.accounted_dr local_dr, gl.currency_code local_cur, (NVL (xal.accounted_dr, 0) - NVL (xal.accounted_cr, 0) ) transaction_amount, gl.currency_code transaction_curr_code, gjh.period_name fiscal_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.ar_cash_receipts_all acra, xla.xla_transaction_entities xte, xla.xla_ae_lines xal, xla.xla_ae_headers xah, apps.gl_code_combinations glcc, apps.gl_import_references gir, apps.gl_je_lines gjl, apps.gl_je_headers gjh, apps.gl_ledgers gl, apps.gl_balances gb, apps.ar_customers ac, apps.gl_je_batches gjb WHERE 1 = 1 AND acra.customer_site_use_id = ac.customer_id(+) AND xte.ledger_id = gl.ledger_id AND xte.entity_code = 'RECEIPTS' AND NVL (xte.source_id_int_1, -99) = acra.cash_receipt_id AND xte.application_id = xal.application_id AND xte.entity_id = xah.entity_id AND xal.ae_header_id = xah.ae_header_id AND xal.application_id = xah.application_id AND xal.code_combination_id = glcc.code_combination_id AND xal.gl_sl_link_id = gir.gl_sl_link_id AND xal.gl_sl_link_table = gir.gl_sl_link_table AND gir.je_header_id = gjl.je_header_id AND gir.je_line_num = gjl.je_line_num AND gjl.je_header_id = gjh.je_header_id AND gjh.ledger_id = gl.ledger_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 gjh.je_batch_id = gjb.je_batch_id AND glcc.segment4 = '20330' AND gjh.period_name = 'NOV-14' AND gjh.je_source = 'Receivables'--and ACRA.CASH_RECEIPT_ID = 273042246 Posted by at 23:44 Labels: oracle receivables, SQL Queries

No comments:

Post a Comment

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 And Xla_ae_headers