Sur_Geometry_3D_N_Shape

CREATE OR REPLACE FORCE VIEW Sur_Geometry_3D_N_Shape(BIN_NODE_INC_ON_I_AXIS, BIN_NODE_INC_ON_J_AXIS, I_COORDINATE_LINE_COUNT, J_COORDINATE_LINE_COUNT, FIRST_CORNER_POINT_X, FIRST_CORNER_POINT_Y, SECOND_CORNER_POINT_X, SECOND_CORNER_POINT_Y, THIRD_CORNER_POINT_X, THIRD_CORNER_POINT_Y, BIN_WIDTH_ON_I_AXIS, BIN_WIDTH_ON_J_AXIS, ID, SURVEY_3D_ID, APPLICATION_PROJECT_ID, PROJECT_DATASTORE_ID, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, GUID, NAME, PROJECT_NAME, DATASTORE_NAME, ORIGINAL_SOURCE, PRODUCED_BY, REMARKS, SOURCE, LICENSE_HOLDER_ID, SURVEY_AREA_NAME, COUNTRY_NAME, SURVEY_CRS_ID, SURVEY_PROJECT_NAME, SURVEY_PROSPECT_NAME, SURVEY_UNIQUE_LOCATOR, FOREIGN_REP_OBJECT_ID, FOREIGN_REPOSITORY_SYSTEM, PARENT_3D_SURVEY_ID, FIRST_I_COORDINATE_LINE, FIRST_J_COORDINATE_LINE, LAST_I_COORDINATE_LINE, LAST_J_COORDINATE_LINE, CALCULATED_AREA, NOMINAL_AREA, SHAPE) AS SELECT CUBE_LATTICE.I_ANNOTATION_INCREMENT,
          CUBE_LATTICE.J_ANNOTATION_INCREMENT, CUBE_LATTICE.I_COUNT,
          
CUBE_LATTICE.J_COUNT, POINT_0_0.ORIGINAL_X_LONGITUDE,
          POINT_0_0.ORIGINAL_Y_LATITUDE, POINT_0_J.ORIGINAL_X_LONGITUDE,
          POINT_0_J.ORIGINAL_Y_LATITUDE, POINT_I_0.ORIGINAL_X_LONGITUDE,
          POINT_I_0.ORIGINAL_Y_LATITUDE,
            SQRT (  POWER (  POINT_I_0.ORIGINAL_X_LONGITUDE
                           - POINT_0_0.ORIGINAL_X_LONGITUDE,
                           2
                          )
                  + POWER (  POINT_I_0.ORIGINAL_Y_LATITUDE
                           - POINT_0_0.ORIGINAL_Y_LATITUDE,
                           2
                          )
                 )
          / (I_COUNT - 1),
            SQRT (  POWER (  POINT_0_J.ORIGINAL_X_LONGITUDE
                           - POINT_0_0.ORIGINAL_X_LONGITUDE,
                           2
                          )
                  + POWER (  POINT_0_J.ORIGINAL_Y_LATITUDE
                           - POINT_0_0.ORIGINAL_Y_LATITUDE,
                           2
                          )
     
            )
          / (J_COUNT - 1),
          CUBE_LATTICE.ID, CUBE_LATTICE.SURVEY_3D_ID, APPLICATION_PROJECT.ID,
          PROJECT_DATASTORE.ID, CUBE_LATTICE.INSERT_DATE,
          CUBE_LATTICE.INSERT_USER, CUBE_LATTICE.UPDATE_DATE,
          CUBE_LATTICE.UPDATE_USER, CUBE_LATTICE.GUID, CUBE_LATTICE.NAME,
          APPLICATION_PROJECT.NAME, PROJECT_DATASTORE.NAME,
          CUBE_LATTICE.ORIGINAL_SOURCE, CUBE_LATTICE.PRODUCED_BY,
          CUBE_LATTICE.REMARKS, CUBE_LATTICE.SOURCE,
          SURVEY_3D.LICENSE_HOLDER_ID, SURVEY_3D.SURVEY_AREA_NAME,
          SURVEY_3D.COUNTRY_NAME, SURVEY_3D.SURVEY_CRS_ID,
          SURVEY_3D.SURVEY_PROJECT_NAME, SURVEY_3D.SURVEY_PROSPECT_NAME,
          SURVEY_3D.SURVEY_UNIQUE_LOCATOR, SURVEY_3D.FOREIGN_REP_OBJECT_ID,
          SURVEY_3D.FOREIGN_REPOSITORY_SYSTEM, SURVEY_3D.PARENT_3D_SURVEY_ID,
          CUBE_LATTICE.I_ANNOTATION_AT_0_0, CUBE_LATTICE.J_ANNOTATION_AT_0_0,
            CUBE_LATTICE.I_ANNOTATION_AT_0_0
          + 
(CUBE_LATTICE.I_COUNT - 1) * CUBE_LATTICE.I_ANNOTATION_INCREMENT,
            CUBE_LATTICE.J_ANNOTATION_AT_0_0
          + (CUBE_LATTICE.J_COUNT - 1) * CUBE_LATTICE.J_ANNOTATION_INCREMENT,
          dst.CALCULATED_AREA,
          SURVEY_3D.NOMINAL_AREA,
          AREA.SHAPE
     FROM SURVEY_BOUNDARY,
          AREA,
          PROJECT_DATASTORE,
          APPLICATION_PROJECT,
          CUBE_LATTICE,
          SURVEY_3D,
          POSITION POINT_0_0,
          POSITION POINT_0_J,
          POSITION POINT_I_0,
          (SELECT calculated_area AS calculated_area,
                  cube_lattice_id
             FROM seismic_dataset_
            WHERE full_survey_extent_flag = 1 AND  SOURCE = 'SEISMIC') dst
      WHERE cube_lattice.survey_3d_id = survey_boundary.survey_3d_id(+)
      AND survey_boundary.polygon_geometry_id = area.ID(+)
      AND project_datastore.ID = application_project.project_datastore_id
      AND application_project.ID = survey_3d.application_project_id
      AND 
point_0_0.ID(+) = cube_lattice.point_0_0_position_id
      AND point_0_j.ID(+) = cube_lattice.point_0_j_position_id
      AND point_i_0.ID(+) = cube_lattice.point_i_0_position_id
      AND survey_3d.ID = cube_lattice.survey_3d_id
      AND cube_lattice.ID = dst.cube_lattice_id(+)