APPS.MSD_SALES_OPERATION_PLAN dependencies on MSC_PLANS

Line 1169: msc_plans sup_plan,

1165: sup_plan_bom.effectivity_date,
1166: sup_plan_bom.disable_date,
1167: sup_plan_bom.res_comp
1168: from msd_ascp_bom_comp sup_plan_bom,
1169: msc_plans sup_plan,
1170: msd_dp_scenarios dp_scen
1171: where sup_plan_bom.cap_usg_ratio_obj = sup_plan.compile_designator
1172: and sup_plan.plan_id = dp_scen.supply_plan_id
1173: and dp_scen.demand_plan_id = p_demand_plan_id

Line 1247: from msc_plans

1243: LOG_MESSAGE('***********************************************************************');
1244: For Supply_Plans_Rec in Supply_Plans Loop
1245:
1246: select compile_designator,trunc(plan_completion_date) into v_plan_name,v_plan_comp_date
1247: from msc_plans
1248: where plan_id = Supply_Plans_Rec.supply_plan_id;
1249:
1250:
1251: BEGIN

Line 1594: from msc_plans

1590: --Initialize the l_effectivity_date and l_disable_date for this SOP Plan.
1591: /*
1592: BEGIN
1593: select nvl(min(CURR_START_DATE),to_date(null)),to_date(null) INTO l_effectivity_date,l_disable_date
1594: from msc_plans
1595: where plan_id in ( select distinct supply_plan_id
1596: from msd_dp_scenarios
1597: where demand_plan_id = p_demand_plan_id
1598: and supply_plan_id > 0 );

Line 1760: /* msc_system_items - assembly and msc_plans - assembly */

1756: msd_level_values cmp_mlv,
1757: msc_system_items cmp_msi,
1758: msc_plan_organizations cmp_mpo
1759: where
1760: /* msc_system_items - assembly and msc_plans - assembly */
1761: ass_mpo.plan_id = p_supply_plan_id
1762: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
1763: and ass_msi.plan_id = ass_mpo.plan_id
1764: and ass_msi.organization_id = ass_mpo.organization_id

Line 1818: /* msc_system_items - assembly and msc_plans - assembly */

1814: msd_level_values cmp_mlv,
1815: msc_system_items cmp_msi,
1816: msc_plan_organizations cmp_mpo
1817: where
1818: /* msc_system_items - assembly and msc_plans - assembly */
1819: ass_mpo.plan_id = p_supply_plan_id
1820: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
1821: and ass_msi.plan_id = ass_mpo.plan_id
1822: and ass_msi.organization_id = ass_mpo.organization_id

Line 1866: msc_plans sup_plan,

1862: sup_plan_bom.sr_assembly_pk,
1863: sup_plan_bom.sr_component_pk,
1864: sup_plan_bom.bom_type
1865: from msd_ascp_bom_comp sup_plan_bom,
1866: msc_plans sup_plan,
1867: msd_dp_scenarios dp_scen
1868: where sup_plan_bom.cap_usg_ratio_obj = sup_plan.compile_designator
1869: and sup_plan.plan_id = dp_scen.supply_plan_id
1870: and dp_scen.demand_plan_id = p_demand_plan_id

Line 1938: from msc_plans

1934:
1935: For Supply_Plans_Rec in Supply_Plans Loop
1936:
1937: select compile_designator,trunc(plan_completion_date) into v_plan_name,v_plan_comp_date
1938: from msc_plans
1939: where plan_id = Supply_Plans_Rec.supply_plan_id;
1940:
1941:
1942: BEGIN