APPS.GMD_COMMON_VAL dependencies on GMD_OPERATIONS_B

Line 1324: gmd_operations_b opr

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;
1328:

Line 1489: gmd_operations_b opr

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
1490: WHERE crres.resources = res.resources AND
1491: dtl.oprn_id = opr.oprn_id AND
1492: opr.oprn_id = act.oprn_id AND
1493: act.oprn_line_id = res.oprn_line_id AND

Line 1817: FROM gmd_operations_b

1813: FROM gmd_routings_b
1814: WHERE routing_id = vrouting_id;
1815: CURSOR get_operation_owner_orgn_id(voprn_id NUMBER) IS
1816: SELECT owner_organization_id
1817: FROM gmd_operations_b
1818: WHERE oprn_id = voprn_id;
1819:
1820: CURSOR get_substitution_owner_orgn_id(vsub_id NUMBER) IS
1821: SELECT owner_organization_id

Line 2145: UPDATE gmd_operations_b

2141: AND to_number(routing_status) < 800;
2142:
2143: /* Update oprns status */
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)