Query to get AR invoice SLA and GL details
AR Transaction Subledger and general ledger details
Oracle receivable subledger accounting and general ledger link
Oracle apps AR SLA and gl details
--Query to get AR invoice SLA and GL details
SELECT rct.trx_number,
b.name batch_name,
h.name journal_name,
b.description batch_description,
h.je_category,
h.je_source,
h.period_name je_period_name,
h.status journal_status,
h.description je_description,
l.je_line_num line_number,
l.accounted_dr,
l.accounted_cr,
rct.customer_trx_id,
rctd.cust_trx_line_gl_dist_id,
xal.entered_dr,
xal.entered_cr,
xal.accounting_class_code,
xal.code_combination_id,
xah.event_id,
xal.ae_header_id,
xlate.entity_code,
h.je_category
FROM apps.gl_je_batches b,
apps.gl_je_headers h,
apps.gl_je_lines l,
apps.gl_import_references gir,
ra_customer_trx_all rct,
ra_cust_trx_line_gl_dist_all rctd,
xla_ae_headers xah,
xla_ae_lines xal,
xla_events xet,
xla_distribution_links xdl,
xla.xla_transaction_entities xlate
WHERE h.je_header_id(+) = l.je_header_id
AND l.je_header_id(+) = gir.je_header_id
AND l.je_line_num(+) = gir.je_line_num
AND gir.je_batch_id = b.je_batch_id(+)
AND gir.gl_sl_link_table(+) = xal.gl_sl_link_table
AND gir.gl_sl_link_id(+) = xal.gl_sl_link_id
AND xal.ae_header_id = xah.ae_header_id
AND xet.event_id = xah.event_id
AND xdl.event_id = xet.event_id
AND xdl.ae_header_id = xah.ae_header_id
AND xdl.ae_line_num = xal.ae_line_num
AND xdl.application_id = 222
-- AND xdl.source_distribution_type IN
-- ('RA_CUST_TRX_LINE_GL_DIST_ALL', 'MFAR_DISTRIBUTIONS_ALL')
AND xlate.entity_code = 'TRANSACTIONS'
AND h.je_source(+) = 'Receivables'
-- AND h.je_category(+) = 'Credit Memos'
AND xet.entity_id = xlate.entity_id
AND xet.application_id = xlate.application_id
AND rct.customer_trx_id = xlate.source_id_int_1
AND xdl.source_distribution_id_num_1 = rctd.cust_trx_line_gl_dist_id
AND rct.customer_trx_id = rctd.customer_trx_id
AND rct.trx_number = '123123';
Related posts:
- How to Retrieve Period to Date (PTD) and Year to Date (YTD) Balances of GL Account in Oracle R12
- Query to find all Expense report entry delegations
- Query to find vacation rules in Oracle R12
- View accounting query in oracle apps R12
- Query to get AR invoice SLA and GL details
- Accounting entries not transferred to the General Ledger
- Query to find all APIs of Oracle Apps modules
- R12 AR cash receipt SLA and GL details query
- Oracle apps AR Applications and SLA details
- Oracle EBS query to get AP Invoice SLA Details
- Oracle EBS query to get AR Invoice SLA Details
- Oracle AR Remit to address query
- Oracle Apps iExpense credit card details query
- Query to get customer tax registration details in R12
- Purchase Requisition Vertex debug xml query in Oracle EBS
- Purchase Order Vertex debug xml query in Oracle EBS
- AP Invoice Vertex debug xml query in Oracle EBS
- AR Invoice Vertex debug xml query in Oracle EBS
- Query to find AP invoice workflow item key in oracle apps
- Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
- Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation
- Query to find Sales Orders that are shipped but not invoiced
- Query to get Customer Bank Account Details
- Query to get description of GL Code Combination
- Query to find Purchase Order and Invoice Details
- Query to find AP Invoices matched with receipts
- Query to find Supplier Bank Details
- Query to find Credit Memos on an AP invoice
- Query to find the AP invoices that are applied to multiple Purchase Orders
- AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
- Query to find shipset and fulfilment set