APPS.MSC_WS_ASCP dependencies on MSC_PLANS

Line 63: FROM msc_plans plans, msc_designators desig

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

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

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

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

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

Line 347: FROM msc_plans plans, msc_designators desig

343: -- check plan id
344: BEGIN
345: SELECT plans.plan_id, plans.compile_designator, plans.organization_id, plans.sr_instance_id
346: INTO l_val_planid, l_val_planname, l_val_orgid, l_val_instanceid
347: FROM msc_plans plans, msc_designators desig
348: WHERE plans.curr_plan_type in (1,2,3)
349: AND plans.organization_id = desig.organization_id
350: AND plans.sr_instance_id = desig.sr_instance_id
351: AND plans.compile_designator = desig.designator

Line 496: msc_plans

492: BEGIN
493: SELECT
494: 1 INTO l_Dummy
495: FROM
496: msc_plans
497: WHERE
498: curr_plan_type IN (1, 2, 3) AND
499: plan_id = PlanId;
500: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 857: msc_plans mp

853: FROM
854: msc_designators desig,
855: fnd_lookups lu,
856: msc_item_sourcing mis,
857: msc_plans mp
858: WHERE
859: ( (desig.designator_type = 6 AND desig.forecast_set_id is null) OR
860: (desig.designator_type IN (2,3,4,5,8))
861: ) AND