DBA Data[Home] [Help]

APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on GMD_CUSTOMER_SPEC_VRS

Line 71: FROM GMD_CUSTOMER_SPEC_VRS V

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
72: WHERE v.spec_vr_id = lSpecVRId
73: UNION
74: SELECT 'S' spec_type
75: FROM GMD_SUPPLIER_SPEC_VRS V

Line 156: FROM GMD_CUSTOMER_SPEC_VRS V ,

152: to_number(NULL) resource_instance_id,
153: v.last_updated_by ,
154: s.inventory_item_id,
155: NULL subinventory, NULL locator_id
156: FROM GMD_CUSTOMER_SPEC_VRS V ,
157: GMD_SPECIFICATIONS_B S,
158: GMD_QC_STATUS_TL p,
159: GMD_QC_STATUS_TL t
160: WHERE V.SPEC_ID = S.SPEC_ID