Survey_2D_N

CREATE OR REPLACE FORCE VIEW Survey_2D_N(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_2D_SURVEY_ID, TOTAL_CALCULATED_LINE_LENGTH, TOTAL_NOMINAL_LINE_LENGTH) AS select SURVEY_2D.ID,
       APPLICATION_PROJECT.ID,
       PROJECT_DATASTORE.ID,
       SURVEY_2D.INSERT_DATE,
       SURVEY_2D.INSERT_USER,
       SURVEY_2D.UPDATE_DATE,
       SURVEY_2D.UPDATE_USER,
       SURVEY_2D.GUID,
       SURVEY_2D.NAME,
       APPLICATION_PROJECT.NAME,
       PROJECT_DATASTORE.NAME,
       SURVEY_2D.ORIGINAL_SOURCE,
       SURVEY_2D.PRODUCED_BY,
       SURVEY_2D.REMARKS,
       SURVEY_2D.SOURCE,
       SURVEY_2D.LICENSE_HOLDER_ID,
       SURVEY_2D.SURVEY_AREA_NAME,
       
SURVEY_2D.COUNTRY_NAME,
       SURVEY_2D.SURVEY_CRS_ID,
       SURVEY_2D.SURVEY_PROJECT_NAME,
       SURVEY_2D.SURVEY_PROSPECT_NAME,
       SURVEY_2D.SURVEY_UNIQUE_LOCATOR,
       SURVEY_2D.FOREIGN_REP_OBJECT_ID,
       SURVEY_2D.FOREIGN_REPOSITORY_SYSTEM,
       SURVEY_2D.PARENT_2D_SURVEY_ID,
       SEISLN.TOTAL_CALCULATED_LINE_LENGTH,
       SEISLN.TOTAL_NOMINAL_LINE_LENGTH
from PROJECT_DATASTORE, APPLICATION_PROJECT, SURVEY_2D,
         (SELECT SUM(calculated_line_length) AS total_calculated_line_length,
                 SUM (nominal_line_length) AS total_nominal_line_length,survey_2d_id
          FROM seismic_line_ GROUP BY survey_2d_id) SEISLN
where PROJECT_DATASTORE.ID = APPLICATION_PROJECT.PROJECT_DATASTORE_ID
  and APPLICATION_PROJECT.ID = SURVEY_2D.APPLICATION_PROJECT_ID
  AND survey_2d.ID = SEISLN.survey_2d_id(+)