[Home] [Help]
64: SELECT DISTINCT
65: s.ledger_id,
66: s.name
67: FROM gl_period_statuses ps,
68: gl_ledgers_public_v s,
69: fa_deprn_periods dp,
70: fa_book_controls bc,
71: (SELECT DISTINCT slga.ledger_id
72: FROM fii_slg_assignments slga,
944: xla_subledgers xlasl,
945: (SELECT p.period_name,
946: s.ledger_id
947: FROM gl_periods p,
948: gl_ledgers_public_v s
949: WHERE p.end_date >= g_global_Start_Date
950: AND p.period_set_name = s.period_set_name) per,
951: (SELECT DISTINCT slga.ledger_id
952: FROM fii_slg_assignments slga,
1020: xla_subledgers xlasl,
1021: (SELECT p.period_name,
1022: s.ledger_id
1023: FROM gl_periods p,
1024: gl_ledgers_public_v s
1025: WHERE p.end_date >= g_global_Start_Date
1026: AND p.period_set_name = s.period_set_name) per,
1027: (SELECT DISTINCT slga.ledger_id
1028: FROM fii_slg_assignments slga,
1395: from fii_fa_new_exp_hdr_ids nid,
1396: xla_ae_lines lines,
1397: fii_fa_acct_class_code_gt acls,
1398: fii_gl_ccid_dimensions ccid,
1399: gl_ledgers_public_v sob,
1400: gl_import_references gir,
1401: xla_distribution_links links,
1402: fa_deprn_detail dd,
1403: fa_distribution_history dh,
1525: from fii_fa_new_exp_hdr_ids nid,
1526: xla_ae_lines lines,
1527: fii_fa_acct_class_code_gt acls,
1528: fii_gl_ccid_dimensions ccid,
1529: gl_ledgers_public_v sob,
1530: gl_import_references gir,
1531: xla_distribution_links links,
1532: fa_adjustments adj,
1533: fa_distribution_history dh,
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,
1737: fa_distribution_history dh,
1738: fa_additions_b ad,
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,
1900: fa_distribution_history dh,
1901: fa_additions_b ad,