APPS.MSD_EOL_PLAN dependencies on MSD_DEMAND_PLANS

Line 21: from msd_demand_plans

17: l_supply_plan_id number;
18: l_supply_plan_start_date date;
19: begin
20: select liab_plan_id into l_supply_plan_id
21: from msd_demand_plans
22: where demand_plan_id=p_demand_plan_id;
23:
24: l_supply_plan_start_date := get_supply_plan_start_date(l_supply_plan_id);
25:

Line 26: update msd_demand_plans

22: where demand_plan_id=p_demand_plan_id;
23:
24: l_supply_plan_start_date := get_supply_plan_start_date(l_supply_plan_id);
25:
26: update msd_demand_plans
27: set previous_plan_start_date=plan_start_date, plan_start_date=l_supply_plan_start_date
28: where demand_plan_id=p_demand_plan_id;
29:
30: liability_preprocessor(l_supply_plan_id);

Line 308: par.DEMAND_PLAN_ID = (select template_id from msd_demand_plans where demand_plan_id=p_demand_plan_id)

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')
310: and mds.demand_plan_id=mdsr.demand_plan_id(+)
311: and par1.demand_plan_id=p_demand_plan_id
312: and mds.demand_plan_id=p_demand_plan_id

Line 396: par.DEMAND_PLAN_ID = (select template_id from msd_demand_plans where demand_plan_id=p_demand_plan_id)

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(+)
399: and par1.demand_plan_id=p_demand_plan_id
400: and mds.demand_plan_id=p_demand_plan_id

Line 411: from msc_plans mp, msd_demand_plans mdp

407: where mdp.demand_plan_id=p_demand_plan_id
408: and mdp.parameter_type=par.parameter_type);
409:
410: select mp.compile_designator into l_supply_plan_name
411: from msc_plans mp, msd_demand_plans mdp
412: where mp.plan_id=mdp.liab_plan_id
413: and mdp.demand_plan_id=p_demand_plan_id;
414:
415: else

Line 516: par.DEMAND_PLAN_ID = (select template_id from msd_demand_plans where demand_plan_id=p_demand_plan_id)

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)
517: and par.stream_type in ('ARCHIVED_TIM')
518: and mdp2.demand_plan_id=mds.demand_plan_id
519: and mdp2.parameter_type=par.parameter_type
520: and mds.demand_plan_id=mdsr.demand_plan_id

Line 533: from msc_plans mp, msd_demand_plans mdp

529: end if;
530:
531:
532: select mp.compile_designator into l_supply_plan_name
533: from msc_plans mp, msd_demand_plans mdp
534: where mp.plan_id=mdp.liab_plan_id
535: and mdp.demand_plan_id=p_demand_plan_id;
536:
537:

Line 588: and mdsd.demand_plan_id= (select template_id from msd_demand_plans where demand_plan_id=p_demand_plan_id)

584: msd_dp_seeded_documents mdsd1,
585: msd_dp_doc_dim_selections mdds
586: WHERE
587: mdsd.document_name='MSD_SD_EOL_LWF'
588: and mdsd.demand_plan_id= (select template_id from msd_demand_plans where demand_plan_id=p_demand_plan_id)
589: and mdsd1.document_name=mdsd.document_name
590: and mdsd1.demand_plan_id=p_demand_plan_id
591: and mdds.demand_plan_id=mdsd.demand_plan_id
592: and mdds.document_id=mdsd.document_id