Oracle EBS query to get AR Invoice SLA Details
Oracle apps query to find Receivable transaction and XLA table details
ra_customer_trx_all and xla_ae_headers join
R12 receivables and subledger accounting join
--Query to get AR invoice SLA details
SELECT rct.trx_number,
rct.customer_trx_id,
rctd.cust_trx_line_gl_dist_id,
xal.entered_dr,
xal.entered_cr,
xal.code_combination_id,
xah.event_id,
xal.ae_header_id,
xah.*
FROM ra_customer_trx_all rct,
ra_customer_trx_lines_all rctl,
ra_cust_trx_line_gl_dist_all rctd,
xla_ae_headers xah,
xla_ae_lines xal,
xla_events xet,
xla_distribution_links xdl
WHERE 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 xdl.source_distribution_id_num_1 = rctd.CUST_TRX_LINE_GL_DIST_ID
AND rctl.customer_trx_line_id = rctd.customer_trx_line_id
AND rct.customer_trx_id = rctl.customer_trx_id
AND rct.trx_number = :p_trx_number;
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