APPS.GMD_COMMON_VAL dependencies on GMD_OPERATIONS

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

1755: WHERE routing_id = Entity_id;
1756: ELSIF (Entity = 'OPERATION') THEN
1757: SELECT delete_mark, operation_status
1758: INTO l_delete_mark, l_status_code
1759: FROM gmd_operations
1760: WHERE oprn_id = Entity_id;
1761: ELSIF (Entity = 'VALIDITY') THEN
1762: SELECT delete_mark, validity_rule_status
1763: INTO l_delete_mark, l_status_code

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

1909: FETCH get_operation_owner_orgn_id INTO l_orgn_id;
1910: CLOSE get_operation_owner_orgn_id;
1911: OPEN Status_cur FOR
1912: Select r.operation_status, s.version_enabled
1913: From gmd_operations r, gmd_status s
1914: Where r.oprn_id = Entity_id
1915: And r.operation_status = s.status_code;
1916: FETCH Status_cur INTO l_status, l_version_enabled;
1917: ClOSE Status_cur;

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)