DBA Data[Home] [Help]

APPS.GMD_QC_ERES_CHANGE_STATUS_PVT dependencies on GMD_WIP_SPEC_VRS

Line 92: UPDATE gmd_wip_spec_vrs

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
93: SET spec_vr_status = p_to_status
94: WHERE spec_vr_id = pspec_vr_id;
95: ELSIF(pentity_type = 'C') THEN
96: UPDATE gmd_customer_spec_vrs

Line 127: from GMD_WIP_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
127: from GMD_WIP_SPEC_VRS
128: where spec_id = p_spec_id
129: and spec_vr_status < p_to_status
130: UNION
131: select spec_vr_id,'C' spec_type

Line 204: UPDATE gmd_wip_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
204: UPDATE gmd_wip_spec_vrs
205: SET spec_vr_status = p_to_status
206: WHERE spec_vr_id = p_event_key
207: AND spec_vr_status <> p_to_status;
208: ELSIF p_event = 'oracle.apps.gmd.qm.spec.vr.cus' THEN