DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on GMD_SUPPLIER_SPEC_VRS

Line 328: -- gmd_supplier_spec_vrs svr,

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

Line 739: gmd_supplier_spec_vrs svr,

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