Queries to Get the SLA Details

--1) Fields code_combination_id,Period_name,ledger_id,status

SELECT code_combination_id,

       Period_name,

       ledger_id,

       status

  FROM gl_je_lines

 WHERE je_header_id = 127354 AND Je_line_num = 13;

-- 2) Fields Batch ID,Reference(type:PO,AR,AP)

SELECT je_batch_id, reference_1

  FROM gl_import_references

 WHERE je_header_id = 127354 AND Je_line_num = 13;

--3) Fields header_id,code_combination_id,ledger_id

SELECT ae_header_id,

       code_combination_id,

       ledger_id,

       Accounting_class_code,

       description

  FROM xla_ae_lines xal

 WHERE gl_sl_link_id IN

          (SELECT gl_sl_link_id

             FROM gl_import_references

            WHERE     je_header_id = 127354

                  AND Je_line_num = 13

                  AND ledger_id = 125);

--4)  Fields Source_distribution_type,Accounting_line_code,event_class_code,event_type_code,ae_line_num

SELECT Source_distribution_type,

       Accounting_line_code,

       event_class_code,

       event_type_code,

       ae_line_num

  FROM xla_distribution_links

 WHERE ae_header_id IN

          (SELECT ae_header_id

             FROM xla_ae_lines

            WHERE gl_sl_link_id IN

                     (SELECT gl_sl_link_id

                        FROM gl_import_references

                       WHERE je_header_id = 127354 AND Je_line_num = 13));