| Name | ALT_NAV_Line_N_Shape |
|---|---|
| Entity Type | ObjectView |
| Description | PSS 2016.1 ALT_NAV_Line_N_Shape DOV |
| 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 | ID | NA |
_ | Yes |
NUMBER(38) |
| Datastore_Name | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| Existence_Kind | STRING64 | NA |
_ | Yes |
VARCHAR2(64) |
| First_Point | double | NA |
_ | No |
NUMBER |
| GUID | STRING128 | NA |
_ | No |
VARCHAR2(128) |
| Id | ID | NA |
_ | Yes |
NUMBER(38) |
| Insert_Date | DATE | NA |
_ | No |
DATE |
| Insert_User | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| Last_Point | double | NA |
_ | No |
NUMBER |
| Line_Geometry_Id | ID | NA |
_ | No |
NUMBER(38) |
| Name | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| Original_Source | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| Point_Increment | double | No_Unit |
Point increment associated with this line. | No |
NUMBER |
| Point_Type | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| Produced_By | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| Project_Datastore_Id | ID | NA |
_ | Yes |
NUMBER(38) |
| Project_Name | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| Remarks | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| Seismic_Line_Id | ID | NA |
_ | Yes |
NUMBER(38) |
| Seismic_Line_Unique_Locator | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| Shape | GEOMETRY | NA |
_ | No |
ST_GEOMETRY |
| Source | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| Survey_2D_Id | ID | NA |
_ | Yes |
NUMBER(38) |
| Survey_Name | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| Version | STRING255 | NA |
_ | Yes |
VARCHAR2(255) |
CREATE OR REPLACE FORCE VIEW ALT_NAV_Line_N_Shape(ID, SEISMIC_LINE_ID, SURVEY_2D_ID, APPLICATION_PROJECT_ID, PROJECT_DATASTORE_ID, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, PRODUCED_BY, GUID, EXISTENCE_KIND, VERSION, NAME, FIRST_POINT, LAST_POINT, SURVEY_NAME, PROJECT_NAME, DATASTORE_NAME, ORIGINAL_SOURCE, REMARKS, SOURCE, POINT_TYPE, POINT_INCREMENT, LINE_RANK, LINE_GEOMETRY_ID, SEISMIC_LINE_UNIQUE_LOCATOR, SHAPE) AS SELECT ALTERNATIVE_NAVIGATION.ID,
ALTERNATIVE_NAVIGATION.SEISMIC_LINE_ID,
SURVEY_2D.ID,
APPLICATION_PROJECT.ID,
PROJECT_DATASTORE.ID,
ALTERNATIVE_NAVIGATION.INSERT_DATE,
ALTERNATIVE_NAVIGATION.INSERT_USER,
ALTERNATIVE_NAVIGATION.UPDATE_DATE,
ALTERNATIVE_NAVIGATION.UPDATE_USER,
ALTERNATIVE_NAVIGATION.PRODUCED_BY,
ALTERNATIVE_NAVIGATION.GUID,
ALTERNATIVE_NAVIGATION.EXISTENCE_KIND,
ALTERNATIVE_NAVIGATION.VERSION,
ALTERNATIVE_NAVIGATION.NAME,
ALTERNATIVE_NAVIGATION.FIRST_POINT,
ALTERNATIVE_NAVIGATION.LAST_POINT,
SURVEY_2D.NAME,
APPLICATION_PROJECT.NAME,
PROJECT_DATASTORE.NAME,
ALTERNATIVE_NAVIGATION.ORIGINAL_SOURCE,
ALTERNATIVE_NAVIGATION.REMARKS,
ALTERNATIVE_NAVIGATION.SOURCE,
ALTERNATIVE_NAVIGATION.POINT_TYPE,
ALTERNATIVE_NAVIGATION.POINT_INCREMENT,
ALTERNATIVE_NAVIGATION.LINE_RANK,
ALTERNATIVE_NAVIGATION.LINE_GEOMETRY_ID,
SEISMIC_LINE.SEISMIC_LINE_UNIQUE_LOCATOR,
LINE.SHAPE
FROM PROJECT_DATASTORE,
APPLICATION_PROJECT,
SURVEY_2D,
SEISMIC_LINE,
ALTERNATIVE_NAVIGATION,
LINE
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.LINE_GEOMETRY_ID = LINE.ID
|