| Name | EXP_GAE_PROS_PSFO_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Custom Exporters - EXP_GAE_PROS_PSFO_DOV |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| BOREHOLE_ID | NUMBER | NA |
_ | No |
NUMBER |
| Id | ID | No_Unit |
Unique identifier | Yes |
NUMBER(38) |
| STRING_TYPE | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| TODAY | STRING32 | NA |
_ | No |
VARCHAR2(32) |
| TUBING_STRING_ID | NUMBER | NA |
_ | No |
NUMBER |
| UBHI | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| UWI | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| WELL_ID | NUMBER | NA |
_ | No |
NUMBER |
CREATE OR REPLACE FORCE VIEW EXP_GAE_PROS_PSFO_DOV(ID, WELL_ID, UWI, BOREHOLE_ID, UBHI, TUBING_STRING_ID, STRING_TYPE, TODAY) AS SELECT t.id Id,
w.id Well_Id,
w.uwi UWI,
b.id Borehole_Id,
b.UBHI UBHI,
t.id Tubing_String_Id,
w.uwi || '/' || t.string_type STRING_TYPE,
TO_CHAR (SYSDATE, 'DD/MM/YYYY') Today
FROM well w,
borehole b,
Tubing_String t
WHERE b.well_id=w.id
AND t.borehole_id=b.id
AND t.string_type NOT IN ('TUBING','TS')
|