This view is from Kee in Tennessee. Thanks!!!

CREATE OR REPLACE VIEW ENV_REVIEW_VW
AS
SELECT
EO.EO_ID,
EO.SHAPE_ID,
EOCODE_VW.EOCODE,
D_NAME_CATEGORY.NAME_CATEGORY_DESC,
SCIENTIFIC_NAME.SCIENTIFIC_NAME,
ELEMENT_SUBNATIONAL.S_PRIMARY_COMMON_NAME COMMON_NAME,
ELEMENT_GLOBAL.G_RANK,
ELEMENT_SUBNATIONAL.S_RANK,
D_USESA.DISPLAY_VALUE USESA,
ELEMENT_SUBNATIONAL.S_PROTECTION_STATUS SPROT,
D_BASIC_EO_RANK.DISPLAY_VALUE EO_RANK,
EO.LAST_OBS_DATE LAST_OBS,
EO.LATITUDE,
EO.LONGITUDE,
EO.REFERENCE_POINT_X X,
EO.REFERENCE_POINT_Y Y,
dbms_lob.SUBSTR(EO.GEN_DESC,255,1) GEN_DESC,
dbms_lob.SUBSTR(EO.EO_DATA,255,1) EO_DATA,
SUBSTR(EO.DIRECTIONS,1,255) DIRECTIONS
FROM
EO, D_BASIC_EO_RANK, ELEMENT_SUBNATIONAL,
ELEMENT_NATIONAL, ELEMENT_GLOBAL, TAXON_GLOBAL, D_USESA,
TAXON_SUBNATIONAL, SCIENTIFIC_NAME,
PLANT_CAG, ANIMAL_CAG, D_NAME_CATEGORY, D_EO_TRACK_STATUS, EOCODE_VW
WHERE
SCIENTIFIC_NAME.D_NAME_CATEGORY_ID= D_NAME_CATEGORY.D_NAME_CATEGORY_ID (+) AND
EO.ELEMENT_SUBNATIONAL_ID = ELEMENT_SUBNATIONAL.ELEMENT_SUBNATIONAL_ID(+) AND
EO.D_BASIC_EO_RANK_ID = D_BASIC_EO_RANK.D_BASIC_EO_RANK_ID(+) AND
ELEMENT_SUBNATIONAL.ELEMENT_NATIONAL_ID = ELEMENT_NATIONAL.ELEMENT_NATIONAL_ID AND
ELEMENT_NATIONAL.ELEMENT_GLOBAL_ID = ELEMENT_GLOBAL.ELEMENT_GLOBAL_ID AND
ELEMENT_GLOBAL.ELEMENT_GLOBAL_ID = TAXON_GLOBAL.ELEMENT_GLOBAL_ID(+) AND
TAXON_GLOBAL.D_USESA_ID = D_USESA.D_USESA_ID(+) AND
EO.ELEMENT_SUBNATIONAL_ID = TAXON_SUBNATIONAL.ELEMENT_SUBNATIONAL_ID AND
ELEMENT_SUBNATIONAL.SNAME_ID = SCIENTIFIC_NAME.SCIENTIFIC_NAME_ID(+) AND
TAXON_GLOBAL.ELEMENT_GLOBAL_ID = PLANT_CAG.ELEMENT_GLOBAL_ID(+) AND
TAXON_GLOBAL.ELEMENT_GLOBAL_ID = ANIMAL_CAG.ELEMENT_GLOBAL_ID(+) AND
D_EO_TRACK_STATUS.EO_TRACK_STATUS_CD = 'Y' AND
EO.SHAPE_ID = EOCODE_VW.EO_SHAPE_ID;