APPS.GMD_QUALITY_GRP dependencies on GMD_EVENT_SPEC_DISP

Line 552: gmd_event_spec_disp sd

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)
556: OR (p_inv_rslt_inp_rec.parent_lot_number IS NULL AND se.parent_lot_number IS NULL)