SAIL_LINE_N_SHAPE_3D


[Columns] [Composed Of] [Referenced By] [Refers To]

General Information

[Next]
Name SAIL_LINE_N_SHAPE_3D
Entity Type ObjectView
Description Field Nav DOV - SAIL_LINE_N_SHAPE_3D
Submodel Data_Object
Entity Scope Project
Primary Key Id
Natural Key
Generalizations
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
APPLICATION_PROJECT_ID NUMBER2 NA
_ No
NUMBER(2)
CALCULATED_LINE_LENGTH NUMBER NA
_ No
NUMBER
CALCULATED_SHOT_INTERVAL NUMBER NA
_ No
NUMBER
DATASTORE_NAME STRING255 NA
_ No
VARCHAR2(255)
FIRST_SHOTPOINT NUMBER2 NA
_ No
NUMBER(2)
FOREIGN_REPOSITORY_SYSTEM STRING64 NA
_ No
VARCHAR2(64)
FOREIGN_REP_OBJECT_ID STRING255 NA
_ No
VARCHAR2(255)
GUID STRING128 NA
_ No
VARCHAR2(128)
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)
LINE_GEOMETRY_ID ID NA
_ No
NUMBER(38)
LINE_RANK NUMBER2 NA
_ No
NUMBER(2)
NAME STRING255 NA
_ No
VARCHAR2(255)
NOMINAL_LINE_LENGTH NUMBER2 NA
_ No
NUMBER(2)
NOMINAL_SHOT_INTERVAL NUMBER2 NA
_ No
NUMBER(2)
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)
SAIL_LINE_ID NUMBER2 NA
_ No
NUMBER(2)
SEISMIC_LINE_UNIQUE_LOCATOR STRING2000 NA
_ No
VARCHAR2(2000)
SHAPE GEOMETRY NA
_ No
ST_GEOMETRY
SHOT_DIVISOR NUMBER2 NA
_ No
NUMBER(2)
SHOT_INCREMENT NUMBER2 NA
_ No
NUMBER(2)
SOURCE STRING64 NA
_ No
VARCHAR2(64)
SOURCE_DATASET_ID NUMBER NA
_ No
NUMBER
SOURCE_LINE_IDENTIFIER double NA
_ No
NUMBER
SURVEY_3D_ID NUMBER2 NA
_ No
NUMBER(2)
SURVEY_NAME STRING255 NA
_ No
VARCHAR2(255)
UPDATE_DATE DATE NA
_ No
DATE
UPDATE_USER STRING64 NA
_ No
VARCHAR2(64)
VESSEL_NAME STRING255 NA
_ No
VARCHAR2(255)


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW Sail_Line_N_Shape_3D(ID, APPLICATION_PROJECT_ID, PROJECT_DATASTORE_ID, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, GUID, NAME, SURVEY_NAME, PROJECT_NAME, DATASTORE_NAME, ORIGINAL_SOURCE, PRODUCED_BY, REMARKS, SOURCE, FIRST_SHOTPOINT, FOREIGN_REP_OBJECT_ID, FOREIGN_REPOSITORY_SYSTEM, LAST_SHOTPOINT, LINE_GEOMETRY_ID, LINE_RANK, NOMINAL_LINE_LENGTH, NOMINAL_SHOT_INTERVAL, CALCULATED_LINE_LENGTH, CALCULATED_SHOT_INTERVAL, SEISMIC_LINE_UNIQUE_LOCATOR, SHOT_DIVISOR, SHOT_INCREMENT, VESSEL_NAME, SOURCE_LINE_IDENTIFIER, SURVEY_3D_ID, SAIL_LINE_ID, SOURCE_DATASET_ID, SHAPE) AS SELECT SEISMIC_LINE.ID ID,
          APPLICATION_PROJECT.ID APPLICATION_PROJECT_ID,
          PROJECT_DATASTORE.ID PROJECT_DATASTORE_ID,
          SEISMIC_LINE.INSERT_DATE INSERT_DATE,
          SEISMIC_LINE.INSERT_USER INSERT_USER,
          SEISMIC_LINE.UPDATE_DATE UPDATE_DATE,
          SEISMIC_LINE.UPDATE_USER UPDATE_USER,
          SEISMIC_LINE.GUID GUID,
          
