R12 AR cash receipt SLA and GL details query
•By admin
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
SQL Querysql
1SELECT rct.receipt_number,
2 b.name batch_name,
3 h.name journal_name,
4 b.description batch_description,
5 h.je_category,
6 h.je_source,
7 h.period_name je_period_name,
8 h.status journal_status,
9 h.description je_description,
10 l.je_line_num line_number,
11 l.accounted_dr,
12 l.accounted_cr,
13 xlal.ae_line_num,
14 xlal.accounting_class_code,
15 xlal.accounted_dr,
16 xlal.accounted_cr,
17 xlal.currency_code,
18 xlal.description,
19 xlal.accounting_date,
20 xlal.creation_date,
21 xlah.accounting_entry_status_code,
22 xlah.gl_transfer_status_code
23 FROM apps.gl_je_batches b,
24 apps.gl_je_headers h,
25 apps.gl_je_lines l,
26 apps.gl_import_references gir,
27 apps.xla_ae_lines xlal,
28 apps.xla_ae_headers xlah,
29 apps.xla_events xlae,
30 xla.xla_transaction_entities xlate,
31 apps.ar_cash_receipts_all rct
32 WHERE 1 = 1
33 AND h.je_header_id(+) = l.je_header_id
34 AND l.je_header_id(+) = gir.je_header_id
35 AND l.je_line_num(+) = gir.je_line_num
36 AND gir.je_batch_id = b.je_batch_id(+)
37 AND gir.gl_sl_link_table(+) = xlal.gl_sl_link_table
38 AND gir.gl_sl_link_id(+) = xlal.gl_sl_link_id
39 AND xlal.ae_header_id = xlah.ae_header_id
40 AND xlah.event_id = xlae.event_id
41 AND xlae.entity_id = xlate.entity_id
42 AND xlae.application_id = xlate.application_id
43 AND xlate.entity_code = 'RECEIPTS'
44 AND h.je_source(+) = 'Receivables'
45 AND h.je_category(+) = 'Receipts'
46 AND rct.cash_receipt_id = xlate.source_id_int_1
47 AND receipt_number = '12345678'
48ORDER BY xlal.creation_date, b.name, xlal.ae_line_num;Related posts:
- 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
- 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