SAIL_LINE_N_SHAPE_3D

CREATE OR REPLACE FORCE VIEW Sail_Line_N_Shape_3D(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, FIRST_SHOTPOINT, FOREIGN_REP_OBJECT_ID, FOREIGN_REPOSITORY_SYSTEM, LAST_SHOTPOINT, LINE_GEOMETRY_ID, LINE_RANK, NOMINAL_LINE_LENGTH, NOMINAL_SHOT_INTERVAL, CALCULATED_LINE_LENGTH, CALCULATED_SHOT_INTERVAL, SEISMIC_LINE_UNIQUE_LOCATOR, SHOT_DIVISOR, SHOT_INCREMENT, VESSEL_NAME, SOURCE_LINE_IDENTIFIER, SURVEY_3D_ID, SAIL_LINE_ID, SOURCE_DATASET_ID, SHAPE) AS SELECT SEISMIC_LINE.ID ID,
          APPLICATION_PROJECT.ID APPLICATION_PROJECT_ID,
          PROJECT_DATASTORE.ID PROJECT_DATASTORE_ID,
          SEISMIC_LINE.INSERT_DATE INSERT_DATE,
          SEISMIC_LINE.INSERT_USER INSERT_USER,
          SEISMIC_LINE.UPDATE_DATE UPDATE_DATE,
          SEISMIC_LINE.UPDATE_USER UPDATE_USER,
          SEISMIC_LINE.GUID GUID,
          
SEISMIC_LINE.NAME NAME,
          SURVEY_3D.NAME SURVEY_NAME,
          APPLICATION_PROJECT.NAME PROJECT_NAME,
          PROJECT_DATASTORE.NAME DATASTORE_NAME,
          SEISMIC_LINE.ORIGINAL_SOURCE ORIGINAL_SOURCE,
          SEISMIC_LINE.PRODUCED_BY PRODUCED_BY,
          SEISMIC_LINE.REMARKS REMARKS,
          SEISMIC_LINE.SOURCE SOURCE,
          SEISMIC_LINE.FIRST_SHOTPOINT FIRST_SHOTPOINT,
          SEISMIC_LINE.FOREIGN_REP_OBJECT_ID FOREIGN_REP_OBJECT_ID,
          SEISMIC_LINE.FOREIGN_REPOSITORY_SYSTEM FOREIGN_REPOSITORY_SYSTEM,
          SEISMIC_LINE.LAST_SHOTPOINT LAST_SHOTPOINT,
          SEISMIC_LINE.LINE_GEOMETRY_ID LINE_GEOMETRY_ID,
          SEISMIC_LINE.LINE_RANK LINE_RANK,
          SEISMIC_LINE.NOMINAL_LINE_LENGTH NOMINAL_LINE_LENGTH,
          SEISMIC_LINE.NOMINAL_SHOT_INTERVAL NOMINAL_SHOT_INTERVAL,
          SEISMIC_LINE.CALCULATED_LINE_LENGTH CALCULATED_LINE_LENGTH,
          SEISMIC_LINE.CALCULATED_SHOT_INTERVAL CALCULATED_SHOT_INTERVAL,
          
SEISMIC_LINE.SEISMIC_LINE_UNIQUE_LOCATOR
             SEISMIC_LINE_UNIQUE_LOCATOR,
          SEISMIC_LINE.SHOT_DIVISOR SHOT_DIVISOR,
          SEISMIC_LINE.SHOT_INCREMENT SHOT_INCREMENT,
          ACQUISITION_3D.VESSEL_NAME VESSEL_NAME,
          SEISMIC_LINE.SOURCE_LINE_IDENTIFIER SOURCE_LINE_IDENTIFIER,
          SURVEY_3D.ID SURVEY_3D_ID,
          SAIL_LINE.ID SAIL_LINE_ID,
          SEISMIC_LINE.SOURCE_DATASET_ID SOURCE_DATASET_ID,
          LINE.SHAPE SHAPE
     FROM PROJECT_DATASTORE,
          APPLICATION_PROJECT,
          SURVEY_3D,
          SAIL_LINE,
          ACQUISITION_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 = SAIL_LINE.SURVEY_3D_ID
          AND SAIL_LINE.ID = ACQUISITION_3D.SAIL_LINE_ID
          AND ACQUISITION_3D.ID = SEISMIC_LINE.ACQUISITION_3D_ID
          AND 
SEISMIC_LINE.LINE_GEOMETRY_ID = LINE.ID(+)