APPS.CSD_REPAIR_MANAGER_UTIL dependencies on MTL_SERIAL_NUMBERS

Line 1969: from mtl_serial_numbers

1965: if p_repln_rec.item_revision is null and p_repln_rec.serial_number is not null then
1966: -- no revision is passed in. Need to get the default revision.
1967: select revision
1968: into p_repln_rec.item_revision
1969: from mtl_serial_numbers
1970: where serial_number = p_repln_rec.serial_number
1971: and inventory_item_id = p_repln_rec.inventory_item_id;
1972: end if;
1973: end if;