EXP_GAE_RAW_TRACE_COM_DOV

[Columns] [Composed Of] [Referenced By] [Refers To]

Name	EXP_GAE_RAW_TRACE_COM_DOV
Entity Type	ObjectView
Description	Custom Exporters - EXP_GAE_RAW_TRACE_COM_DOV
Submodel	Data_Object
Entity Scope	Project
Primary Key	Id
Natural Key
Generalizations
Specializations

Columns

[Previous] [Next] [Top]

Name	Value Domain	Property / Storage Unit	Description	Required / Default	Type
ANN_PRESS	NUMBER	NA	_	No	NUMBER
BHP	NUMBER	NA	_	No	NUMBER
DEPTH	NUMBER	NA	_	No	NUMBER
FLOW_RATE	NUMBER	NA	_	No	NUMBER
GRADIENT	NUMBER	NA	_	No	NUMBER
Id	ID	No_Unit	Unique identifier	Yes	NUMBER(38)
REMARKS	STRING2000	NA	_	No	VARCHAR2(2000)
START_DATE	DATE	NA	_	No	DATE
TIME_OFFSET	NUMBER	NA	_	No	NUMBER
WHP	NUMBER	NA	_	No	NUMBER
WHT	NUMBER	NA	_	No	NUMBER

View Definition

[Previous] [Top]


CREATE OR REPLACE FORCE VIEW EXP_GAE_RAW_TRACE_COM_DOV(ID, START_DATE, TIME_OFFSET, BHP, DEPTH, WHT, WHP, FLOW_RATE, ANN_PRESS, GRADIENT, REMARKS) AS SELECT wth_bhp.UTILIZED_FACILITY_ID ID,
         NVL (WTS.START_DATE, wth_bhp.START_DATE)
         + (wtd_bhp.Time_Offset /86400)
            Start_Date,
         wtd_bhp.TIME_OFFSET Time_Offset,
         wtd_bhp.PRESSURE BHP,
         wtd_bhp.MD DEPTH,
         (SELECT wtd_whp.Temperature
            FROM Well_Test_Trace wth_whp,
                 Well_Test_Trace_Data wtd_whp,
                 Generic_Act_Fac_Invl gafi,
                 Generic_Act_Fac_Invl gafi1,
                 Facility_Connection fc,
                 Activity_Entity_Invl aei
           WHERE     wth_whp.ID = wtd_whp.Well_Test_Trace_Id
                 AND wth_whp.Trace_Type = 'WHP'
                 AND wth_bhp.Well_Test_Stage_Id = wth_whp.Well_Test_Stage_Id
                 AND gafi.ID = wth_bhp.Utilized_Facility_Id
                 AND gafi.Activity_ID = 
wth_bhp.Well_Test_ID
                 AND aei.Involved_Activity_ID = wth_bhp.Well_Test_ID
                 AND fc.ID = aei.Involved_Entity_ID
                 AND fc.from_facility_id = gafi.facility_id
                 AND gafi1.facility_id = fc.to_facility_id
                 AND gafi1.Activity_ID = wth_bhp.Well_Test_ID
                 AND wth_whp.Utilized_Facility_Id = gafi1.ID
                 AND wtd_whp.observaton_number = wtd_bhp.observaton_number)
            WHT,
         (SELECT wtd_whp.Pressure
            FROM Well_Test_Trace wth_whp,
                 Well_Test_Trace_Data wtd_whp,
                 Generic_Act_Fac_Invl gafi,
                 Generic_Act_Fac_Invl gafi1,
                 Facility_Connection fc,
                 Activity_Entity_Invl aei
           WHERE     wth_whp.ID = wtd_whp.Well_Test_Trace_Id
                 AND wth_whp.Trace_Type = 'WHP'
                 AND wth_bhp.Well_Test_Stage_Id = wth_whp.Well_Test_Stage_Id
                 AND gafi.ID = 
wth_bhp.Utilized_Facility_Id
                 AND gafi.Activity_ID = wth_bhp.Well_Test_ID
                 AND aei.Involved_Activity_ID = wth_bhp.Well_Test_ID
                 AND fc.ID = aei.Involved_Entity_ID
                 AND fc.from_facility_id = gafi.facility_id
                 AND gafi1.facility_id = fc.to_facility_id
                 AND gafi1.Activity_ID = wth_bhp.Well_Test_ID
                 AND wth_whp.Utilized_Facility_Id = gafi1.ID
                 AND wtd_whp.observaton_number = wtd_bhp.observaton_number)
            WHP,
         (SELECT wtd_whp.Fluid_Flowrate
            FROM Well_Test_Trace wth_whp,
                 Well_Test_Trace_Data wtd_whp,
                 Generic_Act_Fac_Invl gafi,
                 Generic_Act_Fac_Invl gafi1,
                 Facility_Connection fc,
                 Activity_Entity_Invl aei
           WHERE     wth_whp.ID = wtd_whp.Well_Test_Trace_Id
                 AND wth_whp.Trace_Type = 'WHP'
                 AND 
wth_bhp.Well_Test_Stage_Id = wth_whp.Well_Test_Stage_Id
                 AND gafi.ID = wth_bhp.Utilized_Facility_Id
                 AND gafi.Activity_ID = wth_bhp.Well_Test_ID
                 AND aei.Involved_Activity_ID = wth_bhp.Well_Test_ID
                 AND fc.ID = aei.Involved_Entity_ID
                 AND fc.from_facility_id = gafi.facility_id
                 AND gafi1.facility_id = fc.to_facility_id
                 AND gafi1.Activity_ID = wth_bhp.Well_Test_ID
                 AND wth_whp.Utilized_Facility_Id = gafi1.ID
                 AND wtd_whp.observaton_number = wtd_bhp.observaton_number)
            Flow_Rate,
         (SELECT wtd_anp.PRESSURE
            FROM Well_Test_Trace wth_anp, Well_Test_Trace_Data wtd_anp
           WHERE     wth_anp.ID = wtd_anp.Well_Test_Trace_Id
                 AND wth_anp.Trace_Type = 'ANNULUS_PRESSURE'
                 AND wth_anp.Well_Test_Stage_Id = wth_bhp.Well_Test_Stage_Id
                 AND wtd_anp.observaton_number = 
wtd_bhp.observaton_number)
            Ann_Press,
         wtd_bhp.PRESSURE_POINT_GRADIENT Gradient,
         wtd_bhp.Remarks Remarks
    FROM Well_Test_Stage wts,
         Well_Test_Trace wth_bhp,
         Well_Test_Trace_Data wtd_bhp
   WHERE     wts.id = WTH_BHP.WELL_TEST_STAGE_ID
         AND wth_bhp.ID = wtd_bhp.Well_Test_Trace_Id
         AND wth_bhp.Trace_Type = 'BHP'

[Seabed Objects] [Entities in Schema Seabed] [Index]

EXP_GAE_RAW_TRACE_COM_DOV

Copyright © 2018 Schlumberger. All rights reserved.