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.GMD_STATUS_CODE dependencies on GMD_OPERATIONS_VL

Line 39: * select operation_status from gmd_operations_vl where oprn_id is in

35: *
36: * IF TO_STATUS between 200 and 799 THEN
37: * Start the boolean Dependent_Status_Ok as TRUE.
38: * IF the entity is Routings THEN
39: * select operation_status from gmd_operations_vl where oprn_id is in
40: * (select oprn_id from fm_rout_dtl where routing_id is current routing)
41: * IF any operation_status returned by select is On-hold, Obsolete or less than
42: * the TO_STATUS of the routing, set the boolean to FALSE.
43: * IF the entity is Recipes THEN

Line 91: From gmd_operations_vl o, fm_rout_dtl r

87: IF P_entity_type = 4 THEN
88: /* if entity is routing, check operations */
89: OPEN Oprn_Status_cur FOR
90: Select o.operation_status
91: From gmd_operations_vl o, fm_rout_dtl r
92: Where o.oprn_id = r.oprn_id
93: and r.routing_id = P_Entity_id;
94:
95: /* Fetch 1st record */

Line 231: FROM gmd_operations_vl o,gme_batch_steps s

227: OR h.routing_Status between 900 and 999);
228:
229: CURSOR Cur_Check_oprn_batch_steps(l_oprn_id NUMBER) IS
230: SELECT count(*)
231: FROM gmd_operations_vl o,gme_batch_steps s
232: WHERE o.oprn_id = l_oprn_id
233: AND o.oprn_id = s.oprn_id
234: AND (o.operation_status BETWEEN 400 and 499
235: OR o.operation_status BETWEEN 700 AND 799