APPS.FII_GL_JE_B_C dependencies on FII_SOURCE_LEDGER_GROUPS

Line 1426: fii_source_ledger_groups fslg

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
1429: AND fslg.usage_code = g_usage_code) fset,
1430: gl_je_headers jeh,

Line 1583: fii_source_ledger_groups fslg

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
1587: AND ( fin.company_id = slga.bal_seg_value_id OR slga.bal_seg_value_id = -1 )

Line 1998: fii_source_ledger_groups fslg

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
2001: AND fslg.usage_code = g_usage_code) fset,
2002: fii_gl_processed_header_ids fgph

Line 2047: fii_source_ledger_groups fslg

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
2050: AND fslg.usage_code = g_usage_code) fset,
2051: fii_gl_processed_header_ids fgph

Line 2085: FII_SOURCE_LEDGER_GROUPS FSLG2

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'
2089: ) fset2,

Line 2989: ' fii_source_ledger_groups fslg '||

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, '||
2993: ' fii_slg_assignments slga2, '||

Line 2994: ' fii_source_ledger_groups fslg2 '||

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
2998: l_sqlstmt := l_tmpstmt ||

Line 3445: fii_source_ledger_groups fslg

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')
3449: AND stu.last_update_date > l_last_start_date))