Oracle EBS query to get AR Invoice SLA Details

•By admin

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

SQL Querysql
1--Query to get AR invoice SLA details
2SELECT rct.trx_number,
3       rct.customer_trx_id,
4       rctd.cust_trx_line_gl_dist_id,
5       xal.entered_dr,
6       xal.entered_cr,
7       xal.code_combination_id,
8       xah.event_id,
9       xal.ae_header_id,
10       xah.*
11  FROM ra_customer_trx_all          rct,
12       ra_customer_trx_lines_all    rctl,
13       ra_cust_trx_line_gl_dist_all rctd,
14       xla_ae_headers               xah,
15       xla_ae_lines                 xal,
16       xla_events                   xet,
17       xla_distribution_links       xdl
18 WHERE     xal.ae_header_id = xah.ae_header_id
19       AND xet.event_id = xah.event_id
20       AND xdl.event_id = xet.event_id
21       AND xdl.ae_header_id = xah.ae_header_id
22       AND xdl.ae_line_num = xal.ae_line_num
23       AND xdl.application_id = 222
24       AND xdl.source_distribution_type IN
25              ('RA_CUST_TRX_LINE_GL_DIST_ALL', 'MFAR_DISTRIBUTIONS_ALL')
26       AND xdl.source_distribution_id_num_1 = rctd.CUST_TRX_LINE_GL_DIST_ID
27       AND rctl.customer_trx_line_id = rctd.customer_trx_line_id
28       AND rct.customer_trx_id = rctl.customer_trx_id
29       AND rct.trx_number = :p_trx_number;

Related posts: