Query to get AR invoice SLA and GL details

1--Query to get AR invoice SLA and GL details
2
3SELECT rct.trx_number,
4       b.name        batch_name,
5       h.name        journal_name,
6       b.description batch_description,
7       h.je_category,
8       h.je_source,
9       h.period_name je_period_name,
10       h.status      journal_status,
11       h.description je_description,
12       l.je_line_num line_number,
13       l.accounted_dr,
14       l.accounted_cr,
15       rct.customer_trx_id,
16       rctd.cust_trx_line_gl_dist_id,
17       xal.entered_dr,
18       xal.entered_cr,
19       xal.accounting_class_code,
20       xal.code_combination_id,
21       xah.event_id,
22       xal.ae_header_id,
23       xlate.entity_code,
24       h.je_category
25  FROM apps.gl_je_batches           b,
26       apps.gl_je_headers           h,
27       apps.gl_je_lines             l,
28       apps.gl_import_references    gir,
29       ra_customer_trx_all          rct,
30       ra_cust_trx_line_gl_dist_all rctd,
31       xla_ae_headers               xah,
32       xla_ae_lines                 xal,
33       xla_events                   xet,
34       xla_distribution_links       xdl,
35       xla.xla_transaction_entities xlate
36 WHERE     h.je_header_id(+) = l.je_header_id
37       AND l.je_header_id(+) = gir.je_header_id
38       AND l.je_line_num(+) = gir.je_line_num
39       AND gir.je_batch_id = b.je_batch_id(+)
40       AND gir.gl_sl_link_table(+) = xal.gl_sl_link_table
41       AND gir.gl_sl_link_id(+) = xal.gl_sl_link_id
42       AND xal.ae_header_id = xah.ae_header_id
43       AND xet.event_id = xah.event_id
44       AND xdl.event_id = xet.event_id
45       AND xdl.ae_header_id = xah.ae_header_id
46       AND xdl.ae_line_num = xal.ae_line_num
47       AND xdl.application_id = 222
48       -- AND xdl.source_distribution_type IN
49       -- ('RA_CUST_TRX_LINE_GL_DIST_ALL', 'MFAR_DISTRIBUTIONS_ALL')
50       AND xlate.entity_code = 'TRANSACTIONS'
51       AND h.je_source(+) = 'Receivables'
52--       AND h.je_category(+) = 'Credit Memos'
53       AND xet.entity_id = xlate.entity_id
54       AND xet.application_id = xlate.application_id
55       AND rct.customer_trx_id = xlate.source_id_int_1
56       AND xdl.source_distribution_id_num_1 = rctd.cust_trx_line_gl_dist_id
57       AND rct.customer_trx_id = rctd.customer_trx_id
58       AND rct.trx_number = '123123';