DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSD_DP_SCN_OUTPUT_LEVELS_V

Line 3142: from msd_dp_scn_output_levels_v dp,

3138: end if;
3139:
3140: select count(*)
3141: into l_count
3142: from msd_dp_scn_output_levels_v dp,
3143: msc_plan_schedules ps
3144: where ps.input_schedule_id = dp.scenario_id
3145: and ps.designator_type = 7
3146: and dp.level_id in (11, 15, 41)

Line 4245: from msd_dp_scn_output_levels_v

4241: ,15,4
4242: ,34,10
4243: ,41,9
4244: ,42,8,1)
4245: from msd_dp_scn_output_levels_v
4246: where demand_plan_id = l_demand_plan_id
4247: and scenario_id = l_scenario_id
4248: and level_id in(1,11,12,15,34,41,42);
4249: begin