DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on GMD_INVENTORY_SPEC_VRS

Line 130: -- gmd_inventory_spec_vrs ivr,

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

Line 513: gmd_inventory_spec_vrs ivr,

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