| Name | SAIL_LINE_3D_N |
|---|---|
| Entity Type | ObjectView |
| Description | Field Nav DOV - SAIL_LINE_3D_N |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| APPLICATION_PROJECT_ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| DATASTORE_NAME | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| DATE_OF_SURVEY | DATE | NA |
_ | No |
DATE |
| EXISTENCE_KIND | STRING64 | NA |
_ | Yes |
VARCHAR2(64) |
| FIRST_SHOTPOINT | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| INSERT_DATE | DATE | NA |
_ | No |
DATE |
| INSERT_USER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| Id | ID | No_Unit |
Unique identifier | Yes |
NUMBER(38) |
| LAST_SHOTPOINT | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| NAME | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| ORIGINAL_SOURCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| PRODUCED_BY | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| PROJECT_DATASTORE_ID | NUMBER | NA |
_ | No |
NUMBER |
| PROJECT_NAME | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| REMARKS | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| SEISMIC_DATASET_ID | NUMBER | NA |
_ | No |
NUMBER |
| SEISMIC_TECHNOLOGY | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| SOURCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| SURVEY_3D_ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| SURVEY_NAME | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| TAPE_VERSION | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| UPDATE_DATE | DATE | NA |
_ | No |
DATE |
| UPDATE_USER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| VERSION | STRING255 | NA |
_ | Yes |
VARCHAR2(255) |
CREATE OR REPLACE FORCE VIEW Sail_Line_3D_N(ID, APPLICATION_PROJECT_ID, PROJECT_DATASTORE_ID, NAME, SURVEY_NAME, PROJECT_NAME, DATASTORE_NAME, INSERT_DATE, DATE_OF_SURVEY, ORIGINAL_SOURCE, INSERT_USER, SEISMIC_TECHNOLOGY, EXISTENCE_KIND, PRODUCED_BY, TAPE_VERSION, REMARKS, VERSION, SOURCE, SURVEY_3D_ID, UPDATE_DATE, UPDATE_USER, SEISMIC_DATASET_ID, FIRST_SHOTPOINT, LAST_SHOTPOINT) AS SELECT SAIL_LINE.ID ID,
SURVEY_3D.APPLICATION_PROJECT_ID APPLICATION_PROJECT_ID,
APPLICATION_PROJECT.PROJECT_DATASTORE_ID PROJECT_DATASTORE_ID,
SAIL_LINE.NAME NAME,
SURVEY_3D.NAME SURVEY_NAME,
APPLICATION_PROJECT.NAME PROJECT_NAME,
PROJECT_DATASTORE.NAME DATASTORE_NAME,
SAIL_LINE.INSERT_DATE INSERT_DATE,
SAIL_LINE.DATE_OF_SURVEY DATE_OF_SURVEY,
SAIL_LINE.ORIGINAL_SOURCE ORIGINAL_SOURCE,
SAIL_LINE.INSERT_USER INSERT_USER,
SAIL_LINE.SEISMIC_TECHNOLOGY SEISMIC_TECHNOLOGY,
SAIL_LINE.EXISTENCE_KIND EXISTENCE_KIND,
SAIL_LINE.PRODUCED_BY PRODUCED_BY,
SAIL_LINE.TAPE_VERSION TAPE_VERSION,
SAIL_LINE.REMARKS REMARKS,
SAIL_LINE.VERSION VERSION,
SAIL_LINE.SOURCE SOURCE,
SAIL_LINE.SURVEY_3D_ID SURVEY_3D_ID,
SAIL_LINE.UPDATE_DATE UPDATE_DATE,
SAIL_LINE.UPDATE_USER UPDATE_USER,
SEISMIC_FILE.SEISMIC_DATASET_ID SEISMIC_DATASET_ID,
SEISMIC_FILE.FIRST_SHOTPOINT FIRST_SHOTPOINT,
SEISMIC_FILE.LAST_SHOTPOINT LAST_SHOTPOINT
FROM PROJECT_DATASTORE,
APPLICATION_PROJECT,
SURVEY_3D,
SAIL_LINE,
ACQUISITION_3D,
SEISMIC_LINE,
SEISMIC_FILE
WHERE APPLICATION_PROJECT.PROJECT_DATASTORE_ID = PROJECT_DATASTORE.ID
AND SURVEY_3D.APPLICATION_PROJECT_ID = APPLICATION_PROJECT.ID
AND SAIL_LINE.SURVEY_3D_ID = SURVEY_3D.ID
AND ACQUISITION_3D.SAIL_LINE_ID = SAIL_LINE.ID
AND
SEISMIC_LINE.ACQUISITION_3D_ID = ACQUISITION_3D.ID
AND SEISMIC_FILE.SEISMIC_DATASET_ID =
SEISMIC_LINE.SOURCE_DATASET_ID
AND SEISMIC_FILE.NAME = SAIL_LINE.NAME
AND SEISMIC_FILE.SEISMIC_FORMAT NOT IN ('SPS')
|