DBA Data[Home] [Help]

APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on GMD_WIP_SPEC_VRS

Line 67: FROM GMD_WIP_SPEC_VRS V

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
68: WHERE v.spec_vr_id = lSpecVRId
69: UNION
70: SELECT 'C' spec_type
71: FROM GMD_CUSTOMER_SPEC_VRS V

Line 131: FROM GMD_WIP_SPEC_VRS V ,

127: to_number(NULL) resource_instance_id,
128: v.last_updated_by ,
129: s.inventory_item_id,
130: NULL subinventory, NULL locator_id
131: FROM GMD_WIP_SPEC_VRS V ,
132: GMD_SPECIFICATIONS_B S,
133: GMD_QC_STATUS_TL p,
134: GMD_QC_STATUS_TL t
135: WHERE V.SPEC_ID = S.SPEC_ID