DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSD_DP_SCN_OUTPUT_LEVELS_V

Line 3572: from msd_dp_scn_output_levels_v dp,

3568: end if;
3569:
3570: select count(*)
3571: into l_count
3572: from msd_dp_scn_output_levels_v dp,
3573: msc_plan_schedules ps
3574: where ps.input_schedule_id = dp.scenario_id
3575: and ps.designator_type = 7
3576: and dp.level_id in (11, 15, 41)

Line 4702: from msd_dp_scn_output_levels_v

4698: ,15,4
4699: ,34,10
4700: ,41,9
4701: ,42,8,1)
4702: from msd_dp_scn_output_levels_v
4703: where demand_plan_id = l_demand_plan_id
4704: and scenario_id = l_scenario_id
4705: and level_id in(1,11,12,15,34,41,42);
4706: begin