APPS.GMD_SPEC_GRP dependencies on GMD_INVENTORY_SPEC_VRS

Line 2370: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_INVENTORY_SPEC_VRS b,

2366: WHERE
2367: b.spec_id = p_spec_id
2368: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID ; */
2369:
2370: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_INVENTORY_SPEC_VRS b,
2371: gmd_qc_status_tl t
2372: WHERE
2373: b.spec_id = p_spec_id
2374: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID