DBA Data[Home] [Help]

APPS.MSD_LIABILITY dependencies on MSD_DP_SCENARIOS

Line 424: msd_dp_scenarios mds

420: /* If the profile value is null then a warning will be given and the output level will be defaulted to Item */
421:
422: select mdsol.LEVEL_ID , mds.scenario_id into x_prev_liab_calc_level , x_scenario_id from
423: MSD_DP_SCENARIO_OUTPUT_LEVELS mdsol ,
424: msd_dp_scenarios mds
425: where
426: mds.demand_plan_id = mdsol.demand_plan_id and
427: mds.scenario_id = mdsol.scenario_id
428: and mds.demand_plan_id =x_liab_plan_id

Line 459: msd_dp_scenarios mds

455:
456: ELSE
457: select mdsol.LEVEL_ID , mds.scenario_id into x_prev_liab_calc_level , x_scenario_id from
458: MSD_DP_SCENARIO_OUTPUT_LEVELS mdsol ,
459: msd_dp_scenarios mds
460: where
461: mds.demand_plan_id = mdsol.demand_plan_id and
462: mds.scenario_id = mdsol.scenario_id
463: and mds.demand_plan_id =x_liab_plan_id

Line 2236: msd_dp_scenarios scen,

2232: SELECT scen.scenario_name,ml.dimension_code,count(*)
2233: FROM
2234: msd_dp_scenario_output_levels a,
2235: msd_levels ml,
2236: msd_dp_scenarios scen,
2237: msd_demand_plans mdp
2238: WHERE a.level_id = ml.level_id
2239: AND a.scenario_id = scen.scenario_id
2240: AND scen.enable_flag = 'Y'