Thursday, April 5, 2018

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));


No comments:

Post a Comment

Best Blogger TipsGet Flower Effect