R12 AR cash receipt SLA and GL details query
EBS Oracle apps Receivables cash receipt subledger accounting and General Ledger details query
ar_cash_receipts_all xla_ae_headers xla_ae_lines gl_je_headers gl_je_lines
SELECT rct.receipt_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,
xlal.ae_line_num,
xlal.accounting_class_code,
xlal.accounted_dr,
xlal.accounted_cr,
xlal.currency_code,
xlal.description,
xlal.accounting_date,
xlal.creation_date,
xlah.accounting_entry_status_code,
xlah.gl_transfer_status_code
FROM apps.gl_je_batches b,
apps.gl_je_headers h,
apps.gl_je_lines l,
apps.gl_import_references gir,
apps.xla_ae_lines xlal,
apps.xla_ae_headers xlah,
apps.xla_events xlae,
xla.xla_transaction_entities xlate,
apps.ar_cash_receipts_all rct
WHERE 1 = 1
AND 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(+) = xlal.gl_sl_link_table
AND gir.gl_sl_link_id(+) = xlal.gl_sl_link_id
AND xlal.ae_header_id = xlah.ae_header_id
AND xlah.event_id = xlae.event_id
AND xlae.entity_id = xlate.entity_id
AND xlae.application_id = xlate.application_id
AND xlate.entity_code = 'RECEIPTS'
AND h.je_source(+) = 'Receivables'
AND h.je_category(+) = 'Receipts'
AND rct.cash_receipt_id = xlate.source_id_int_1
AND receipt_number = '12345678'
ORDER BY xlal.creation_date, b.name, xlal.ae_line_num;
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