APPS.GMD_STATUS_CODE dependencies on FM_ROUT_DTL

Line 40: * (select oprn_id from fm_rout_dtl where routing_id is current routing)

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
44: * select formula_status from fm_form_mst where formula_id is in

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 222: FROM fm_rout_hdr h,fm_rout_dtl d

218:
219:
220: CURSOR Cur_Check_oprn_recp(l_oprn_id NUMBER) IS
221: SELECT count(*)
222: FROM fm_rout_hdr h,fm_rout_dtl d
223: WHERE h.routing_id = d.routing_id
224: AND d.oprn_id = l_oprn_id
225: AND (h.routing_status between 700 and 799
226: OR h.routing_Status between 400 and 499