DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on GMD_SUPPLIER_SPEC_VRS

Line 286: -- gmd_supplier_spec_vrs svr,

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
290: WHERE esd.sampling_event_id = se.sampling_event_id

Line 667: gmd_supplier_spec_vrs svr,

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
671: AND esd.sampling_event_id = se.sampling_event_id