| Name | Seismic_Line_N_Shape |
|---|---|
| Entity Type | ObjectView |
| Description | Seismic_Line_N_Shape dov first time creation using seabed extesibility |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | NAME , DATASTORE_NAME , PROJECT_NAME , SURVEY_NAME |
| Generalizations | |
| Specializations |
CREATE OR REPLACE FORCE VIEW Seismic_Line_N_Shape(SHOT_INCREMENT, ID, SURVEY_2D_ID, APPLICATION_PROJECT_ID, PROJECT_DATASTORE_ID, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, GUID, NAME, SURVEY_NAME, PROJECT_NAME, SHOT_DIVISOR, DATASTORE_NAME, ORIGINAL_SOURCE, PRODUCED_BY, REMARKS, SOURCE, CDP_INCREMENT, FIRST_CDP, FIRST_SHOTPOINT, FOREIGN_REP_OBJECT_ID, FOREIGN_REPOSITORY_SYSTEM, LAST_CDP, LAST_SHOTPOINT, LINE_GEOMETRY_ID, LINE_RANK, NOMINAL_LENGTH, NOMINAL_SHOT_INTERVAL, CALCULATED_LENGTH, CALCULATED_SHOT_INTERVAL, SEISMIC_LINE_TYPE, SEISMIC_LINE_UNIQUE_LOCATOR, SHAPE) AS SELECT SEISMIC_LINE.SHOT_INCREMENT,
SEISMIC_LINE.ID,
SURVEY_2D.ID,
APPLICATION_PROJECT.ID,
PROJECT_DATASTORE.ID,
SEISMIC_LINE.INSERT_DATE,
SEISMIC_LINE.INSERT_USER,
SEISMIC_LINE.UPDATE_DATE,
SEISMIC_LINE.UPDATE_USER,
SEISMIC_LINE.GUID,
SEISMIC_LINE.NAME,
SURVEY_2D.NAME,
APPLICATION_PROJECT.NAME,
SEISMIC_LINE.SHOT_DIVISOR,
PROJECT_DATASTORE.NAME,
SEISMIC_LINE.ORIGINAL_SOURCE,
SEISMIC_LINE.PRODUCED_BY,
SEISMIC_LINE.REMARKS,
SEISMIC_LINE.SOURCE,
SEISMIC_LINE.CDP_INCREMENT,
SEISMIC_LINE.FIRST_CDP,
SEISMIC_LINE.FIRST_SHOTPOINT,
SEISMIC_LINE.FOREIGN_REP_OBJECT_ID,
SEISMIC_LINE.FOREIGN_REPOSITORY_SYSTEM,
SEISMIC_LINE.LAST_CDP,
SEISMIC_LINE.LAST_SHOTPOINT,
SEISMIC_LINE.LINE_GEOMETRY_ID,
SEISMIC_LINE.LINE_RANK,
SEISMIC_LINE.NOMINAL_LINE_LENGTH,
SEISMIC_LINE.NOMINAL_SHOT_INTERVAL,
SEISMIC_LINE.CALCULATED_LINE_LENGTH,
SEISMIC_LINE.CALCULATED_SHOT_INTERVAL,
SEISMIC_LINE.SEISMIC_LINE_TYPE,
SEISMIC_LINE.SEISMIC_LINE_UNIQUE_LOCATOR,
LINE.SHAPE
FROM PROJECT_DATASTORE,
APPLICATION_PROJECT,
SURVEY_2D,
SEISMIC_LINE,
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.LINE_GEOMETRY_ID = LINE.ID(+)
|