AR Receipts To GL Link In Oracle R12

Home » Ar_cash_receipts_all And Xla_ae_headers » AR Receipts To GL Link In Oracle R12

Maybe your like

Wednesday, 19 August 2015

AR Receipts to GL link in oracle R12

/* Formatted on 8/19/2015 6:17:53 PM (QP5 v5.240.12305.39446) */SELECT glp.start_date, gjh.je_header_id, gjh.doc_sequence_value voucher_no, gjh.je_source, gjh.je_category, entity_code, gjh.period_name, gjh.status, gjh.actual_flag, gjh.default_effective_date, gjl.je_line_num, gjl.code_combination_id, gjl.description voucher_desc, xal.accounted_dr debit, xal.accounted_cr credit, gcc.segment1 || '-' || gcc.segment2 || '-' || gcc.segment3 || '-' || gcc.segment4 || '-' || gcc.segment5 || '-' || gcc.segment6 || '-' || gcc.segment7 account_code, TO_CHAR (acr.receipt_number) trx_num, acr.receipt_date trx_date FROM gl.gl_je_headers gjh, gl.gl_je_lines gjl, gl.gl_code_combinations gcc, gl.gl_periods glp, gl.gl_import_references imp, xla.xla_ae_lines xal, xla.xla_ae_headers xah, xla.xla_events xe, xla.xla_transaction_entities xte, ar_cash_receipts_all acr WHERE 1 = 1 AND gjh.je_header_id = gjl.je_header_id AND gjl.status || '' = 'P' AND gjl.code_combination_id = gcc.code_combination_id AND gjh.period_name = glp.period_name AND glp.period_set_name = :p_period_set_name AND glp.adjustment_period_flag <> 'Y' AND gjh.je_source = 'Receivables' AND gjl.je_header_id = imp.je_header_id AND gjl.je_line_num = imp.je_line_num AND imp.gl_sl_link_id = xal.gl_sl_link_id AND imp.gl_sl_link_table = xal.gl_sl_link_table AND xal.application_id = xah.application_id AND xal.ae_header_id = xah.ae_header_id AND xah.application_id = xe.application_id AND xah.event_id = xe.event_id AND xe.application_id = xte.application_id AND xte.application_id = 222 AND xe.entity_id = xte.entity_id AND xte.entity_code = 'RECEIPTS' AND xte.source_id_int_1 = acr.cash_receipt_id AND gjh.default_effective_date BETWEEN :p_period_from_start_date AND :p_period_to_end_date AND (gjh.actual_flag = :p_actual_flag OR :p_actual_flag IS NULL) Posted by at 18:18 Labels: AR_Query

No comments:

Post a Comment

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

  • ▼  2015 (254)
    • ▼  August (28)
      • How to enable shortcut keys in oracle apps
      • O2C full cycle in oracle R12
      • Ap supplier site update API in oracle apps
      • Order to Cash full cycle and Techno-Functional flo...
      • Oracle Applications Interface Programs
      • Customer Interface in AR and 11i R12 tables in ora...
      • Payment Due Calculation on AP invoice in oracle apps
      • PO to Invoice detail query in oracle apps
      • SQL Query to get payslip of an employee
      • Inventory to GL link in R12
      • GL Entries with AP Payments Query in oracle apps
      • GL Entries with the AR Transaction (Invoices) Quer...
      • AR Receipts to GL link in oracle R12
      • AR Adjustments to GL query in oracle apps
      • Workflow: SQL Query to get workflow notification e...
      • Void Payment in Oracle Payable
      • PAYMENT_TYPE_FLAG in AP_CHECKS_ALL table in oracle...
      • How to find the number of row in oracle table usin...
      • Oracle GRC Overview
      • Oracle Materialized Views
      • Oracle Projects to Invoice Flow in oracle apps
      • GL to FA link in oracle apps R12
      • Asset Register Query in oracle apps
      • invoice,vendor, project related details of assets ...
      • Ssset information and their depriciation details q...
      • oracle okc contracts core table in r12
      • Oracle sourcing tables in apps
      • Important DBA Tables in Oralce Apps

Tag » Ar_cash_receipts_all And Xla_ae_headers