286: INTO FROMDATE1
287: FROM
288: GMD_SAMPLES GS,
289: GMD_SAMPLING_EVENTS GSE,
290: GMD_SUPPLIER_SPEC_VRS GISV,
291: GMD_EVENT_SPEC_DISP GES
292: WHERE SAMPLE_NO = SAMPLE_NO2
293: AND GS.SAMPLING_EVENT_ID = GSE.SAMPLING_EVENT_ID
294: AND GSE.SAMPLING_EVENT_ID = GES.SAMPLING_EVENT_ID
309: INTO TODATE1
310: FROM
311: GMD_SAMPLES GS,
312: GMD_SAMPLING_EVENTS GSE,
313: GMD_SUPPLIER_SPEC_VRS GISV,
314: GMD_EVENT_SPEC_DISP GES
315: WHERE SAMPLE_NO = SAMPLE_NO2
316: AND GS.SAMPLING_EVENT_ID = GSE.SAMPLING_EVENT_ID
317: AND GSE.SAMPLING_EVENT_ID = GES.SAMPLING_EVENT_ID