[Home] [Help]
939: from fii_gl_processed_header_ids fiiglh,
940: gl_je_headers glh,
941: gl_import_references gir,
942: xla_ae_lines xlal,
943: xla_ae_headers xlah,
944: xla_subledgers xlasl,
945: (SELECT p.period_name,
946: s.ledger_id
947: FROM gl_periods p,
1728: from fii_fa_new_exp_hdr_ids nid,
1729: gl_import_references gir,
1730: fii_fa_acct_class_code_gt acls,
1731: xla_ae_lines lines,
1732: xla_ae_headers headers,
1733: fii_gl_ccid_dimensions ccid,
1734: gl_ledgers_public_v sob,
1735: xla_distribution_links links,
1736: fa_adjustments adj,
1891: from fii_fa_new_exp_hdr_ids nid,
1892: gl_import_references gir,
1893: fii_fa_acct_class_code_gt acls,
1894: xla_ae_lines lines,
1895: xla_ae_headers headers,
1896: fii_gl_ccid_dimensions ccid,
1897: gl_ledgers_public_v sob,
1898: xla_distribution_links links,
1899: fa_deprn_detail dd,
1937: and bc.set_of_books_id = sob.ledger_id
1938: and headers.ae_header_id not in
1939: (select /*+ hash_aj parallel(headers2, ev_rb, ev_dep) */
1940: headers2.ae_header_id
1941: from xla_ae_headers headers2,
1942: xla_events ev_rb,
1943: xla_events ev_dep
1944: where headers2.application_id = 140
1945: and headers2.event_type_code = 'DEPRECIATION'