APPS.FII_BUDGET_FORECAST_C dependencies on FND_FLEX_VALUES

Line 2078: FND_FLEX_VALUES fv,

2074: FROM FII_BUDGET_INTERFACE i,
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

Line 2095: FND_FLEX_VALUES fv,

2091: FROM FII_BUDGET_INTERFACE i,
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

Line 2121: FND_FLEX_VALUES fv,

2117: FROM FII_BUDGET_INTERFACE i,
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

Line 2139: FND_FLEX_VALUES fv,

2135: FROM FII_BUDGET_INTERFACE i,
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

Line 2498: FROM FND_FLEX_VALUES fv,

2494: FROM FII_BUDGET_INTERFACE b
2495: WHERE (b.company IS NOT NULL AND b.company_id IS NULL) OR
2496: NOT EXISTS (
2497: SELECT '1'
2498: FROM FND_FLEX_VALUES fv,
2499: FND_ID_FLEX_SEGMENTS fs,
2500: FII_DIM_MAPPING_RULES mr,
2501: FND_SEGMENT_ATTRIBUTE_VALUES b
2502: WHERE fs.application_id = 101

Line 2534: FROM FND_FLEX_VALUES fv,

2530: FROM FII_BUDGET_INTERFACE b
2531: WHERE (b.cost_center IS NOT NULL and b.cost_center_id IS NULL) OR
2532: NOT EXISTS (
2533: SELECT '1'
2534: FROM FND_FLEX_VALUES fv,
2535: FND_ID_FLEX_SEGMENTS fs,
2536: FII_DIM_MAPPING_RULES mr,
2537: FND_SEGMENT_ATTRIBUTE_VALUES b
2538: WHERE fs.application_id = 101

Line 2570: FROM fnd_flex_values fv,

2566: FROM FII_BUDGET_INTERFACE b
2567: WHERE (b.fin_item IS NOT NULL AND b.fin_category_id IS NULL) OR
2568: NOT EXISTS (
2569: SELECT '1'
2570: FROM fnd_flex_values fv,
2571: fnd_id_flex_segments fs,
2572: fnd_segment_attribute_values b,
2573: fii_dim_mapping_rules mr
2574: WHERE fs.application_id = 101

Line 2609: FROM fnd_flex_values fv,

2605: FROM FII_BUDGET_INTERFACE b
2606: WHERE (b.user_dim1 IS NOT NULL AND b.user_dim1_id IS NULL) OR
2607: (nvl(b.user_dim1_id, -1) NOT IN (
2608: SELECT fv.flex_value_id
2609: FROM fnd_flex_values fv,
2610: fnd_id_flex_segments fs,
2611: fii_dim_mapping_rules mr
2612: WHERE fs.application_id = 101
2613: AND fs.id_flex_code = 'GL#'