AR Receipt Query: AR XLA GL - Doyensys Blog

Home » Ar_cash_receipts_all Query » AR Receipt Query: AR XLA GL - Doyensys Blog

Maybe your like

  • Oraculars
  • Contact
AR Receipt Query: AR XLA GL Home > EBS Technical > AR Receipt Query: AR XLA GL

Description:

The below steps describe the responsibilities to check the AR Receipt Query on 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

Summary:

This Post explained what are the steps should follow to AR Receipt Query for AR XLA GL

Queries?

Do drop a note by writing us at [email protected] or use the comment section below to ask your questions.

Venkatesh Balasubramanian Venkatesh Balasubramanian
  • venkatesh.b@doyensys.com
Recent Posts
  • Script to import standard purchase order
  • Query to get Journal Entry Reserve Ledger Report
  • Connect Your Oracle Cloud VCNs Like a Pro: The Complete Local Peering Gateway Guide
Follow Us

Post navigation

Previous post

How to Set Interactive Report Filter with URL Parameters

Next post

How to JQuery Id selector in ADF

Tag » Ar_cash_receipts_all Query