| Name | EXP_GAE_PROS_TUB_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Custom Exporters - EXP_GAE_PROS_TUB_DOV |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| END_DATE | DATE | NA |
_ | No |
DATE |
| END_DATE1 | DATE | NA |
_ | No |
DATE |
| EXP_GAE_PROSPER_PSFO_DOV_ID | NUMBER | NA |
_ | No |
NUMBER |
| Id | ID | No_Unit |
Unique identifier | Yes |
NUMBER(38) |
| MIN_ID | NUMBER | NA |
_ | No |
NUMBER |
| START_DATE | DATE | NA |
_ | No |
DATE |
| START_DATE1 | DATE | NA |
_ | No |
DATE |
| STRING_TYPE | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| TOP | NUMBER | NA |
_ | No |
NUMBER |
| TVDBRT | NUMBER | NA |
_ | No |
NUMBER |
| TVDSS | 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_TUB_DOV(ID, UWI, WELL_ID, STRING_TYPE, START_DATE, END_DATE, START_DATE1, END_DATE1, TOP, TVDBRT, TVDSS, MIN_ID, EXP_GAE_PROSPER_PSFO_DOV_ID, UBHI) AS SELECT ID,
UWI,
WELL_ID,
STRING_TYPE,
START_DATE,
END_DATE,
START_DATE1,
END_DATE1,
TOP,
TVDBRT,
ROUND (CALC_WELL_POINT.GetTvdSSFromMd (ubhi, top), 9) TVDSS,
MIN_ID,
EXP_GAE_PROSPER_PSFO_DOV_ID,
UBHI
FROM (SELECT DISTINCT TO_NUMBER (t.id || fs.id) Id,
w.uwi uwi,
w.id Well_id,
b.ubhi || '/' || ts1.string_type STRING_TYPE,
fc1.start_date,
fc1.end_date,
fs.start_date START_DATE1,
fs.end_date END_DATE1,
ROUND (
(fc1.Part_Facility_Top_Offset + ts2.Current_Top_MD),
9)
Top,
ROUND (
CALC_WELL_POINT.
GetTvdBRTFromMd (
b1.ubhi,
'RT',
(fc1.Part_Facility_Top_Offset + ts2.Current_Top_MD)),
9)
TVDBRT,
ROUND (
(NVL (rtc.NOM_INSIDE_DIAMETER, rtc.Cat_Inside_Diameter)
),
9)
Min_ID,
p.id EXP_GAE_PROSPER_PSFO_DOV_ID,
b1.ubhi
FROM tubing_string ts1,
tubing_string ts2,
facility_composition fc,
facility_composition fc1,
R_Tubing_Cat rtc,
tubing t,
borehole b,
Well w,
Facility_Status fs,
borehole b1,
well_completion wc,
tubing_string ts3,
EXP_GAE_PROS_PSFO_DOV p
WHERE ts1.borehole_id = b.id
AND b.Well_Id = w.Id
AND b.UBHI = w.UWI
AND ts1.id = fc.whole_facility_id
AND ts2.id = fc.part_facility_id
AND fc1.whole_facility_id = ts2.id
AND t.id = fc1.part_facility_id
AND t.Tubing_Spec = rtc.Ref_Id(+)
AND p.well_id = w.id
AND p.tubing_string_id = ts1.id
AND p.borehole_id = b.id
AND fs.facility_id = wc.id
AND wc.Borehole_Id = b1.id
AND wc.tubing_string_id = ts3.id
AND ts3.id = ts1.id
AND b1.well_id = w.id
UNION
SELECT DISTINCT TO_NUMBER (gt.id || fs.id) ID,
w.uwi uwi,
w.id Well_id,
b.ubhi || '/' || ts1.string_type STRING_TYPE,
fc1.start_date,
fc1.end_date,
fs.start_date START_DATE1,
fs.end_date END_DATE1,
ROUND (
(fc1.Part_Facility_Top_Offset + ts2.Current_Top_MD),
9)
Top,
ROUND (
CALC_WELL_POINT.
GetTvdBRTFromMd (
b1.ubhi,
'RT',
(fc1.Part_Facility_Top_Offset + ts2.Current_Top_MD)),
9)
TVDBRT,
ROUND (
(NVL (rgt.NOM_INSIDE_DIAMETER, rgt.Cat_Inside_Diameter)
),
9)
Min_ID,
p.id EXP_GAE_PROSPER_PSFO_DOV_ID,
b1.ubhi
FROM tubing_string ts1,
tubing_string ts2,
facility_composition fc,
facility_composition fc1,
Generic_Tubular gt,
R_Generic_Tubular_Cat rgt,
borehole b,
Well w,
Facility_Status fs,
borehole b1,
well_completion wc,
tubing_string ts3,
EXP_GAE_PROS_PSFO_DOV p
WHERE ts1.borehole_id = b.id
AND b.Well_Id = w.Id
AND b.UBHI = w.UWI
AND ts1.id = fc.whole_facility_id
AND ts2.id = fc.part_facility_id
AND fc1.whole_facility_id = ts2.id
AND gt.id = fc1.part_facility_id
AND p.well_id = w.id
AND p.tubing_string_id = ts1.id
AND p.borehole_id = b.id
AND GT.GENERIC_TUBULAR_SPEC = rgt.Ref_Id(+)
AND fs.facility_id = wc.id
AND wc.Borehole_Id = b1.id
AND wc.tubing_string_id = ts3.id
AND ts3.id
= ts1.id
AND b1.well_id = w.id)
|