APPS.FII_GL_JE_B_C dependencies on FII_SLG_ASSIGNMENTS

Line 1424: FROM fii_slg_assignments slga,

1420: (SELECT DISTINCT
1421: slga.ledger_id,
1422: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_SOURCE_NAME) je_source_name,
1423: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_CATEGORY_NAME) je_category_name
1424: FROM fii_slg_assignments slga,
1425: gl_je_inclusion_rules rule,
1426: fii_source_ledger_groups fslg
1427: WHERE slga.je_rule_set_id = rule.je_rule_set_id (+)
1428: AND slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 1582: fii_slg_assignments slga,

1578: FROM fii_gl_new_jrl_header_ids njhi,
1579: gl_je_lines line,
1580: gl_ledgers_public_v sob,
1581: fii_gl_ccid_dimensions fin,
1582: fii_slg_assignments slga,
1583: fii_source_ledger_groups fslg
1584: WHERE njhi.je_header_id = line.je_header_id
1585: AND line.ledger_id = sob.ledger_id
1586: AND line.code_combination_id = fin.code_combination_id

Line 1996: FROM fii_slg_assignments slga,

1992: (SELECT DISTINCT
1993: slga.ledger_id,
1994: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_SOURCE_NAME) je_source_name,
1995: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_CATEGORY_NAME) je_category_name
1996: FROM fii_slg_assignments slga,
1997: gl_je_inclusion_rules rule,
1998: fii_source_ledger_groups fslg
1999: WHERE slga.je_rule_set_id = rule.je_rule_set_id (+)
2000: AND slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 2045: FROM fii_slg_assignments slga,

2041: (SELECT /*+ no_merge */ DISTINCT
2042: slga.ledger_id,
2043: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_SOURCE_NAME) je_source_name,
2044: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_CATEGORY_NAME) je_category_name
2045: FROM fii_slg_assignments slga,
2046: gl_je_inclusion_rules rule,
2047: fii_source_ledger_groups fslg
2048: WHERE slga.je_rule_set_id = rule.je_rule_set_id (+)
2049: AND slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 2084: FII_SLG_ASSIGNMENTS SLGA2,

2080: SLGA2.chart_of_accounts_id,
2081: SOB.currency_code,
2082: SOB.CHART_OF_ACCOUNTS_ID chart_accs_id_sob
2083: FROM gl_ledgers_public_v SOB,
2084: FII_SLG_ASSIGNMENTS SLGA2,
2085: FII_SOURCE_LEDGER_GROUPS FSLG2
2086: WHERE SOB.LEDGER_ID = SLGA2.LEDGER_ID
2087: AND SLGA2.SOURCE_LEDGER_GROUP_ID = FSLG2.SOURCE_LEDGER_GROUP_ID
2088: AND FSLG2.USAGE_CODE = 'DBI'

Line 2988: ' FROM fii_slg_assignments slga, '||

2984: 'FROM gl_balances b, '||
2985: ' gl_ledgers_public_v sob, '||
2986: ' gl_periods per, '||
2987: ' (SELECT /*+ full(slga) */ DISTINCT slga.ledger_id '||
2988: ' FROM fii_slg_assignments slga, '||
2989: ' fii_source_ledger_groups fslg '||
2990: ' WHERE slga.source_ledger_group_id =fslg.source_ledger_group_id '||
2991: ' AND fslg.usage_code = ''DBI'') fset, '||
2992: ' fii_gl_ccid_dimensions fin, '||

Line 2993: ' fii_slg_assignments slga2, '||

2989: ' fii_source_ledger_groups fslg '||
2990: ' WHERE slga.source_ledger_group_id =fslg.source_ledger_group_id '||
2991: ' AND fslg.usage_code = ''DBI'') fset, '||
2992: ' fii_gl_ccid_dimensions fin, '||
2993: ' fii_slg_assignments slga2, '||
2994: ' fii_source_ledger_groups fslg2 '||
2995: ' WHERE sob.ledger_id = fset.ledger_id ';
2996:
2997: IF (l_program_type = 'L') THEN

Line 3444: fii_slg_assignments slga,

3440:
3441: SELECT trunc(min(stu.start_date))
3442: INTO l_start_date
3443: FROM gl_period_statuses stu,
3444: fii_slg_assignments slga,
3445: fii_source_ledger_groups fslg
3446: WHERE slga.ledger_id = stu.set_of_books_id
3447: AND stu.application_id = 101
3448: AND (stu.closing_status = 'O' OR (stu.closing_status IN ('C', 'P')