| Name | EXP_GAE_RAW_STAGE_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Custom Exporters - EXP_GAE_RAW_STAGE_DOV |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| DURATION | NUMBER | NA |
_ | No |
NUMBER |
| END_DATE | DATE | NA |
_ | No |
DATE |
| GENERIC_ACT_FAC_INVL_ID | NUMBER | NA |
_ | No |
NUMBER |
| Id | ID | No_Unit |
Unique identifier | Yes |
NUMBER(38) |
| START_DATE | DATE | NA |
_ | No |
DATE |
| WELL_TEST_ID | NUMBER | NA |
_ | No |
NUMBER |
| WELL_TEST_STAGE_TYPE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| WELL_TEST_TRACE_ID | NUMBER | NA |
_ | No |
NUMBER |
CREATE OR REPLACE FORCE VIEW EXP_GAE_RAW_STAGE_DOV(ID, WELL_TEST_STAGE_TYPE, START_DATE, END_DATE, DURATION, WELL_TEST_ID, WELL_TEST_TRACE_ID, GENERIC_ACT_FAC_INVL_ID) AS SELECT WTS.ID,
WTS.WELL_TEST_STAGE_TYPE,
WTS.START_DATE,
WTS.END_DATE,
WTS.DURATION Duration,
WTS.WELL_TEST_ID ,
WTT.ID Well_Test_Trace_Id,
WTT.UTILIZED_FACILITY_ID
FROM well_test_stage wts, well_test_trace wtt
WHERE WTT.WELL_TEST_STAGE_ID = WTS.ID
|