SEISMIC_LINE.NAME NAME,
          SURVEY_3D.NAME SURVEY_NAME,
          APPLICATION_PROJECT.NAME PROJECT_NAME,
          PROJECT_DATASTORE.NAME DATASTORE_NAME,
          SEISMIC_LINE.ORIGINAL_SOURCE ORIGINAL_SOURCE,
          SEISMIC_LINE.PRODUCED_BY PRODUCED_BY,
          SEISMIC_LINE.REMARKS REMARKS,
          SEISMIC_LINE.SOURCE SOURCE,
          SEISMIC_LINE.FIRST_SHOTPOINT FIRST_SHOTPOINT,
          SEISMIC_LINE.FOREIGN_REP_OBJECT_ID FOREIGN_REP_OBJECT_ID,
          SEISMIC_LINE.FOREIGN_REPOSITORY_SYSTEM FOREIGN_REPOSITORY_SYSTEM,
          SEISMIC_LINE.LAST_SHOTPOINT LAST_SHOTPOINT,
          SEISMIC_LINE.LINE_GEOMETRY_ID LINE_GEOMETRY_ID,
          SEISMIC_LINE.LINE_RANK LINE_RANK,
          SEISMIC_LINE.NOMINAL_LINE_LENGTH NOMINAL_LINE_LENGTH,
          SEISMIC_LINE.NOMINAL_SHOT_INTERVAL NOMINAL_SHOT_INTERVAL,
          SEISMIC_LINE.CALCULATED_LINE_LENGTH CALCULATED_LINE_LENGTH,
          SEISMIC_LINE.CALCULATED_SHOT_INTERVAL CALCULATED_SHOT_INTERVAL,
          
SEISMIC_LINE.SEISMIC_LINE_UNIQUE_LOCATOR
             SEISMIC_LINE_UNIQUE_LOCATOR,
          SEISMIC_LINE.SHOT_DIVISOR SHOT_DIVISOR,
          SEISMIC_LINE.SHOT_INCREMENT SHOT_INCREMENT,
          ACQUISITION_3D.VESSEL_NAME VESSEL_NAME,
          SEISMIC_LINE.SOURCE_LINE_IDENTIFIER SOURCE_LINE_IDENTIFIER,
          SURVEY_3D.ID SURVEY_3D_ID,
          SAIL_LINE.ID SAIL_LINE_ID,
          SEISMIC_LINE.SOURCE_DATASET_ID SOURCE_DATASET_ID,
          LINE.SHAPE SHAPE
     FROM PROJECT_DATASTORE,
          APPLICATION_PROJECT,
          SURVEY_3D,
          SAIL_LINE,
          ACQUISITION_3D,
          SEISMIC_LINE,
          LINE
    WHERE     PROJECT_DATASTORE.ID = APPLICATION_PROJECT.PROJECT_DATASTORE_ID
          AND APPLICATION_PROJECT.ID = SURVEY_3D.APPLICATION_PROJECT_ID
          AND SURVEY_3D.ID = SAIL_LINE.SURVEY_3D_ID
          AND SAIL_LINE.ID = ACQUISITION_3D.SAIL_LINE_ID
          AND ACQUISITION_3D.ID = SEISMIC_LINE.ACQUISITION_3D_ID
          AND 
SEISMIC_LINE.LINE_GEOMETRY_ID = LINE.ID(+)
   


[Seabed Objects] [Entities in Schema Seabed] [Index]

Copyright © 2018 Schlumberger. All rights reserved.