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_UTILS dependencies on GMD_INVENTORY_SPEC_VRS

Line 125: UPDATE gmd_inventory_spec_vrs

121: p_to_status IN NUMBER) IS
122: BEGIN
123:
124: IF (pentity_type = 'I') THEN
125: UPDATE gmd_inventory_spec_vrs
126: SET spec_vr_status = p_to_status
127: WHERE spec_vr_id = pspec_vr_id;
128: ELSIF(pentity_type = 'W') THEN
129: UPDATE gmd_wip_spec_vrs

Line 156: FROM gmd_inventory_spec_vrs v

152: --RLNAGARA Bug # 4918840
153:
154: CURSOR Cur_get_validity IS
155: SELECT v.spec_vr_id,'I' spec_type
156: FROM gmd_inventory_spec_vrs v
157: WHERE v.spec_id = p_spec_id
158: AND v.spec_vr_status < p_to_status
159: UNION
160: SELECT v.spec_vr_id,'W' spec_type

Line 234: UPDATE gmd_inventory_spec_vrs

230: BEGIN
231:
232: /* Lets first update the status of the entity to to status */
233: IF p_event = 'oracle.apps.gmd.qm.spec.vr.inv' THEN
234: UPDATE gmd_inventory_spec_vrs
235: SET spec_vr_status = p_to_status
236: WHERE spec_vr_id = p_event_key
237: AND spec_vr_status <> p_to_status;
238: ELSIF p_event = 'oracle.apps.gmd.qm.spec.vr.wip' THEN