| Name | EXP_GAE_RAW_LAYER_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Custom Exporters - EXP_GAE_RAW_LAYER_DOV |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Id | ID | No_Unit |
Unique identifier | Yes |
NUMBER(38) |
| TESTED_LAYER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
CREATE OR REPLACE FORCE VIEW EXP_GAE_RAW_LAYER_DOV(ID, TESTED_LAYER) AS SELECT gafi.id, GL.STANDARD_LAYER_NAME
FROM well_test wt,
Generic_Act_Fac_Invl gafi,
Well_Completion wc1,
Well_Completion wc2,
Facility_Composition fc,
Facility_Composition fc1,
Well_Completion_Reservoir wcr,
Reservoir res,
Geologic_layer gl
WHERE gafi.activity_id = wt.id
AND wt.well_completion_id = wc1.id
AND fc.whole_facility_id = wc1.id
AND fc1.whole_facility_id = fc.part_facility_id
AND fc1.part_facility_id = wc2.id
AND wcr.well_completion_id = wc2.id
AND res.id = wcr.reservoir_id
AND res.geologic_layer_id = gl.id
Order by 2
|