APPS.GMD_COMMON_VAL dependencies on FM_ROUT_DTL

Line 1323: FROM fm_rout_dtl dtl ,

1319: CURSOR Step_qty_Cur(vRouting_id NUMBER) IS
1320: SELECT dtl.routingStep_id ,
1321: dtl.step_qty qty ,
1322: opr.process_qty_uom step_um
1323: FROM fm_rout_dtl dtl ,
1324: gmd_operations_b opr
1325: WHERE dtl.oprn_id = opr.oprn_id AND
1326: dtl.routing_id = vRouting_id
1327: ORDER BY dtl.routingStep_id;

Line 1485: FROM fm_rout_dtl

1481: FROM gmd_recipe_orgn_resources
1482: WHERE recipe_id = vRecipe_id
1483: AND organization_id = vOrgn_id) orgnres ,
1484: (SELECT oprn_id, routingStep_id
1485: FROM fm_rout_dtl
1486: WHERE routingstep_id = vRoutingstep_id ) dtl ,
1487: gmd_operation_resources res ,
1488: gmd_operation_activities act ,
1489: gmd_operations_b opr

Line 2148: FROM fm_rout_dtl d

2144: IF (l_routing_id IS NOT NULL) THEN
2145: UPDATE gmd_operations_b
2146: SET operation_status = '900'
2147: WHERE oprn_id IN (SELECT oprn_id
2148: FROM fm_rout_dtl d
2149: WHERE routing_id = l_routing_id)
2150: AND to_number(operation_status) < 800;
2151: END IF;
2152: END LOOP;