Thursday 13 June 2013

FA to GL Link in R12

SELECT *
  FROM gl_je_headers
 WHERE NAME = <JOURNAL_NAME>;

SELECT *
  FROM gl_je_lines
 WHERE je_header_id = <JE_HEADER_ID>
   AND code_combination_iD = <CCID>;

SELECT *
  FROM gl_import_references
 WHERE je_header_id = 123
   AND je_line_num IN (1,2);

SELECT *
  FROM xla_ae_lines
 WHERE gl_sl_link_id IN (SELECT gl_sl_link_id
                           FROM gl_import_references
                          WHERE je_header_id = 123
                            AND je_line_num IN (1,2));

SELECT *
  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 = 123
                                     AND je_line_num IN (1,2)));


SELECT   *
  FROM   fa_deprn_detail
 WHERE   event_id IN
               (SELECT   event_id
                  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 = 123
                                                         AND je_line_num IN
                                                                  (1, 2))));

No comments:

Post a Comment