CREATE OR REPLACE VIEW biotics_user.ksnpc_site_megasite_vw
(
    mega_site_id
  , ms
  , d_site_class_id
  , conservation_site_id
  , ss
)
AS
Select 	distinct MS.mega_site_id, 
	siteb.site_name MS, 
	siteb.d_site_class_id,
	MS.conservation_site_Id, 
	sitea.site_name ss
From 	Site_megasite MS, 
	conservation_site sitea, 
	conservation_site siteb 
Where	MS.conservation_site_id = sitea.conservation_site_id and 
	MS.mega_site_id = siteb.conservation_site_id and
	siteb.d_site_class_id = 2;
grant select on ksnpc_site_megasite_vw to biotics_report;