APPS.GMD_COMMON_VAL dependencies on FM_ROUT_DTL

Line 1374: FROM fm_rout_dtl dtl ,

1370: CURSOR Step_qty_Cur(vRouting_id NUMBER) IS
1371: SELECT dtl.routingStep_id ,
1372: dtl.step_qty qty ,
1373: opr.process_qty_uom step_um
1374: FROM fm_rout_dtl dtl ,
1375: gmd_operations_b opr
1376: WHERE dtl.oprn_id = opr.oprn_id AND
1377: dtl.routing_id = vRouting_id
1378: ORDER BY dtl.routingStep_id;

Line 1536: FROM fm_rout_dtl

1532: FROM gmd_recipe_orgn_resources
1533: WHERE recipe_id = vRecipe_id
1534: AND organization_id = vOrgn_id) orgnres ,
1535: (SELECT oprn_id, routingStep_id
1536: FROM fm_rout_dtl
1537: WHERE routingstep_id = vRoutingstep_id ) dtl ,
1538: gmd_operation_resources res ,
1539: gmd_operation_activities act ,
1540: gmd_operations_b opr

Line 2206: FROM fm_rout_dtl d

2202: IF (l_routing_id IS NOT NULL) THEN
2203: UPDATE gmd_operations_b
2204: SET operation_status = '900'
2205: WHERE oprn_id IN (SELECT oprn_id
2206: FROM fm_rout_dtl d
2207: WHERE routing_id = l_routing_id)
2208: AND to_number(operation_status) < 800;
2209: END IF;
2210: END LOOP;

Line 3042: FROM fm_rout_dtl d

3038: IF (l_routing_id IS NOT NULL) THEN
3039: UPDATE gmd_operations_b
3040: SET operation_status = '900'
3041: WHERE oprn_id IN (SELECT oprn_id
3042: FROM fm_rout_dtl d
3043: WHERE routing_id = l_routing_id)
3044: AND to_number(operation_status) < 800;
3045: END IF;
3046: END LOOP;