APPS.MSC_WS_DRP dependencies on MSC_DESIGNATORS

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

139:
140:
141:
142: -- populating PLAN_TYPE_DUMMY hidden parameter
143: -- Original default logic is "SELECT inventory_atp_flag from msc_designators d
144: -- where d.designator = :$FLEX$.MSC_SRS_SRO_NAME_LAUNCH_1 and d.inventory_atp_flag = 1"
145: -- Which pretty much meant this flag is set to either NULL or 1
146: IF (l_val_inventory_atp_flag <> 1)
147: THEN l_val_inventory_atp_flag := NULL;

Line 171: -- msc_designators d where d.designator = :$FLEX$.MSC_SRS_SRO_NAME_LAUNCH_1 and d.production = 1"

167:
168:
169: -- populating RESCHEDULE_DUMMY hidden parameter
170: -- Similar default logic as l_val_inventory_atp_flag, "SELECT production from
171: -- msc_designators d where d.designator = :$FLEX$.MSC_SRS_SRO_NAME_LAUNCH_1 and d.production = 1"
172: IF (l_val_production <> 1)
173: THEN l_val_production := NULL;
174: END IF;
175:

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 476: msc_designators desig

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

Line 615: msc_designators desig,

611: INTO
612: DesigType,
613: FcstShipTo
614: FROM
615: msc_designators desig,
616: fnd_lookups lu
617: WHERE
618: ( (desig.designator_type = 6 and desig.forecast_set_id is null) OR
619: (desig.designator_type in (5,8)) ) AND

Line 642: msc_designators desig,

638: SELECT
639: desig.designator_type,
640: decode(desig.designator_type, 6, desig.update_type, -1)
641: FROM
642: msc_designators desig,
643: msc_plan_organizations_v mpo,
644: fnd_lookups lu
645: WHERE
646: ( (desig.designator_type = 6 AND desig.forecast_set_id is null) OR

Line 663: msc_designators desig,

659: SELECT
660: desig.designator_type,
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