APPS.MSC_WS_DRP dependencies on MSC_PLANS

Line 61: FROM msc_plans plans, msc_designators desig

57: SELECT plans.compile_designator, plans.organization_id, plans.sr_instance_id,
58: desig.inventory_atp_flag, desig.production
59: INTO l_val_planName,l_val_orgId,l_val_instanceId,l_val_inventory_atp_flag,
60: l_val_production
61: FROM msc_plans plans, msc_designators desig
62: WHERE plans.curr_plan_type = 5
63: AND plans.organization_id = desig.organization_id
64: AND plans.sr_instance_id = desig.sr_instance_id
65: AND plans.compile_designator = desig.designator

Line 323: FROM msc_plans plans, msc_designators desig

319: -- check plan id
320: BEGIN
321: SELECT plans.compile_designator
322: INTO l_val_planName
323: FROM msc_plans plans, msc_designators desig
324: WHERE plans.curr_plan_type = 5
325: AND plans.organization_id = desig.organization_id
326: AND plans.sr_instance_id = desig.sr_instance_id
327: AND plans.compile_designator = desig.designator

Line 475: msc_plans plans,

471: OrgId,
472: InsId,
473: PlanName
474: FROM
475: msc_plans plans,
476: msc_designators desig
477: WHERE
478: plans.organization_id = desig.organization_id AND
479: plans.sr_instance_id = desig.sr_instance_id AND

Line 514: msc_plans

510: BEGIN
511: SELECT
512: 1 INTO l_Dummy
513: FROM
514: msc_plans
515: WHERE
516: curr_plan_type = 5 AND
517: plan_id = PlanId;
518: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 665: msc_plans mp,

661: decode(desig.designator_type, 6, desig.update_type, -1)
662: FROM
663: msc_designators desig,
664: msc_item_sourcing mis,
665: msc_plans mp,
666: fnd_lookups lu
667: WHERE
668: ( (desig.designator_type = 6 AND desig.forecast_set_id is null) OR
669: (desig.designator_type IN (5,8)) ) AND