CRS_Transform_All

CREATE OR REPLACE FORCE VIEW CRS_Transform_All(ID, CRS_CODE, CRS_NAME, CRS_DESCRIPTION, CRS_TYPE, CRS_AREA_OF_USE, CRS_WELL_KNOWN_TEXT, CRS_BASE_GEOGRAPHIC_CODE, CRS_EPSG_ALIAS, CRS_ORIGINAL_SOURCE, CRS_SOURCE_VERSION, CRS_REVISION_DATE, TRANSFORM_CODE, TRANSFORM_NAME, TRANSFORM_DESCRIPTION, TRANSFORM_TYPE, TRANSFORM_AREA_OF_USE, TRANSFORM_WELL_KNOWN_TEXT, TRANSFORM_REVERSIBLE_FLAG, TRANSFORM_ORIGINAL_SOURCE, TRANSFORM_SOURCE_VERSION, TRANSFORM_REVISION_DATE) AS SELECT
   CRS.CODE as ID,
   CRS.CODE,
   CRS.NAME,
   CRS.DESCRIPTION,
   CRS.TYPE,
   CRS.AREA_OF_USE,
   CRS.OPENGIS_WELL_KNOWN_TEXT,
   CRS.BASE_GEOGRAPHIC_REF_SYS,
   CRS.EPSG_ALIAS,
   CRS.ORIGINAL_SOURCE,
   CRS.SOURCE_VERSION,
   CRS.REVISION_DATE,
   TFM.CODE,
   TFM.NAME,
   TFM.DESCRIPTION,
   TFM.TYPE,
   TFM.AREA_OF_USE,
   TFM.OPENGIS_WELL_KNOWN_TEXT,
   TFM.REVERSIBLE_FLAG,
   TFM.ORIGINAL_SOURCE,
   TFM.SOURCE_VERSION,
   TFM.REVISION_DATE
FROM
   R_COORDINATE_REF_SYSTEM CRS,
   R_CARTO_TRANSFORM TFM,
   
PROJECT_DEFAULT DEF
WHERE
   CRS_NAMESPACE = 'ESRI' AND
   CRS.TYPE = 'Geographic2D' AND
   ((TFM.FROM_GEOGRAPHIC_CRS = CRS.CODE AND
   TFM.TO_GEOGRAPHIC_CRS   = DEF.STORAGE_CRS) or
   (TFM.TO_GEOGRAPHIC_CRS = CRS.CODE AND
   TFM.FROM_GEOGRAPHIC_CRS   = DEF.STORAGE_CRS and reversible_flag = 1))
   OR
   CRS_NAMESPACE = 'ESRI' AND
   CRS.TYPE = 'Projected' AND
   ((TFM.FROM_GEOGRAPHIC_CRS = CRS.BASE_GEOGRAPHIC_REF_SYS AND
   TFM.TO_GEOGRAPHIC_CRS   = DEF.STORAGE_CRS) or
   (TFM.TO_GEOGRAPHIC_CRS = CRS.BASE_GEOGRAPHIC_REF_SYS AND
   TFM.FROM_GEOGRAPHIC_CRS   = DEF.STORAGE_CRS and reversible_flag = 1))