GL To AR Receipts Drill Down Query - Oracle Application's Blog

skip to main | skip to sidebar Oracle Application's Blog

The purpose of this blog , is to do Knowledge sharing with my Followers through my own Experiences. Contact us for Oracle Applications Job Support , Project Support and any other freelancing work.

• About us
• Fusion E-Books
• Workflows
• OAF
• Interfaces
• Scripts
• XML
• Fusion Technical
• Fusion Financial
• EBS

Tuesday, 3 December 2019

GL to AR receipts drill down query

GL to AR receipts drill down query

In this post , We will be discuss about the GL to AR receipt drill down SQL query in oracle apps. To find out the AR receipt information from AR to GL we need to have this GL to AR receipt drill down sql query. To write any drill down sql query from Subledger to GL , we need to have the XLA tables , which helps to link the AR subledger module with GL module. Here below , i share the detail GL to AR receipt drill down sql query in oracle apps.

Important tables of GL to AR receipts drill down SQL query

1.gl_je_headers 2.gl_je_batches 3.gl_balances 4.gl_ledgers 5.gl_je_lines 6.gl_import_references 7.gl_code_combinations 8.xla_ae_lines 9.xla_ae_headers 10.xla_distribution_links 11.ar_distributions_all 12.ar_cash_receipt_history_all 13.ar_cash_receipts_all

Detail GL to AR receipts drill down SQL query in oracle apps

SELECT xal.accounting_date, gjh.je_source, gjh.je_category CATEGORY, gjb.NAME batch, gjh.NAME "JOURNAL name", gjl.je_line_num "JE LINE", gjl.description "JE LINE DESCR", gjl.accounted_cr gl_cr, gjl.accounted_dr gl_dr, acra.receipt_number , xal.accounting_class_code "TRANSACTION TYPE", xal.accounted_cr xla_cr, xal.accounted_dr xla_dr, gjh.period_name period, gl.NAME ledger_name, glcc.segment1||'-'||glcc.segment2||'-'||glcc.segment3||'-'||glcc.segment4||'-'||glcc.segment5||'-'||glcc.segment6 GL_ACCOUNT FROM apps.gl_je_headers gjh, apps.gl_je_batches gjb, apps.gl_balances GL_BANC, 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 gjh.period_name = 'APR-14' AND gjh.je_source = 'Receivables' 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 GL_BANC.code_combination_id = glcc.code_combination_id AND GL_BANC.period_name = gjh.period_name AND GL_BANC.currency_code = gl.currency_code AND glcc.segment4 = :P_ACCOUNT at 21:33 Labels: GL to AR receipts drill down query

0 comments:

Post a Comment

Newer Post Older Post Home

Contact us for any Collaboration, Project Support & On Job Support Work

Name Email * Message *

Know More About Us

• Products & Offerings

Learn Fusion Financials' (Online Book)

Click To Download

Oracle Fusion Self Paced Trainings in Discounted Prices

Click to know more

Buy Oracle Cloud Instance Access (Click to Know More)

Oracle Fusion/EBS Interview's Question Answer Series

• Top 33 Oracle Fusion Order Management Interview Questions
• TOP 31 Oracle Fusion SCM Cloud Interview Questions
• TOP 21 Oracle Fusion HCM Interview Questions
• Complete Tax Setups in Oracle Fusion
• Top 50 oracle reports interview questions
• 33 Most Important Oracle Fusion fixed assets interview questions
• TOP 33 Most Important Oracle Apps Technical Interview Questions
• 25 Most Important Oracle receivable interview questions
• 21 Most Important Oracle r12 Payables Interview Questions
• TOP 20 general ledger interview questions in oracle apps r12
• TOP 23 Most Important Oracle Fusion Interview Questions
• TOP 23 Most Important oaf interview questions

Online Oracle Courses (Free of Cost)

• Complete Tax Setups in Oracle Fusion
• Learn Tax Implementation in Oracle Fusion
• Learn P2P Cycle in Oracle Fusion
• Learn Oracle Reports XML Tutorial
• Learn Oracle Fusion Custom Roles Tutorial
• Learn Oracle Fusion Technical Online
• Learn Oracle Fusion/cloud Financials Online
• Learn Oracle Cloud BPM Online
• Learn Complete OAF Step by Step Online
• Learn Oracle Workflow Builder Online

Online Fusion Application Composer/Customization Book

Online Fusion Application Composer/Customization Book Click To Know More

Oracle Fusion Technical Book

Oracle Fusion Technical Book

Oracle Fusion Web Services(REST& SOAP API's) / Integration Book

Contact Me

[email protected]

Most Viewed Posts

Report Bursting in oracle fusion AR to GL reconciliation in oracle apps r12 Set the override email address in Oracle Fusion How to Create PO and Receiving Inquiry(View Only) Role in Oracle Fusion How to create a new Oracle apps Data base source to Design the BIP reports How to add hyperlink in the email body using Bursting in Oracle Cloud BIP reports What is Rapid Implementation in Oracle Cloud : Rapid Implementation Data Upload Process in Oracle Fusion Drill Down OTBI reports to Navigate Directly in to Oracle Cloud Payment Page How to create vacation rules in Oracle cloud TOP 30 Most Important OAF Interview Questions