DBA Data[Home] [Help]

APPS.FII_BUDGET_FORECAST_C dependencies on FND_ID_FLEX_SEGMENTS

Line 2499: FND_ID_FLEX_SEGMENTS fs,

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
2503: AND fs.id_flex_code = 'GL#'

Line 2535: FND_ID_FLEX_SEGMENTS fs,

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
2539: AND fs.id_flex_code = 'GL#'

Line 2571: fnd_id_flex_segments fs,

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
2575: AND fs.id_flex_code = 'GL#'

Line 2610: fnd_id_flex_segments fs,

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#'
2614: AND fs.id_flex_num = mr.chart_of_accounts_id