APPS.MSC_WS_IO dependencies on MSC_PLANS

Line 56: FROM msc_plans plans, msc_designators desig

52: BEGIN
53: SELECT plans.compile_designator, plans.organization_id, plans.sr_instance_id,
54: desig.inventory_atp_flag, desig.production
55: INTO l_plan_name, l_org_id, l_sr_instance_id, l_inventory_atp_flag, l_production
56: FROM msc_plans plans, msc_designators desig
57: WHERE plans.curr_plan_type = 4
58: AND plans.organization_id = desig.organization_id
59: AND plans.sr_instance_id = desig.sr_instance_id
60: AND plans.compile_designator = desig.designator

Line 296: msc_plans plans,

292: OrgId,
293: InsId,
294: PlanName
295: FROM
296: msc_plans plans,
297: msc_designators desig
298: WHERE
299: plans.organization_id = desig.organization_id AND
300: plans.sr_instance_id = desig.sr_instance_id AND

Line 335: msc_plans

331: BEGIN
332: SELECT
333: 1 INTO l_Dummy
334: FROM
335: msc_plans
336: WHERE
337: curr_plan_type = 4 AND
338: plan_id = PlanId;
339: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1049: msc_plans mp

1045: SELECT desig.designator_type
1046: FROM
1047: msc_designators desig,
1048: msc_item_sourcing mis,
1049: msc_plans mp
1050: WHERE
1051: ((desig.designator_type = 6 AND desig.forecast_set_id IS NULL) OR
1052: (desig.designator_type IN (2,3,4,5,8)) ) AND
1053: trunc(nvl(desig.disable_date, trunc(sysdate) + 1)) > trunc(sysdate) AND

Line 1259: UPDATE msc_plans

1255: SvcLvlSetId IN NUMBER
1256: ) AS
1257: BEGIN
1258: BEGIN
1259: UPDATE msc_plans
1260: SET
1261: item_simulation_set_id = ItemSimulationSetId,
1262: curr_service_level_set_id = SvcLvlSetId
1263: WHERE