Survey_Geometry_3D_N

CREATE OR REPLACE FORCE VIEW Survey_Geometry_3D_N(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, 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, NOMINAL_AREA, CALCULATED_AREA) AS SELECT Survey_Geometry_3D.ID,
    Survey_Geometry_3D.SURVEY_3D_ID,
    APPLICATION_PROJECT.ID,
    PROJECT_DATASTORE.ID,
    
Survey_Geometry_3D.INSERT_DATE,
    Survey_Geometry_3D.INSERT_USER,
    Survey_Geometry_3D.UPDATE_DATE,
    Survey_Geometry_3D.UPDATE_USER,
    Survey_Geometry_3D.GUID,
    Survey_Geometry_3D.NAME,
    APPLICATION_PROJECT.NAME,
    PROJECT_DATASTORE.NAME,
    Survey_Geometry_3D.ORIGINAL_SOURCE,
    Survey_Geometry_3D.PRODUCED_BY,
    Survey_Geometry_3D.REMARKS,
    Survey_Geometry_3D.SOURCE,
    Survey_Geometry_3D.LICENSE_HOLDER_ID,
    Survey_Geometry_3D.SURVEY_AREA_NAME,
    Survey_Geometry_3D.COUNTRY_NAME,
    Survey_Geometry_3D.SURVEY_CRS_ID,
    Survey_Geometry_3D.SURVEY_PROJECT_NAME,
    Survey_Geometry_3D.SURVEY_PROSPECT_NAME,
    Survey_Geometry_3D.SURVEY_UNIQUE_LOCATOR,
    Survey_Geometry_3D.FOREIGN_REP_OBJECT_ID,
    Survey_Geometry_3D.FOREIGN_REPOSITORY_SYSTEM,
    Survey_Geometry_3D.PARENT_3D_SURVEY_ID,
    Survey_Geometry_3D.FIRST_I_COORDINATE_LINE,
    Survey_Geometry_3D.FIRST_J_COORDINATE_LINE,
    Survey_Geometry_3D.LAST_I_COORDINATE_LINE,
    
Survey_Geometry_3D.LAST_J_COORDINATE_LINE,
    Survey_Geometry_3D.BIN_NODE_INC_ON_I_AXIS,
    Survey_Geometry_3D.BIN_NODE_INC_ON_J_AXIS,
    Survey_Geometry_3D.I_COORDINATE_LINE_COUNT,
    Survey_Geometry_3D.J_COORDINATE_LINE_COUNT,
    Survey_Geometry_3D.FIRST_CORNER_POINT_X,
    Survey_Geometry_3D.FIRST_CORNER_POINT_Y,
    Survey_Geometry_3D.SECOND_CORNER_POINT_X,
    Survey_Geometry_3D.SECOND_CORNER_POINT_Y,
    Survey_Geometry_3D.THIRD_CORNER_POINT_X,
    Survey_Geometry_3D.THIRD_CORNER_POINT_Y,
    Survey_Geometry_3D.BIN_WIDTH_ON_I_AXIS,
    Survey_Geometry_3D.BIN_WIDTH_ON_J_AXIS,
    Survey_Geometry_3D.NOMINAL_AREA,
    dst.CALCULATED_AREA
  FROM PROJECT_DATASTORE,
    APPLICATION_PROJECT,
    Survey_Geometry_3D,
    (SELECT calculated_area AS calculated_area,
      cube_lattice_id
    FROM seismic_dataset_
    WHERE full_survey_extent_flag = 1
    ) dst
  WHERE PROJECT_DATASTORE.ID = APPLICATION_PROJECT.PROJECT_DATASTORE_ID
  AND APPLICATION_PROJECT.ID = 
Survey_Geometry_3D.APPLICATION_PROJECT_ID
  AND survey_geometry_3d.ID  = dst.cube_lattice_id(+)