text: create or replace view OSP$UNIT as 
  	select UNIT_NUMBER,UNIT_NAME,ADMINISTRATIVE_OFFICER,OSP_ADMINISTRATOR,UNIT_HEAD,DEAN_VP,
  	OTHER_INDIVIDUAL_TO_NOTIFY,ORGANIZATION_ID,UPDATE_TIMESTAMP,UPDATE_USER
  	from UNIT;