APPS.MSC_WS_SRP dependencies on MSC_PLANS

Line 65: FROM msc_plans plans, msc_designators desig

61: SELECT plans.compile_designator, plans.organization_id, plans.sr_instance_id,
62: desig.inventory_atp_flag, desig.production
63: INTO l_val_planname,l_val_orgid,l_val_instanceid,l_val_inventory_atp_flag,
64: l_val_production
65: FROM msc_plans plans, msc_designators desig
66: WHERE plans.curr_plan_type in (8)
67: AND plans.organization_id = desig.organization_id
68: AND plans.sr_instance_id = desig.sr_instance_id
69: AND plans.compile_designator = desig.designator

Line 154: -- d.designator = (SELECT compile_designator from msc_plans p where

150:
151: END;
152: -- populating PLAN_TYPE_DUMMY hidden parameter
153: -- Original default logic is "SELECT inventory_atp_flag from msc_designators d where
154: -- d.designator = (SELECT compile_designator from msc_plans p where
155: -- p.plan_id=:$FLEX$.MSC_SRS_SCP_NAME_LAUNCH) and d.inventory_atp_flag = 1"
156: -- Which pretty much meant this flag is set to either NULL or 1
157: IF (l_val_inventory_atp_flag <> 1)
158: THEN l_val_inventory_atp_flag := NULL;

Line 183: -- where d.designator = (SELECT compile_designator from msc_plans p where p.plan_id =

179:
180:
181: -- populating RESCHEDULE_DUMMY hidden parameter
182: -- Similar default logic as l_val_inventory_atp_flag, "SELECT production from msc_designators d
183: -- where d.designator = (SELECT compile_designator from msc_plans p where p.plan_id =
184: -- :$FLEX$.MSC_SRS_SCP_NAME_LAUNCH) and d.production = 1"
185: IF (l_val_production <> 1)
186: THEN l_val_production := NULL;
187: END IF;

Line 370: FROM msc_plans plans, msc_designators desig

366: -- check plan id
367: BEGIN
368: SELECT plans.compile_designator
369: INTO l_val_planname
370: FROM msc_plans plans, msc_designators desig
371: WHERE plans.curr_plan_type in (8)
372: AND plans.organization_id = desig.organization_id
373: AND plans.sr_instance_id = desig.sr_instance_id
374: AND plans.compile_designator = desig.designator

Line 527: msc_plans plans,

523: OrgId,
524: InsId,
525: PlanName
526: FROM
527: msc_plans plans,
528: msc_designators desig
529: WHERE
530: plans.organization_id = desig.organization_id AND
531: plans.sr_instance_id = desig.sr_instance_id AND

Line 566: msc_plans

562: BEGIN
563: SELECT
564: 1 INTO l_Dummy
565: FROM
566: msc_plans
567: WHERE
568: curr_plan_type = 8 AND
569: plan_id = PlanId;
570: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 795: msc_plans mp,

791: decode(desig.designator_type, 6, desig.update_type, -1)
792: FROM
793: msc_designators desig,
794: msc_item_sourcing mis,
795: msc_plans mp,
796: fnd_lookups lu
797: WHERE
798: ( (desig.designator_type = 6 AND desig.forecast_set_id IS NULL) OR
799: (desig.designator_type IN (5,8)) ) AND

Line 935: UPDATE msc_plans

931: OverwriteManualFcst IN NUMBER
932: ) RETURN VARCHAR2 AS
933: BEGIN
934: BEGIN
935: UPDATE msc_plans
936: SET
937: item_simulation_set_id = ItemSimulationSetId,
938: curr_overwrite_option = OverwriteSup,
939: manual_fcst_overwrite_option =OverwriteManualFcst