Oracle AR Receipt Accounting SQL For Fusion

Home » Ar_cash_receipts_all And Xla_ae_headers » Oracle AR Receipt Accounting SQL For Fusion

Maybe your like

Pages

  • Home
  • SOA
  • Fusion BI Reporting
  • Fusion BI Reports SQL
  • Fusion Quick Ref SQL
  • OAF
  • WedADI
  • Workflow
  • Reports
  • Debugging
  • FNDLOAD
  • Concurrent Programs
  • Quick Reference API
  • Form Personalization
  • Quiz

Thursday, 7 March 2019

Oracle AR Receipt Accounting SQL for fusion

SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product, glcc.segment6 channel, glcc.segment7 project, 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, 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, gl.NAME ledger_name FROM ar_cash_receipts_all acra, xla_transaction_entities xte, xla_ae_lines xal, xla_ae_headers xah, gl_code_combinations glcc, gl_import_references gir, gl_je_lines gjl, gl_je_headers gjh, gl_ledgers gl, gl_balances gb, gl_je_batches gjb WHERE 1 = 1 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 ACRA.CASH_RECEIPT_ID = 300000005465113 Posted by Labels: Fusion-SQL, Receivables

2 comments:

  1. Smith10 November 2019 at 21:55

    Oracle Apps R12 and Fusion Cloud Self Paced Training Videos Published on Udemy with Live Meeting Support. Please Check https://www.oracleappstechnical.com

    ReplyDeleteReplies
      Reply
  2. Ames Cody19 March 2021 at 00:39

    I wish to show thanks to you just for bailing me out of this particular trouble. As a result of checking through the net and meeting techniques that were not productive, Same as your blog I found another one Oracle Fusion Product Hub.Actually I was looking for the same information on internet for Oracle PPM Cloud and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

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

Disclaimer

The views expressed are my own and not necessarily those of Oracle and its affiliates. The views and opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine. I am not responsible if you ever happen to suffer a loss/damage using this blog.

Labels

  • ADF (1)
  • AOL (2)
  • API (4)
  • Arabic-Specific Customization (1)
  • Assets (1)
  • Cash Management (3)
  • Concurrent Program (5)
  • Data Structures (1)
  • Debugging (2)
  • External Table (1)
  • FNDLOAD (1)
  • Form Personalization (5)
  • Fusion Reports SQL (6)
  • Fusion-BIP (30)
  • Fusion-SQL (3)
  • General Ledger (3)
  • HCM (3)
  • Interview Questions (5)
  • JavaScript (3)
  • leetcode (1)
  • nodeJs (1)
  • OAF (20)
  • Oracle Application Developer Guide (1)
  • Oracle Technical Various (2)
  • Order Management (2)
  • Payables (7)
  • PL/SQL (14)
  • PLSQL Web Service (2)
  • Procurement (1)
  • R12 Scripts (4)
  • Receivables (9)
  • Reports (5)
  • RTF Coding (34)
  • SOA (1)
  • SQL (6)
  • SQL Hints (1)
  • SQL LOADER (2)
  • SQL Optimization (1)
  • Subtemplates (1)
  • Table Relations (2)
  • UTL_FILE (2)
  • VM (1)
  • WEB ADI (8)
  • Workflow (5)
  • XML (5)
  • XML Publisher (21)
  • XSLT (3)

Pages

  • Home
  • Quiz
  • Workflow
  • Reports
  • Form Personalization
  • Quick Reference API
  • Fusion Quick Ref SQL
  • OAF
  • ADF
  • WedADI
  • Concurrent Programs
  • FNDLOAD
  • Debugging

Followers

Total Hits

Contact Form

Name Email * Message *

Blog Archive

  • ▼  2019 (67)
    • ▼  March (11)
      • Oracle Apps: Basic Tables
      • Database Not Open Error
      • Oracle Fusion Financials Tables and Views Link
      • plsql authid current_user explained
      • plsql utl_file put_line, get_line
      • Handle oracle.xdo11g.xqxp.XQException at oracle.x...
      • Oracle AR Receipt Accounting SQL for fusion
      • NodeJs : Getting Started With
      • How to Define a Promise and call it in JavaScript
      • How to call a XMLHttpRequest in javascript
      • How to define callback function in Java script

Popular Posts

  • New tables in R12 for Payables and to what R12 objects are obsoleted 11i tables mapped Suppliers New R12 tables  -> Old 11i Tables AP_SUPPLIERS - replaces PO_VENDORS AP_SUPPLIER_SITES_ALL- replaces PO_VENDOR_SITES_ALL Ad...
  • page breaks in rtf template there are 3 ways to create page breaks <?split-by-page-break:?> #below code should be written inside the BIP Field element <x...
  • PL-SQL Interview Questions Collections 2. What is the basic structure of PL/SQL? PL/SQL uses block structure as its basic structure. Anonymous...
  • Understand Loops in BI Publisher: for-each vs for-each-group vs for-each: current-group xml grouping SUPPLIERS INVOICES Required: SUPPLIERS CURRENCY INVOICES ‘for-each-group’ to regroup to show the in...
  • SQL: Requisition to PO: Oracle Fusion SELECT POH.PO_HEADER_ID, POH.SEGMENT1  , PRHA.REQUISITION_NUMBER FROM PO_HEADERS_ALL POH, PO_DISTRIBUTIONS_ALL PDA , POR_REQ_DISTRIBU...
  • Parameterized Popup in OAF for R12.1.3 As per Dev Guide, There are two popup screen we can prepare in OAF, embedded and Parametrized, oracle has its tutorial on embedded pop...
  • Handle Null or Not Present tags in xml file in BI Publisher Workaround Option 2 in RTF template If using RTF templates another option is to use a conditional IF at the template level to verify the ...
  • Creating Search Insert Update Delete On Same Page in OAF I would provide an example of Creating Search Insert Update Delete On Same Page in OAF Outline of the Development Steps A. Create DB Com...
  • Dependent LOV in WEBADI using Java validator 1. Create a webadi for invoice/supplier load 2. Interface Fields     a. vendor name ()     b. vendor site code () 3. based on the valu...
  • Oracle Fusion Business Unit, Ledgers, Value Set SQLs --BUSINESS UNIT ---------------------- SELECT BusinessUnitEO.NAME BU_NAME,   LocationDPEO.DESCRIPTION LOCATION,   PersonNameDPEO.LIST_NA...

Live

Tag » Ar_cash_receipts_all And Xla_ae_headers