clean up views and functions which moved to summary db

removing the view replaced by summary db