[Home] [Help]
158: -- group using inventory spec vr
159: CURSOR c_inv_sampling_event IS
160: SELECT se.sampling_event_id
161: FROM gmd_sampling_events se,
162: -- gmd_specifications_b s,
163: -- gmd_inventory_spec_vrs ivr,
164: gmd_event_spec_disp esd
165: -- WHERE s.spec_id = ivr.spec_id
166: -- AND ivr.spec_vr_id = esd.spec_vr_id
267: -- group using inventory spec vr
268: CURSOR c_cust_sampling_event IS
269: SELECT se.sampling_event_id
270: FROM gmd_sampling_events se,
271: -- gmd_specifications_b s,
272: -- gmd_customer_spec_vrs cvr,
273: gmd_event_spec_disp esd
274: -- WHERE s.spec_id = cvr.spec_id
275: -- AND cvr.spec_vr_id = esd.spec_vr_id
323: -- Bug 3143796: added whse, location and lot_number
324: CURSOR c_supp_sampling_event IS
325: SELECT se.sampling_event_id
326: FROM gmd_sampling_events se,
327: -- gmd_specifications_b s,
328: -- gmd_supplier_spec_vrs svr,
329: gmd_event_spec_disp esd
330: -- WHERE s.spec_id = svr.spec_id
331: -- AND svr.spec_vr_id = esd.spec_vr_id
381: -- attached to resource samples.
382: CURSOR c_res_sampling_event IS
383: SELECT se.sampling_event_id
384: FROM gmd_sampling_events se,
385: -- gmd_specifications_b s,
386: -- gmd_monitoring_spec_vrs svr,
387: gmd_event_spec_disp esd
388: -- WHERE s.spec_id = svr.spec_id
389: -- AND svr.spec_vr_id = esd.spec_vr_id
427:
428: CURSOR c_loc_sampling_event IS
429: SELECT se.sampling_event_id
430: FROM gmd_sampling_events se,
431: -- gmd_specifications_b s,
432: -- gmd_monitoring_spec_vrs svr,
433: gmd_event_spec_disp esd
434: -- WHERE s.spec_id = svr.spec_id
435: -- AND svr.spec_vr_id = esd.spec_vr_id
571:
572: CURSOR c_inv_sampling_event IS
573: SELECT se.sampling_event_id
574: FROM gmd_sampling_events se,
575: gmd_specifications_b s,
576: gmd_inventory_spec_vrs ivr,
577: gmd_event_spec_disp esd
578: WHERE s.spec_id = ivr.spec_id
579: AND ivr.spec_vr_id = esd.spec_vr_id
615: -- Bug 4640143: added material detail id
616: CURSOR c_wip_sampling_event IS
617: SELECT se.sampling_event_id
618: FROM gmd_sampling_events se,
619: gmd_specifications_b s,
620: gmd_wip_spec_vrs wvr,
621: gmd_event_spec_disp esd
622: WHERE s.spec_id = wvr.spec_id
623: AND wvr.spec_vr_id = esd.spec_vr_id
684:
685: CURSOR c_cust_sampling_event IS
686: SELECT se.sampling_event_id
687: FROM gmd_sampling_events se,
688: gmd_specifications_b s,
689: gmd_customer_spec_vrs cvr,
690: gmd_event_spec_disp esd
691: WHERE s.spec_id = cvr.spec_id
692: AND cvr.spec_vr_id = esd.spec_vr_id
734:
735: CURSOR c_supp_sampling_event IS
736: SELECT se.sampling_event_id
737: FROM gmd_sampling_events se,
738: gmd_specifications_b s,
739: gmd_supplier_spec_vrs svr,
740: gmd_event_spec_disp esd
741: WHERE s.spec_id = svr.spec_id
742: AND svr.spec_vr_id = esd.spec_vr_id
780: -- attached to resource samples.
781: CURSOR c_res_sampling_event IS
782: SELECT se.sampling_event_id
783: FROM gmd_sampling_events se,
784: gmd_specifications_b s,
785: gmd_monitoring_spec_vrs svr,
786: gmd_event_spec_disp esd
787: WHERE s.spec_id = svr.spec_id
788: AND svr.spec_vr_id = esd.spec_vr_id
823:
824: CURSOR c_loc_sampling_event IS
825: SELECT se.sampling_event_id
826: FROM gmd_sampling_events se,
827: gmd_specifications_b s,
828: gmd_monitoring_spec_vrs svr,
829: gmd_event_spec_disp esd
830: WHERE s.spec_id = svr.spec_id
831: AND svr.spec_vr_id = esd.spec_vr_id