APPS.GMD_COMMON_VAL dependencies on GMD_OPERATIONS

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 1810: FROM gmd_operations

1806: WHERE routing_id = Entity_id;
1807: ELSIF (Entity = 'OPERATION') THEN
1808: SELECT delete_mark, operation_status
1809: INTO l_delete_mark, l_status_code
1810: FROM gmd_operations
1811: WHERE oprn_id = Entity_id;
1812: ELSIF (Entity = 'VALIDITY') THEN
1813: SELECT delete_mark, validity_rule_status
1814: INTO l_delete_mark, l_status_code

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 1971: From gmd_operations r, gmd_status s

1967: FETCH get_operation_owner_orgn_id INTO l_orgn_id;
1968: CLOSE get_operation_owner_orgn_id;
1969: OPEN Status_cur FOR
1970: Select r.operation_status, s.version_enabled
1971: From gmd_operations r, gmd_status s
1972: Where r.oprn_id = Entity_id
1973: And r.operation_status = s.status_code;
1974: FETCH Status_cur INTO l_status, l_version_enabled;
1975: ClOSE Status_cur;

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)