ALT_NAV_Dataset_2D_N

CREATE OR REPLACE FORCE VIEW ALT_NAV_Dataset_2D_N(ID, ALTERNATIVE_NAVIGATION_ID, SURVEY_2D_ID, APPLICATION_PROJECT_ID, PROJECT_DATASTORE_ID, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, GUID, NAME, LINE_NAME, SURVEY_NAME, PROJECT_NAME, DATASTORE_NAME, ORIGINAL_SOURCE, PRODUCED_BY, REMARKS, SOURCE, BINARY_HEADER_TEMPLATE_ID, COMPRESSION_FACTOR, DATASET_PROPERTY_NAME, DATASET_RANK, DATASET_UNIQUE_LOCATOR, DATASET_VERSION, DOMAIN_TYPE, DOMAIN_UNIT, EBCDIC_HEADER_TEMPLATE_ID, FIRST_SAMPLE_OFFSET, FOLD, FOREIGN_REP_OBJECT_ID, FOREIGN_REPOSITORY_SYSTEM, GENERATE_LIVE_TRACE_FLAG, LIVE_TRACE_SCAN_DATE, MAXIMUM_AMPLITUDE, MINIMUM_AMPLITUDE, NAV_IN_TRACE, NUMBER_OF_SAMPLES, PROCESSING_STAGE, SAMPLE_INTERVAL, SCAN_DATE, SEISMIC_DATA_TYPE, SEISMIC_DATA_SUBTYPE, SEISMIC_FORMAT, SEISMIC_REFERENCE_DATUM, SEISMIC_SAMPLE_FORMAT, SLICE_SAMPLE_INDEX, SORT_KEY1, SORT_KEY2, SUB_TYPE, TRACE_COUNT, TRACE_HEADER_TEMPLATE_ID, TRACES_PER_RECORD, POINT_TYPE) AS SELECT SEISMIC_DATASET_2D.ID,
          
ALTERNATIVE_NAVIGATION.ID,
          SURVEY_2D.ID,
          APPLICATION_PROJECT.ID,
          PROJECT_DATASTORE.ID,
          SEISMIC_DATASET_2D.INSERT_DATE,
          SEISMIC_DATASET_2D.INSERT_USER,
          SEISMIC_DATASET_2D.UPDATE_DATE,
          SEISMIC_DATASET_2D.UPDATE_USER,
          SEISMIC_DATASET_2D.GUID,
          SEISMIC_DATASET_2D.NAME,
          ALTERNATIVE_NAVIGATION.NAME,
          SURVEY_2D.NAME,
          APPLICATION_PROJECT.NAME,
          PROJECT_DATASTORE.NAME,
          SEISMIC_DATASET_2D.ORIGINAL_SOURCE,
          SEISMIC_DATASET_2D.PRODUCED_BY,
          SEISMIC_DATASET_2D.REMARKS,
          SEISMIC_DATASET_2D.SOURCE,
          SEISMIC_DATASET_2D.BINARY_HEADER_TEMPLATE_ID,
          SEISMIC_DATASET_2D.COMPRESSION_FACTOR,
          SEISMIC_DATASET_2D.DATASET_PROPERTY_NAME,
          SEISMIC_DATASET_2D.DATASET_RANK,
          SEISMIC_DATASET_2D.DATASET_UNIQUE_LOCATOR,
          SEISMIC_DATASET_2D.DATASET_VERSION,
          SEISMIC_DATASET_2D.DOMAIN_TYPE,
      
    SEISMIC_DATASET_2D.DOMAIN_UNIT,
          SEISMIC_DATASET_2D.EBCDIC_HEADER_TEMPLATE_ID,
          SEISMIC_DATASET_2D.FIRST_SAMPLE_OFFSET,
          SEISMIC_DATASET_2D.FOLD,
          SEISMIC_DATASET_2D.FOREIGN_REP_OBJECT_ID,
          SEISMIC_DATASET_2D.FOREIGN_REPOSITORY_SYSTEM,
          SEISMIC_DATASET_2D.GENERATE_LIVE_TRACE_FLAG,
          SEISMIC_DATASET_2D.LIVE_TRACE_SCAN_DATE,
          SEISMIC_DATASET_2D.MAXIMUM_AMPLITUDE,
          SEISMIC_DATASET_2D.MINIMUM_AMPLITUDE,
          SEISMIC_DATASET_2D.NAV_IN_TRACE,
          SEISMIC_DATASET_2D.NUMBER_OF_SAMPLES,
          SEISMIC_DATASET_2D.PROCESSING_STAGE,
          SEISMIC_DATASET_2D.SAMPLE_INTERVAL,
          SEISMIC_DATASET_2D.SCAN_DATE,
          SEISMIC_DATASET_2D.SEISMIC_DATA_TYPE,
		  SEISMIC_DATASET_2D.SEISMIC_DATA_SUBTYPE,
          SEISMIC_DATASET_2D.SEISMIC_FORMAT,
          SEISMIC_DATASET_2D.SEISMIC_REFERENCE_DATUM,
          SEISMIC_DATASET_2D.SEISMIC_SAMPLE_FORMAT,
          
SEISMIC_DATASET_2D.SLICE_SAMPLE_INDEX,
          SEISMIC_DATASET_2D.SORT_KEY1,
          SEISMIC_DATASET_2D.SORT_KEY2,
          SEISMIC_DATASET_2D.SUB_TYPE,
          SEISMIC_DATASET_2D.TRACE_COUNT,
          SEISMIC_DATASET_2D.TRACE_HEADER_TEMPLATE_ID,
          SEISMIC_DATASET_2D.TRACES_PER_RECORD,
          ALTERNATIVE_NAVIGATION.POINT_TYPE
     FROM PROJECT_DATASTORE,
          APPLICATION_PROJECT,
          SURVEY_2D,
          SEISMIC_LINE,
          ALTERNATIVE_NAVIGATION,
          SEISMIC_DATASET_2D
    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
          AND SEISMIC_LINE.ID = ALTERNATIVE_NAVIGATION.SEISMIC_LINE_ID
          AND ALTERNATIVE_NAVIGATION.ID =
                 SEISMIC_DATASET_2D.ALTERNATIVE_NAVIGATION_ID