eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_WS_SRP dependencies on MSC_DESIGNATORS

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

149: FROM dual;
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)

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

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

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

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

Line 744: msc_designators desig,

740: INTO
741: DesigType,
742: FcstShipTo
743: FROM
744: msc_designators desig,
745: fnd_lookups lu
746: WHERE
747: ( (desig.designator_type = 6 AND desig.forecast_set_id is null) OR
748: (desig.designator_type IN (5,8)) ) AND

Line 772: msc_designators desig,

768: SELECT
769: desig.designator_type,
770: decode(desig.designator_type, 6, desig.update_type, -1)
771: FROM
772: msc_designators desig,
773: msc_plan_organizations_v mpo,
774: fnd_lookups lu
775: WHERE
776: ( (desig.designator_type = 6 AND desig.forecast_set_id IS NULL) OR

Line 793: msc_designators desig,

789: SELECT
790: desig.designator_type,
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