Seismic_Line_N

CREATE OR REPLACE FORCE VIEW Seismic_Line_N(ID, SURVEY_2D_ID, APPLICATION_PROJECT_ID, PROJECT_DATASTORE_ID, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, GUID, NAME, SURVEY_NAME, PROJECT_NAME, DATASTORE_NAME, ORIGINAL_SOURCE, PRODUCED_BY, REMARKS, SOURCE, CDP_INCREMENT, FIRST_CDP, FIRST_SHOTPOINT, FOREIGN_REP_OBJECT_ID, FOREIGN_REPOSITORY_SYSTEM, LAST_CDP, LAST_SHOTPOINT, LINE_GEOMETRY_ID, LINE_RANK, NOMINAL_LENGTH, NOMINAL_SHOT_INTERVAL, SEISMIC_LINE_TYPE, SEISMIC_LINE_UNIQUE_LOCATOR, SHOT_DIVISOR, SHOT_INCREMENT, CALCULATED_LENGTH, CALCULATED_SHOT_INTERVAL) AS select SEISMIC_LINE.ID,
       SURVEY_2D.ID,
       APPLICATION_PROJECT.ID,
       PROJECT_DATASTORE.ID,
       SEISMIC_LINE.INSERT_DATE,
       SEISMIC_LINE.INSERT_USER,
       SEISMIC_LINE.UPDATE_DATE,
       SEISMIC_LINE.UPDATE_USER,
       SEISMIC_LINE.GUID,
       SEISMIC_LINE.NAME,
       SURVEY_2D.NAME,
       APPLICATION_PROJECT.NAME,
       PROJECT_DATASTORE.NAME,
       SEISMIC_LINE.ORIGINAL_SOURCE,
       
SEISMIC_LINE.PRODUCED_BY,
       SEISMIC_LINE.REMARKS,
       SEISMIC_LINE.SOURCE,
       SEISMIC_LINE.CDP_INCREMENT,
       SEISMIC_LINE.FIRST_CDP,
       SEISMIC_LINE.FIRST_SHOTPOINT,
       SEISMIC_LINE.FOREIGN_REP_OBJECT_ID,
       SEISMIC_LINE.FOREIGN_REPOSITORY_SYSTEM,
       SEISMIC_LINE.LAST_CDP,
       SEISMIC_LINE.LAST_SHOTPOINT,
       SEISMIC_LINE.LINE_GEOMETRY_ID,
       SEISMIC_LINE.LINE_RANK,
       SEISMIC_LINE.NOMINAL_LINE_LENGTH,
       SEISMIC_LINE.NOMINAL_SHOT_INTERVAL,
       SEISMIC_LINE.SEISMIC_LINE_TYPE,
       SEISMIC_LINE.SEISMIC_LINE_UNIQUE_LOCATOR,
       SEISMIC_LINE.SHOT_DIVISOR,
       SEISMIC_LINE.SHOT_INCREMENT,
       SEISMIC_LINE.CALCULATED_LINE_LENGTH,
       SEISMIC_LINE.CALCULATED_SHOT_INTERVAL
from PROJECT_DATASTORE, APPLICATION_PROJECT, SURVEY_2D, SEISMIC_LINE
where PROJECT_DATASTORE.ID = APPLICATION_PROJECT.PROJECT_DATASTORE_ID
  and APPLICATION_PROJECT.ID = SURVEY_2D.APPLICATION_PROJECT_ID
        and SURVEY_2D.ID = SEISMIC_LINE.SURVEY_2D_ID