APPS.EAM_LINEAR_LOCATIONS_PUB dependencies on MTL_SERIAL_NUMBERS

Line 992: from mtl_serial_numbers

988: -- First get the asset number for the maintenance_object_id
989: -- if it has not been passed.
990: if l_eam_wo_rec.asset_number is null then
991: select serial_number into l_eam_wo_rec.asset_number
992: from mtl_serial_numbers
993: where gen_object_id = l_eam_wo_rec.maintenance_object_id
994: and current_organization_id = l_eam_wo_rec.organization_id;
995: end if;
996: