APPS.MSD_EOL_PLAN dependencies on MSD_DP_SCENARIOS

Line 305: msd_dp_scenarios mds,

301: ,par.STREAM_TYPE
302: FROM
303: msd_dp_parameters par,
304: msd_dp_parameters par1,
305: msd_dp_scenarios mds,
306: msd_dp_scenario_revisions mdsr
307: WHERE
308: par.DEMAND_PLAN_ID = (select template_id from msd_demand_plans where demand_plan_id=p_demand_plan_id)
309: and par.stream_type in ('ARCHIVED')

Line 394: msd_dp_scenarios mds

390: FROM
391: msd_dp_parameters par,
392: msd_dp_parameters par1,
393: msd_dp_scenario_revisions mdsr,
394: msd_dp_scenarios mds
395: WHERE
396: par.DEMAND_PLAN_ID = (select template_id from msd_demand_plans where demand_plan_id=p_demand_plan_id)
397: and par.stream_type in ('ARCHIVED_TIM')
398: and mds.demand_plan_id=mdsr.demand_plan_id(+)

Line 508: from msd_dp_scenario_revisions mdsr1, msd_dp_scenarios mds1

504: FROM
505: msd_dp_parameters par,
506: msd_dp_parameters par1,
507: (select mds1.demand_plan_id,mds1.scenario_id,nvl(max(mdsr1.revision),-1) revision
508: from msd_dp_scenario_revisions mdsr1, msd_dp_scenarios mds1
509: where mdsr1.scenario_id(+)=mds1.scenario_id
510: and mdsr1.demand_plan_id(+)=mds1.demand_plan_id
511: group by mds1.demand_plan_id,mds1.scenario_id) mdsr,
512: msd_dp_scenarios mds,

Line 512: msd_dp_scenarios mds,

508: from msd_dp_scenario_revisions mdsr1, msd_dp_scenarios mds1
509: where mdsr1.scenario_id(+)=mds1.scenario_id
510: and mdsr1.demand_plan_id(+)=mds1.demand_plan_id
511: group by mds1.demand_plan_id,mds1.scenario_id) mdsr,
512: msd_dp_scenarios mds,
513: (select demand_plan_id,parameter_type,nvl(max(revision),-1) revision from msd_dp_parameters group by
514: demand_plan_id,parameter_type) mdp2
515: WHERE
516: par.DEMAND_PLAN_ID = (select template_id from msd_demand_plans where demand_plan_id=p_demand_plan_id)