Seismic_File

CREATE OR REPLACE FORCE VIEW Seismic_File(ID, SEISMIC_DATASET_ID, DATASET_NAME, DATASET_VERSION, SEISMIC_DATA_TYPE, SEISMIC_DATA_SUBTYPE, SEISMIC_FORMAT, PROCESSING_STAGE, SAMPLE_INTERVAL, DOMAIN_UNIT, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, GUID, NAME, ORIGINAL_SOURCE, PRODUCED_BY, REMARKS, SOURCE, ACQUISITION_2D_ID, ACQUISITION_3D_ID, AUTHOR, BARCODE, BULK_ARRAY_ID, FILE_TYPE, FIRST_CDP, FIRST_FIELD_FILE, FIRST_I_LINE, FIRST_J_LINE, FIRST_SHOTPOINT, FOREIGN_REP_OBJECT_ID, FOREIGN_REPOSITORY_SYSTEM, FULL_PATH_FILENAME, INVENTORY_ITEM_RANK, INVENTORY_TYPE, LAST_CDP, LAST_FIELD_FILE, LAST_I_LINE, LAST_J_LINE, LAST_SHOTPOINT, MMS_TAPE, MEDIA_TYPE, ONLINE_FLAG, TAPE_CREATION_DATE, TRACE_COUNT) AS SELECT
   GI.ID,
   DIX.SEISMIC_DATASET_ID,
   D.NAME AS DATASET_NAME,
   D.DATASET_VERSION,
   D.SEISMIC_DATA_TYPE,
   D.SEISMIC_DATA_SUBTYPE,
   D.SEISMIC_FORMAT,
   D.PROCESSING_STAGE,
   D.SAMPLE_INTERVAL,
   D.DOMAIN_UNIT,
   GI.INSERT_DATE,
   GI.INSERT_USER,
   
GI.UPDATE_DATE,
   GI.UPDATE_USER,
   GI.GUID,
   GI.NAME,
   GI.ORIGINAL_SOURCE,
   GI.PRODUCED_BY,
   GI.REMARKS,
   GI.SOURCE,
   GI.ACQUISITION_2D_ID,
   GI.ACQUISITION_3D_ID,
   GI.AUTHOR,
   GI.BARCODE,
   GI.BULK_ARRAY_ID,
   GI.FILE_TYPE,
   GI.FIRST_CDP,
   GI.FIRST_FIELD_FILE,
   GI.FIRST_I_LINE,
   GI.FIRST_J_LINE,
   GI.FIRST_SHOTPOINT,
   GI.FOREIGN_REP_OBJECT_ID,
   GI.FOREIGN_REPOSITORY_SYSTEM,
   GI.FULL_PATH_FILENAME,
   GI.INVENTORY_ITEM_RANK,
   GI.INVENTORY_TYPE,
   GI.LAST_CDP,
   GI.LAST_FIELD_FILE,
   GI.LAST_I_LINE,
   GI.LAST_J_LINE,
   GI.LAST_SHOTPOINT,
   GI.MMS_TAPE,
   GI.MEDIA_TYPE,
   GI.ONLINE_FLAG,
   GI.TAPE_CREATION_DATE,
   GI.TRACE_COUNT
FROM
   GEOPHYSICAL_INVENTORY GI,
   DATASET_INVENTORY_X DIX,
   SEISMIC_DATASET D
WHERE
   GI.ID = DIX.GEOPHYSICAL_INVENTORY_ID AND
   DIX.SEISMIC_DATASET_ID = D.ID AND
   GI.INVENTORY_TYPE = 'File'