CRS_Choice

CREATE OR REPLACE FORCE VIEW CRS_Choice(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 = 'Geographic2D'
              AND (   crs.code IN (
                           SELECT from_geographic_crs
                             FROM r_carto_transform
                            WHERE to_geographic_crs =
                                                    (SELECT storage_crs
                                                       FROM 
project_default))
                   OR crs.code = (SELECT storage_crs
                                    FROM project_default)
                  )
             )
          OR (    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