DBA Data[Home] [Help]

APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on GMD_SUPPLIER_SPEC_VRS

Line 75: FROM GMD_SUPPLIER_SPEC_VRS V

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
76: WHERE v.spec_vr_id = lSpecVRId
77: UNION
78: SELECT v.rule_type spec_type
79: FROM GMD_MONITORING_SPEC_VRS V

Line 181: FROM GMD_SUPPLIER_SPEC_VRS V ,

177: to_number(NULL) resource_instance_id,
178: v.last_updated_by ,
179: s.inventory_item_id,
180: NULL subinventory, NULL locator_id
181: FROM GMD_SUPPLIER_SPEC_VRS V ,
182: GMD_SPECIFICATIONS_B S,
183: GMD_QC_STATUS_TL p,
184: GMD_QC_STATUS_TL t
185: WHERE V.SPEC_ID = S.SPEC_ID