[Home] [Help]
125: -- group using inventory spec vr
126: CURSOR c_inv_sampling_event IS
127: SELECT se.sampling_event_id
128: FROM gmd_sampling_events se,
129: -- gmd_specifications_b s,
130: -- gmd_inventory_spec_vrs ivr,
131: gmd_event_spec_disp esd
132: -- WHERE s.spec_id = ivr.spec_id
133: -- AND ivr.spec_vr_id = esd.spec_vr_id
228: -- group using inventory spec vr
229: CURSOR c_cust_sampling_event IS
230: SELECT se.sampling_event_id
231: FROM gmd_sampling_events se,
232: -- gmd_specifications_b s,
233: -- gmd_customer_spec_vrs cvr,
234: gmd_event_spec_disp esd
235: -- WHERE s.spec_id = cvr.spec_id
236: -- AND cvr.spec_vr_id = esd.spec_vr_id
281: -- Bug 3143796: added whse, location and lot_number
282: CURSOR c_supp_sampling_event IS
283: SELECT se.sampling_event_id
284: FROM gmd_sampling_events se,
285: -- gmd_specifications_b s,
286: -- gmd_supplier_spec_vrs svr,
287: gmd_event_spec_disp esd
288: -- WHERE s.spec_id = svr.spec_id
289: -- AND svr.spec_vr_id = esd.spec_vr_id
336: -- attached to resource samples.
337: CURSOR c_res_sampling_event IS
338: SELECT se.sampling_event_id
339: FROM gmd_sampling_events se,
340: -- gmd_specifications_b s,
341: -- gmd_monitoring_spec_vrs svr,
342: gmd_event_spec_disp esd
343: -- WHERE s.spec_id = svr.spec_id
344: -- AND svr.spec_vr_id = esd.spec_vr_id
382:
383: CURSOR c_loc_sampling_event IS
384: SELECT se.sampling_event_id
385: FROM gmd_sampling_events se,
386: -- gmd_specifications_b s,
387: -- gmd_monitoring_spec_vrs svr,
388: gmd_event_spec_disp esd
389: -- WHERE s.spec_id = svr.spec_id
390: -- AND svr.spec_vr_id = esd.spec_vr_id
508:
509: CURSOR c_inv_sampling_event IS
510: SELECT se.sampling_event_id
511: FROM gmd_sampling_events se,
512: gmd_specifications_b s,
513: gmd_inventory_spec_vrs ivr,
514: gmd_event_spec_disp esd
515: WHERE s.spec_id = ivr.spec_id
516: AND ivr.spec_vr_id = esd.spec_vr_id
549: -- Bug 4640143: added material detail id
550: CURSOR c_wip_sampling_event IS
551: SELECT se.sampling_event_id
552: FROM gmd_sampling_events se,
553: gmd_specifications_b s,
554: gmd_wip_spec_vrs wvr,
555: gmd_event_spec_disp esd
556: WHERE s.spec_id = wvr.spec_id
557: AND wvr.spec_vr_id = esd.spec_vr_id
615:
616: CURSOR c_cust_sampling_event IS
617: SELECT se.sampling_event_id
618: FROM gmd_sampling_events se,
619: gmd_specifications_b s,
620: gmd_customer_spec_vrs cvr,
621: gmd_event_spec_disp esd
622: WHERE s.spec_id = cvr.spec_id
623: AND cvr.spec_vr_id = esd.spec_vr_id
662:
663: CURSOR c_supp_sampling_event IS
664: SELECT se.sampling_event_id
665: FROM gmd_sampling_events se,
666: gmd_specifications_b s,
667: gmd_supplier_spec_vrs svr,
668: gmd_event_spec_disp esd
669: WHERE s.spec_id = svr.spec_id
670: AND svr.spec_vr_id = esd.spec_vr_id
705: -- attached to resource samples.
706: CURSOR c_res_sampling_event IS
707: SELECT se.sampling_event_id
708: FROM gmd_sampling_events se,
709: gmd_specifications_b s,
710: gmd_monitoring_spec_vrs svr,
711: gmd_event_spec_disp esd
712: WHERE s.spec_id = svr.spec_id
713: AND svr.spec_vr_id = esd.spec_vr_id
748:
749: CURSOR c_loc_sampling_event IS
750: SELECT se.sampling_event_id
751: FROM gmd_sampling_events se,
752: gmd_specifications_b s,
753: gmd_monitoring_spec_vrs svr,
754: gmd_event_spec_disp esd
755: WHERE s.spec_id = svr.spec_id
756: AND svr.spec_vr_id = esd.spec_vr_id