DBA Data[Home] [Help]

APPS.GMD_SPEC_GRP dependencies on GMD_STABILITY_SPEC_VRS

Line 2405: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_STABILITY_SPEC_VRS b,

2401: b.spec_id = p_spec_id
2402: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID
2403: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'
2404: UNION
2405: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_STABILITY_SPEC_VRS b,
2406: gmd_qc_status_tl t
2407: WHERE
2408: b.spec_id = p_spec_id
2409: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID