APPS.GMD_COMMON_VAL dependencies on GMD_OPERATIONS_B

Line 1375: gmd_operations_b opr

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

Line 1540: gmd_operations_b opr

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
1541: WHERE crres.resources = res.resources AND
1542: dtl.oprn_id = opr.oprn_id AND
1543: opr.oprn_id = act.oprn_id AND
1544: act.oprn_line_id = res.oprn_line_id AND

Line 1875: FROM gmd_operations_b

1871: FROM gmd_routings_b
1872: WHERE routing_id = vrouting_id;
1873: CURSOR get_operation_owner_orgn_id(voprn_id NUMBER) IS
1874: SELECT owner_organization_id
1875: FROM gmd_operations_b
1876: WHERE oprn_id = voprn_id;
1877:
1878: CURSOR get_substitution_owner_orgn_id(vsub_id NUMBER) IS
1879: SELECT owner_organization_id

Line 2203: UPDATE gmd_operations_b

2199: AND to_number(routing_status) < 800;
2200:
2201: /* Update oprns status */
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)

Line 3039: UPDATE gmd_operations_b

3035: AND to_number(routing_status) < 800;
3036:
3037: /* Update oprns status */
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)