DBA Data[Home] [Help]

APPS.GMD_QUALITY_GRP dependencies on GMD_SAMPLING_EVENTS

Line 551: FROM gmd_sampling_events se,

547: CURSOR get_sample_events IS
548: SELECT se.sampling_event_id, se.sample_active_cnt, se.inventory_item_id,
549: se.parent_lot_number, se.lot_number, se.subinventory, se.locator_id,
550: sd.event_spec_disp_id, sd.spec_id
551: FROM gmd_sampling_events se,
552: gmd_event_spec_disp sd
553: WHERE se.sampling_event_id = sd.sampling_event_id
554: AND se.inventory_item_id = p_inv_rslt_inp_rec.inventory_item_id
555: AND ((se.parent_lot_number = p_inv_rslt_inp_rec.parent_lot_number)