Oracle EBS query to get AP Invoice SLA Details

1--AP invoice and SLA details
2SELECT hou.name                                    operating_unit,
3       aia.invoice_num,
4       aia.invoice_currency_code,
5       aia.creation_date,
6       aia.invoice_date,
7       aps.vendor_name,
8       aia.invoice_amount,
9       NVL (lk7.meaning, al.accounting_class_code) accounting_class,
10       al.accounted_dr,
11       al.accounted_cr,
12       al.currency_code,
13       al.description                              line_description,
14       al.entered_dr,
15       al.entered_cr,
16       et.event_class_code,
17       gcc.concatenated_segments                   invoice_line_account,
18       ah.accounting_date,
19       ah.period_name,
20       ah.description                              header_description,
21       ah.event_id,
22       al.ae_header_id,
23       al.entered_dr,
24       al.entered_cr,
25       al.code_combination_id,
26       ah.*
27  FROM apps.ap_invoices_all          aia,
28       apps.ap_suppliers             aps,
29       apps.gl_code_combinations_kfv gcc,
30       apps.hr_operating_units       hou,
31       apps.ap_supplier_sites_all    apss,
32       apps.xla_ae_lines             al,
33       apps.xla_ae_headers           ah,
34       apps.xla_lookups              lk5,
35       apps.xla_lookups              lk7,
36       xla.xla_events                e,
37       xla.xla_transaction_entities  te,
38       xla.xla_event_types_tl        et,
39       xla.xla_event_classes_tl      ec
40 WHERE     aia.vendor_id = apss.vendor_id
41       AND aps.vendor_id = apss.vendor_id
42       AND aia.vendor_site_id = apss.vendor_site_id
43       AND al.code_combination_id = gcc.code_combination_id
44       AND hou.organization_id = aia.org_id
45       AND aia.org_id = '101'
46       AND aia.set_of_books_id = ah.ledger_id
47       AND al.ae_header_id = ah.ae_header_id
48       AND al.ledger_id = ah.ledger_id
49       AND al.application_id = ah.application_id
50       AND aia.invoice_num = '123456'    --Enter Invoice number
51       AND NVL (NVL (al.accounted_cr, al.accounted_dr), 0) <> 0
52       AND lk5.lookup_code = NVL (ah.funds_status_code, 'REQUIRED')
53       AND lk5.lookup_type = 'XLA_FUNDS_STATUS'
54       AND lk7.lookup_code(+) = al.accounting_class_code
55       AND lk7.lookup_type(+) = 'XLA_ACCOUNTING_CLASS'
56       AND ec.application_id = et.application_id
57       AND ec.entity_code = et.entity_code
58       AND ec.event_class_code = et.event_class_code
59       AND ec.language = USERENV ('LANG')
60       AND et.application_id = ah.application_id
61       AND et.entity_code = te.entity_code
62       AND e.entity_id = te.entity_id
63       AND e.application_id = te.application_id
64       AND e.application_id = et.application_id
65       AND e.event_type_code = et.event_type_code
66       AND et.event_type_code = ah.event_type_code
67       AND et.language = USERENV ('LANG')
68       AND et.application_id = te.application_id
69       AND te.application_id = ah.application_id
70       AND aia.invoice_id = te.source_id_int_1
71       AND te.entity_id = ah.entity_id
72       AND e.event_id = ah.event_id
73       AND e.application_id = ah.application_id
74       AND ah.ae_header_id = al.ae_header_id
75       AND ah.application_id = al.application_id;