eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_QC_ERES_CHANGE_STATUS_PVT dependencies on GMD_INVENTORY_SPEC_VRS

Line 88: UPDATE gmd_inventory_spec_vrs

84: p_to_status IN NUMBER) IS
85: BEGIN
86:
87: IF (pentity_type = 'I') THEN
88: UPDATE gmd_inventory_spec_vrs
89: SET spec_vr_status = p_to_status
90: WHERE spec_vr_id = pspec_vr_id;
91: ELSIF(pentity_type = 'W') THEN
92: UPDATE gmd_wip_spec_vrs

Line 122: from GMD_INVENTORY_SPEC_VRS

118: FROM gmd_all_spec_vrs
119: WHERE spec_id = p_spec_id
120: AND spec_vr_status < p_to_status; */
121: select spec_vr_id, 'I' spec_type
122: from GMD_INVENTORY_SPEC_VRS
123: where spec_id = p_spec_id
124: and spec_vr_status < p_to_status
125: UNION
126: select spec_vr_id,'W' spec_type

Line 199: UPDATE gmd_inventory_spec_vrs

195: -- PRAGMA AUTONOMOUS_TRANSACTION;
196: BEGIN
197: /* Lets first update the status of the entity to to status */
198: IF p_event = 'oracle.apps.gmd.qm.spec.vr.inv' THEN
199: UPDATE gmd_inventory_spec_vrs
200: SET spec_vr_status = p_to_status
201: WHERE spec_vr_id = p_event_key
202: AND spec_vr_status <> p_to_status;
203: ELSIF p_event = 'oracle.apps.gmd.qm.spec.vr.wip' THEN