Seismic_Dataset_2D_N

CREATE OR REPLACE FORCE VIEW Seismic_Dataset_2D_N(ID, SEISMIC_LINE_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) AS select SEISMIC_DATASET_2D.ID,
       SEISMIC_LINE.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,
       SEISMIC_LINE.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
from PROJECT_DATASTORE, APPLICATION_PROJECT, SURVEY_2D, SEISMIC_LINE, 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 = SEISMIC_DATASET_2D.SEISMIC_LINE_ID