| Name | SPS_LINE_3D |
|---|---|
| Entity Type | ObjectView |
| Description | Field Nav DOV - SPS_LINE_3D |
| 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 SPS_Line_3D(ID, NAME, SURVEY_NAME, APPLICATION_PROJECT_ID, PROJECT_NAME, PROJECT_DATASTORE_ID, DATASTORE_NAME, FIRST_SHOTPOINT, LAST_SHOTPOINT, DATE_OF_SURVEY, ORIGINAL_SOURCE, EXISTENCE_KIND, PRODUCED_BY, TAPE_VERSION, REMARKS, VERSION, SOURCE, INSERT_DATE, INSERT_USER, SEISMIC_TECHNOLOGY, UPDATE_DATE, UPDATE_USER, SURVEY_3D_ID, SEISMIC_DATASET_ID) AS SELECT ID ID,
NAME NAME,
SURVEY_NAME SURVEY_NAME,
APPLICATION_PROJECT_ID APPLICATION_PROJECT_ID,
PROJECT_NAME PROJECT_NAME,
PROJECT_DATASTORE_ID PROJECT_DATASTORE_ID,
DATASTORE_NAME DATASTORE_NAME,
FIRST_SHOTPOINT FIRST_SHOTPOINT,
LAST_SHOTPOINT LAST_SHOTPOINT,
DATE_OF_SURVEY DATE_OF_SURVEY,
ORIGINAL_SOURCE ORIGINAL_SOURCE,
EXISTENCE_KIND EXISTENCE_KIND,
PRODUCED_BY PRODUCED_BY,
TAPE_VERSION TAPE_VERSION,
REMARKS REMARKS,
VERSION VERSION,
SOURCE
SOURCE,
INSERT_DATE INSERT_DATE,
INSERT_USER INSERT_USER,
SEISMIC_TECHNOLOGY SEISMIC_TECHNOLOGY,
UPDATE_DATE UPDATE_DATE,
UPDATE_USER UPDATE_USER,
SURVEY_3D_ID SURVEY_3D_ID,
SEISMIC_DATASET_ID SEISMIC_DATASET_ID
FROM (SELECT ID,
NAME,
SURVEY_NAME,
APPLICATION_PROJECT_ID,
PROJECT_NAME,
PROJECT_DATASTORE_ID,
DATASTORE_NAME,
CASE WHEN MINFS <= MINLS THEN MINFS ELSE MAXFS END
FIRST_SHOTPOINT,
CASE WHEN MINFS <= MINLS THEN MAXLS ELSE MINLS END
LAST_SHOTPOINT,
DATE_OF_SURVEY,
ORIGINAL_SOURCE,
EXISTENCE_KIND,
PRODUCED_BY,
TAPE_VERSION,
REMARKS,
VERSION,
SOURCE,
INSERT_DATE,
INSERT_USER,
SEISMIC_TECHNOLOGY,
UPDATE_DATE,
UPDATE_USER,
SURVEY_3D_ID,
SEISMIC_DATASET_ID
FROM (SELECT DISTINCT
ID,
NAME,
SURVEY_NAME,
APPLICATION_PROJECT_ID,
PROJECT_NAME,
PROJECT_DATASTORE_ID,
DATASTORE_NAME,
MIN (FIRST_SHOTPOINT) OVER (PARTITION BY ID) MINFS,
MAX (FIRST_SHOTPOINT) OVER (PARTITION BY ID) MAXFS,
MIN (LAST_SHOTPOINT) OVER (PARTITION BY ID) MINLS,
MAX (LAST_SHOTPOINT) OVER (PARTITION BY ID) MAXLS,
DATE_OF_SURVEY,
ORIGINAL_SOURCE,
EXISTENCE_KIND,
PRODUCED_BY,
TAPE_VERSION,
REMARKS,
VERSION,
SOURCE,
INSERT_DATE,
INSERT_USER,
SEISMIC_TECHNOLOGY,
UPDATE_DATE,
UPDATE_USER,
SURVEY_3D_ID,
SEISMIC_DATASET_ID
FROM (SELECT SAL.ID ID,
SAL.NAME NAME,
S3.NAME SURVEY_NAME,
PRJ.ID APPLICATION_PROJECT_ID,
PRJ.NAME PROJECT_NAME,
DS.ID PROJECT_DATASTORE_ID,
DS.NAME DATASTORE_NAME,
SL.FIRST_SHOTPOINT FIRST_SHOTPOINT,
SL.LAST_SHOTPOINT LAST_SHOTPOINT,
SAL.DATE_OF_SURVEY DATE_OF_SURVEY,
SAL.ORIGINAL_SOURCE ORIGINAL_SOURCE,
SAL.EXISTENCE_KIND EXISTENCE_KIND,
SAL.PRODUCED_BY PRODUCED_BY,
SAL.TAPE_VERSION TAPE_VERSION,
SAL.REMARKS REMARKS,
SAL.VERSION VERSION,
SAL.SOURCE SOURCE,
SAL.INSERT_DATE INSERT_DATE,
SAL.INSERT_USER INSERT_USER,
SAL.SEISMIC_TECHNOLOGY SEISMIC_TECHNOLOGY,
SAL.UPDATE_DATE UPDATE_DATE,
SAL.UPDATE_USER UPDATE_USER,
SAL.SURVEY_3D_ID SURVEY_3D_ID,
SL.SOURCE_DATASET_ID SEISMIC_DATASET_ID
FROM SAIL_LINE SAL,
SURVEY_3D S3,
ACQUISITION_3D A3,
SEISMIC_LINE SL,
SEISMIC_DATASET SD,
APPLICATION_PROJECT PRJ,
PROJECT_DATASTORE DS
WHERE PRJ.PROJECT_DATASTORE_ID = DS.ID
AND S3.APPLICATION_PROJECT_ID = PRJ.ID
AND SAL.SURVEY_3D_ID = S3.ID
AND SL.ACQUISITION_3D_ID = A3.ID
AND A3.SAIL_LINE_ID = SAL.ID
AND SL.SOURCE_DATASET_ID = SD.ID
AND SD.SEISMIC_FORMAT = 'SPS')))
|