APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on GMD_INVENTORY_SPEC_VRS

Line 63: FROM GMD_INVENTORY_SPEC_VRS v

59: ====================================================*/
60:
61: cursor get_spec_type is
62: SELECT 'I' spec_type
63: FROM GMD_INVENTORY_SPEC_VRS v
64: WHERE v.spec_vr_id = lSpecVRId
65: UNION
66: SELECT 'W' spec_type
67: FROM GMD_WIP_SPEC_VRS V

Line 106: FROM GMD_INVENTORY_SPEC_VRS v ,

102: to_number(NULL) resource_instance_id,
103: v.last_updated_by ,
104: s.inventory_item_id,
105: v.subinventory, v.locator_id
106: FROM GMD_INVENTORY_SPEC_VRS v ,
107: GMD_SPECIFICATIONS_B s,
108: GMD_QC_STATUS_TL p,
109: GMD_QC_STATUS_TL t
110: WHERE V.SPEC_ID = S.SPEC_ID