CRS_Transform

CREATE OR REPLACE FORCE VIEW CRS_Transform(ID, NAME, REMARKS, SOURCE, UPDATE_DATE, UPDATE_USER, CRS_UNIQUE_LOCATOR, 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
   CS.ID,
   CS.NAME,
   CS.REMARKS,
   CS.SOURCE,
   CS.UPDATE_DATE,
   CS.UPDATE_USER,
   CS.CRS_UNIQUE_LOCATOR,
   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
   COORDINATE_SYSTEM CS,
   R_COORDINATE_REF_SYSTEM CRS,
   R_CARTO_TRANSFORM TFM
WHERE
   CS.CRS = CRS.CODE AND
   CS.CARTO_TRANSFORM = TFM.CODE (+) AND
   CS.COORDINATE_SYSTEM_TYPE IS NULL AND
   CS.AZIMUTH_REFERENCE_ID IS NULL AND
   CS.VERTICAL_REFERENCE IS NULL AND
   CS.FROM_COORD_SYS_ID IS NULL AND
   CS.X_OFFSET IS NULL AND
   CS.Y_OFFSET IS NULL AND
   CS.Z_OFFSET IS NULL AND
   CS.ROTATION_X IS NULL AND
   CS.ROTATION_Y IS NULL AND
   CS.ROTATION_Z IS NULL