APPS.MSC_WS_IO dependencies on MSC_DESIGNATORS

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 113: -- Original default logic is "SELECT inventory_atp_flag from msc_designators d

109: -- setting hidden parameters
110: -- ------------------------------------
111:
112: -- PLAN_TYPE_DUMMY hidden parameter
113: -- Original default logic is "SELECT inventory_atp_flag from msc_designators d
114: -- where d.designator = :$FLEX$.MSC_SRS_SRO_NAME_LAUNCH_1 and d.inventory_atp_flag = 1"
115: -- Which pretty much meant this flag is set to either NULL or 1
116: IF (l_inventory_atp_flag <> 1) THEN l_inventory_atp_flag := NULL;
117: END IF;

Line 133: -- Similar default logic as l_inventory_atp, "SELECT production from msc_designators d

129: ELSE l_24x7_purge := 2;
130: END IF;
131:
132: -- RESCHEDULE_DUMMY parameter
133: -- Similar default logic as l_inventory_atp, "SELECT production from msc_designators d
134: -- where d.designator = :$FLEX$.MSC_SRS_SRO_NAME_LAUNCH_1 and d.production = 1"
135: IF (l_production <> 1)
136: THEN l_production := NULL;
137: END IF;

Line 297: msc_designators desig

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
301: plans.compile_designator = desig.designator AND

Line 1010: FROM msc_designators

1006: BEGIN
1007: BEGIN
1008: SELECT designator_type
1009: INTO DesigType
1010: FROM msc_designators
1011: WHERE
1012: ((designator_type = 6 AND forecast_set_id IS NULL) OR
1013: (designator_type in (1,2,3,4,5,8)) ) AND
1014: trunc(nvl(disable_date, trunc(sysdate) + 1)) > trunc(sysdate) AND

Line 1031: msc_designators desig,

1027: scenario_id = SchId
1028: UNION
1029: SELECT designator_type
1030: FROM
1031: msc_designators desig,
1032: msc_plan_organizations_v mpo
1033: WHERE
1034: ((desig.designator_type = 6 and desig.forecast_set_id IS NULL) OR
1035: (desig.designator_type IN (2,3,4,5,8) )) AND

Line 1047: msc_designators desig,

1043: desig.designator_id = SchId
1044: UNION
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