Seismic_Line_3D_N_Shape

CREATE OR REPLACE FORCE VIEW Seismic_Line_3D_N_Shape(ID, SURVEY_3D_ID, SOURCE_DATASET_ID, APPLICATION_PROJECT_ID, PROJECT_DATASTORE_ID, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, GUID, NAME, VERSION, SURVEY_NAME, PROJECT_NAME, DATASTORE_NAME, ORIGINAL_SOURCE, PRODUCED_BY, REMARKS, SOURCE, FOREIGN_REP_OBJECT_ID, FOREIGN_REPOSITORY_SYSTEM, LINE_GEOMETRY_ID, LINE_RANK, SEISMIC_LINE_TYPE, SEISMIC_LINE_STYLE, SEISMIC_LINE_UNIQUE_LOCATOR, SHAPE) AS SELECT SEISMIC_LINE.ID,
          SURVEY_3D.ID,
          SEISMIC_LINE.SOURCE_DATASET_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,
          SEISMIC_LINE.VERSION,
          SURVEY_3D.NAME,
          APPLICATION_PROJECT.NAME,
          PROJECT_DATASTORE.NAME,
          SEISMIC_LINE.ORIGINAL_SOURCE,
          
SEISMIC_LINE.PRODUCED_BY,
          SEISMIC_LINE.REMARKS,
          SEISMIC_LINE.SOURCE,
          SEISMIC_LINE.FOREIGN_REP_OBJECT_ID,
          SEISMIC_LINE.FOREIGN_REPOSITORY_SYSTEM,
          SEISMIC_LINE.LINE_GEOMETRY_ID,
          SEISMIC_LINE.LINE_RANK,
          SEISMIC_LINE.SEISMIC_LINE_TYPE,
          SEISMIC_LINE.SEISMIC_LINE_STYLE,
          SEISMIC_LINE.SEISMIC_LINE_UNIQUE_LOCATOR,
          LINE.SHAPE
     FROM PROJECT_DATASTORE,
          APPLICATION_PROJECT,
          SURVEY_3D,
          SEISMIC_LINE,
          LINE
    WHERE PROJECT_DATASTORE.ID(+) = APPLICATION_PROJECT.PROJECT_DATASTORE_ID
          AND APPLICATION_PROJECT.ID(+) = SURVEY_3D.APPLICATION_PROJECT_ID
          AND SURVEY_3D.ID(+) = SEISMIC_LINE.SURVEY_3D_ID
          AND (SEISMIC_LINE.SEISMIC_LINE_STYLE = 'Inline'
               OR SEISMIC_LINE.SEISMIC_LINE_STYLE = 'Crossline')
          AND SEISMIC_LINE.LINE_GEOMETRY_ID = LINE.ID