Oracle apps AR Applications and SLA details

1--AR Applications and xla
2SELECT ard.source_id,
3       xdl.SOURCE_DISTRIBUTION_TYPE,
4       xal.ACCOUNTING_CLASS_CODE,
5       ard.SOURCE_ID,
6       ard.SOURCE_TABLE,
7       ard.SOURCE_TYPE,
8       rcta.trx_number,
9       (SELECT name
10          FROM apps.ra_cust_trx_types_all
11         WHERE cust_trx_type_id = rcta.cust_trx_type_id)
12          transaction_type,
13       xah.*
14  FROM apps.xla_ae_lines                   xal,
15       apps.xla_distribution_links         xdl,
16       apps.xla_ae_headers                 xah,
17       apps.AR_DISTRIBUTIONS_ALL           ard,
18       apps.AR_RECEIVABLE_APPLICATIONS_ALL ara,
19       apps.ra_customer_trx_all            rcta
20 WHERE     1 = 1
21       AND xal.ae_header_id = xdl.ae_header_id
22       AND xal.ae_line_num = xdl.ae_line_num
23       AND xdl.SOURCE_DISTRIBUTION_TYPE = 'AR_DISTRIBUTIONS_ALL'
24       AND xah.ae_header_id = xal.ae_header_id
25       AND ARD.LINE_ID = XDL.source_distribution_id_num_1
26       AND ard.SOURCE_ID = ara.RECEIVABLE_APPLICATION_ID
27       AND ara.APPLIED_CUSTOMER_TRX_ID = rcta.customer_trx_id(+)
28       AND rcta.trx_number = '123456'
29       --AND GL_TRANSFER_STATUS_CODE = 'N'
30       ;