DBA Data[Home] [Help]

APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on GMD_MONITORING_SPEC_VRS

Line 79: FROM GMD_MONITORING_SPEC_VRS V

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
80: WHERE v.spec_vr_id = lSpecVRId
81: UNION
82: SELECT 'T' spec_type
83: FROM GMD_STABILITY_SPEC_VRS V

Line 206: FROM GMD_MONITORING_SPEC_VRS V ,

202: resource_instance_id,
203: v.last_updated_by ,
204: TO_NUMBER(NULL),
205: v.subinventory, v.locator_id
206: FROM GMD_MONITORING_SPEC_VRS V ,
207: GMD_SPECIFICATIONS_B S,
208: GMD_QC_STATUS_TL p,
209: GMD_QC_STATUS_TL t
210: WHERE V.SPEC_ID = S.SPEC_ID

Line 304: FROM GMD_MONITORING_SPEC_VRS V ,

300: src_type.meaning,
301: locations.concatenated_segments LOC,
302: a.organization_code,
303: hou.name organization_name
304: FROM GMD_MONITORING_SPEC_VRS V ,
305: GMD_SPECIFICATIONS_B S,
306: GMD_QC_STATUS_TL p,
307: GMD_QC_STATUS_TL t,
308: GEM_LOOKUPS src_type ,