CRS_Choice_Projected

CREATE OR REPLACE FORCE VIEW CRS_Choice_Projected(ID, ACTIVE_FLAG, CODE, DESCRIPTION, NAME, SOURCE, UPDATE_DATE, UPDATE_USER, AREA_OF_USE, BASE_GEOGRAPHIC_REF_SYS, EPSG_ALIAS, OPENGIS_WELL_KNOWN_TEXT, ORIGINAL_SOURCE, REVISION_DATE, SOURCE_VERSION, TYPE) AS SELECT CODE as ID, ACTIVE_FLAG,CODE,DESCRIPTION,NAME,SOURCE,UPDATE_DATE,UPDATE_USER,AREA_OF_USE,BASE_GEOGRAPHIC_REF_SYS,EPSG_ALIAS,OPENGIS_WELL_KNOWN_TEXT,ORIGINAL_SOURCE,REVISION_DATE,SOURCE_VERSION,TYPE
FROM
   R_COORDINATE_REF_SYSTEM CRS
WHERE
   CRS_NAMESPACE = 'ESRI' AND
   SOURCE not in ('OpenSpirit', 'Mentor Mapping') AND
   (CRS.TYPE = 'Projected' AND
     ((CRS.BASE_GEOGRAPHIC_REF_SYS IN (SELECT FROM_GEOGRAPHIC_CRS
                                      FROM R_CARTO_TRANSFORM
                                      WHERE TO_GEOGRAPHIC_CRS = (SELECT STORAGE_CRS
                                                                 FROM PROJECT_DEFAULT))
     OR
     (CRS.BASE_GEOGRAPHIC_REF_SYS IN (SELECT TO_GEOGRAPHIC_CRS
          
                            FROM R_CARTO_TRANSFORM
                                      WHERE FROM_GEOGRAPHIC_CRS = (SELECT STORAGE_CRS
                                                                 FROM PROJECT_DEFAULT) and reversible_flag = 1)))
OR
     CRS.BASE_GEOGRAPHIC_REF_SYS = (SELECT STORAGE_CRS FROM PROJECT_DEFAULT)))
ORDER BY NAME