APPS.FII_BUDGET_FORECAST_C dependencies on GL_LEDGERS_PUBLIC_V

Line 821: ' FROM gl_periods p, gl_ledgers_public_v s, '||

817: ' p.period_name, s.ledger_id, '||
818: ' b.budget_version_id, '||
819: ' b.base_budget_version_id, '||
820: ' s.period_set_name, s.accounted_period_type '||
821: ' FROM gl_periods p, gl_ledgers_public_v s, '||
822: ' fii_slg_budget_asgns b, fii_source_ledger_groups slg '||
823: ' WHERE slg.usage_code = ''DBI'' '||
824: ' AND b.source_ledger_group_id = slg.source_ledger_group_id '||
825: ' AND s.ledger_id = b.ledger_id '||

Line 842: ' gl_ledgers_public_v sob '||

838: ' FROM fii_slg_assignments slga, '||
839: ' gl_je_inclusion_rules rule, '||
840: ' fii_slg_budget_asgns slba, '||
841: ' fii_source_ledger_groups fslg, '||
842: ' gl_ledgers_public_v sob '||
843: ' WHERE slga.je_rule_set_id = rule.je_rule_set_id (+) '||
844: ' AND slga.source_ledger_group_id = fslg.source_ledger_group_id '||
845: ' AND fslg.usage_code = ''DBI'' '||
846: ' AND sob.ledger_id = slga.ledger_id '||

Line 1083: ' GL_LEDGERS_PUBLIC_V sob '||

1079: ' FII_GL_CCID_DIMENSIONS fin, '||
1080: ' FII_FIN_CAT_TYPE_ASSGNS fcta, '||
1081: ' GL_BALANCES b, '||
1082: ' GL_PERIODS p, '||
1083: ' GL_LEDGERS_PUBLIC_V sob '||
1084: ' WHERE fslg.usage_code = ''DBI'' '||
1085: ' AND slga.source_ledger_group_id = fslg.source_ledger_group_id '||
1086: ' AND slba.source_ledger_group_id = slga.source_ledger_group_id '||
1087: ' AND slba.ledger_id = slga.ledger_id '||

Line 1738: gl_ledgers_public_v sob

1734: CURSOR sobCursor (global_prim_curr VARCHAR2) IS
1735: SELECT DISTINCT sob.name, sob.currency_code
1736: FROM fii_slg_assignments slga,
1737: fii_source_ledger_groups fslg,
1738: gl_ledgers_public_v sob
1739: WHERE sob.ledger_id = slga.ledger_id
1740: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
1741: AND fslg.usage_code = 'DBI'
1742: AND sob.currency_code NOT IN (global_prim_curr);

Line 1778: gl_ledgers_public_v sob

1774: ledger_id, company_id, cost_center_id, fin_category_id,
1775: category_id, user_dim1_id, user_dim2_id, posted_date,
1776: baseline_amount_prim
1777: FROM fii_budget_base) v,
1778: gl_ledgers_public_v sob
1779: WHERE sob.ledger_id = v.ledger_id;
1780:
1781: -- Bug 5004852: Added to select the company_cost_center_org_id for the
1782: -- company_id and cost_center_id of FII_BUDGET_STG

Line 2066: GL_LEDGERS_PUBLIC_V sob

2062: nvl(i.ledger, '-1')
2063: FROM FII_BUDGET_INTERFACE i,
2064: (SELECT DISTINCT sob.ledger_id, int.ledger
2065: FROM FII_BUDGET_INTERFACE int,
2066: GL_LEDGERS_PUBLIC_V sob
2067: WHERE (sob.ledger_id = int.ledger_id OR
2068: sob.name = int.ledger)) f
2069: WHERE i.ledger = f.ledger(+);
2070:

Line 2079: GL_LEDGERS_PUBLIC_V sob

2075: (SELECT DISTINCT fv.flex_value_id, int.company, int.ledger_id
2076: FROM FII_BUDGET_INTERFACE int,
2077: FII_DIM_MAPPING_RULES r,
2078: FND_FLEX_VALUES fv,
2079: GL_LEDGERS_PUBLIC_V sob
2080: WHERE r.dimension_short_name = 'FII_COMPANIES'
2081: AND r.chart_of_accounts_id = sob.chart_of_accounts_id
2082: AND (sob.ledger_id = int.ledger_id OR
2083: sob.name = int.ledger)

Line 2096: GL_LEDGERS_PUBLIC_V sob

2092: (SELECT DISTINCT fv.flex_value_id, int.cost_center, int.ledger_id
2093: FROM FII_BUDGET_INTERFACE int,
2094: FII_DIM_MAPPING_RULES r,
2095: FND_FLEX_VALUES fv,
2096: GL_LEDGERS_PUBLIC_V sob
2097: WHERE r.dimension_short_name = 'HRI_CL_ORGCC'
2098: AND r.chart_of_accounts_id = sob.chart_of_accounts_id
2099: AND (sob.ledger_id = int.ledger_id OR
2100: sob.name = int.ledger)

Line 2122: GL_LEDGERS_PUBLIC_V sob

2118: (SELECT DISTINCT fv.flex_value_id, int.fin_item, int.ledger_id
2119: FROM FII_DIM_MAPPING_RULES r,
2120: FII_BUDGET_INTERFACE int,
2121: FND_FLEX_VALUES fv,
2122: GL_LEDGERS_PUBLIC_V sob
2123: WHERE r.dimension_short_name = 'GL_FII_FIN_ITEM'
2124: AND r.chart_of_accounts_id = sob.chart_of_accounts_id
2125: AND (sob.ledger_id = int.ledger_id OR
2126: sob.name = int.ledger)

Line 2140: GL_LEDGERS_PUBLIC_V sob

2136: (SELECT DISTINCT fv.flex_value_id, int.user_dim1 , int.ledger_id
2137: FROM FII_DIM_MAPPING_RULES r,
2138: FII_BUDGET_INTERFACE int,
2139: FND_FLEX_VALUES fv,
2140: GL_LEDGERS_PUBLIC_V sob
2141: WHERE r.dimension_short_name = 'FII_USER_DEFINED_1'
2142: AND r.chart_of_accounts_id = sob.chart_of_accounts_id
2143: AND (sob.ledger_id = int.ledger_id OR
2144: sob.name = int.ledger)