376: FROM
377: GMD_SAMPLES GS,
378: GMD_SAMPLING_EVENTS GSE,
379: GMD_WIP_SPEC_VRS GISV,
380: GMD_EVENT_SPEC_DISP GES
381: WHERE SAMPLE_NO = SAMPLE_NO_V
382: AND GS.SAMPLING_EVENT_ID = GSE.SAMPLING_EVENT_ID
383: AND GSE.SAMPLING_EVENT_ID = GES.SAMPLING_EVENT_ID
384: AND GES.SPEC_USED_FOR_LOT_ATTRIB_IND = 'Y'
399: FROM
400: GMD_SAMPLES GS,
401: GMD_SAMPLING_EVENTS GSE,
402: GMD_WIP_SPEC_VRS GISV,
403: GMD_EVENT_SPEC_DISP GES
404: WHERE SAMPLE_NO = SAMPLE_NO_V
405: AND GS.SAMPLING_EVENT_ID = GSE.SAMPLING_EVENT_ID
406: AND GSE.SAMPLING_EVENT_ID = GES.SAMPLING_EVENT_ID
407: AND GES.SPEC_USED_FOR_LOT_ATTRIB_IND = 'Y'