APPS.MSC_PHUB_UTIL dependencies on MSD_DP_ASCP_SCENARIOS_V

Line 166: from msd_dp_ascp_scenarios_v

162: from msc_scenario_plans sp, msc_scenarios s,
163: (select distinct plan_id, plan_type from msc_plans
164: union all
165: select distinct scenario_id, to_number(10)
166: from msd_dp_ascp_scenarios_v
167: where demand_plan_id=5555555) p
168: where sp.scenario_id=s.scenario_id
169: and sp.plan_id=p.plan_id
170: and p.plan_type=decode(sign(nvl(p_plan_type, -1)), 1, p_plan_type, p.plan_type)