APPS.MSC_WS_ASCP dependencies on MSC_DESIGNATORS

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

151: l_val_netchange := msc_ws_common.sys_no;
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)

Line 184: -- Similar default logic as l_val_inventory_atp_flag, "SELECT production from msc_designators d

180: END;
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;

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 803: msc_designators desig ,

799: INTO
800: DesigType,
801: FcstShipTo
802: FROM
803: msc_designators desig ,
804: fnd_lookups lu
805: WHERE
806: ( (desig.designator_type = 6 AND desig.forecast_set_id is null) OR
807: (desig.designator_type IN (1,2,3,4,5,8) )

Line 832: msc_designators desig,

828: SELECT
829: desig.designator_type,
830: decode(desig.designator_type, 6, desig.update_type, -1)
831: FROM
832: msc_designators desig,
833: fnd_lookups lu,
834: msc_plan_organizations_v mpo
835: WHERE
836: ( (desig.designator_type = 6 AND desig.forecast_set_id is null) OR

Line 854: msc_designators desig,

850: SELECT
851: desig.designator_type,
852: decode(desig.designator_type, 6, desig.update_type, -1)
853: FROM
854: msc_designators desig,
855: fnd_lookups lu,
856: msc_item_sourcing mis,
857: msc_plans mp
858: WHERE

Line 1013: msc_designators

1009: BEGIN
1010: SELECT
1011: designator_type INTO DesigType
1012: FROM
1013: msc_designators
1014: WHERE
1015: trunc(nvl(disable_date, trunc(sysdate) + 1)) > trunc(sysdate) AND
1016: designator <> PlanName AND
1017: organization_id = OrgId AND

Line 1025: msc_designators desig,

1021: UNION
1022: SELECT
1023: desig.designator_type
1024: FROM
1025: msc_designators desig,
1026: msc_plan_organizations_v mpo
1027: WHERE
1028: desig.designator_type not in (1,6,7,8) AND
1029: trunc(nvl(desig.disable_date, trunc(sysdate) + 1)) > trunc(sysdate) AND