EXP_GAE_PVT_CURVE_DATA1


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

General Information

[Next]
Name EXP_GAE_PVT_CURVE_DATA1
Entity Type ObjectView
Description Custom Exporters - EXP_GAE_PVT_CURVE_DATA1
Submodel Data_Object
Entity Scope Project
Primary Key Id
Natural Key
Generalizations
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
CURVE_TYPE STRING64 NA
_ No
VARCHAR2(64)
DATA1 NUMBER NA
_ No
NUMBER
DATA10 NUMBER NA
_ No
NUMBER
DATA11 NUMBER NA
_ No
NUMBER
DATA2 NUMBER NA
_ No
NUMBER
DATA3 NUMBER NA
_ No
NUMBER
DATA4 NUMBER NA
_ No
NUMBER
DATA5 NUMBER NA
_ No
NUMBER
DATA6 NUMBER NA
_ No
NUMBER
DATA6_SEPS NUMBER NA
_ No
NUMBER
DATA7 NUMBER NA
_ No
NUMBER
DATA8 NUMBER NA
_ No
NUMBER
DATA9 NUMBER NA
_ No
NUMBER
Id ID No_Unit
Unique identifier Yes
NUMBER(38)
PRESSURE NUMBER NA
_ No
NUMBER
SEQUENCE_NUMBER NUMBER NA
_ No
NUMBER
TEMPERATURE NUMBER NA
_ No
NUMBER


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW EXP_GAE_PVT_CURVE_DATA1(ID, SEQUENCE_NUMBER, PRESSURE, CURVE_TYPE, TEMPERATURE, DATA1, DATA2, DATA3, DATA4, DATA5, DATA6, DATA6_SEPS, DATA7, DATA8, DATA9, DATA10, DATA11) AS SELECT pcds.fluid_analysis_id Id,
            pcd.Sequence_Number,
            pcd.Initial_Pressure,
            pcds.curve_type,
            PCD.TEMPERATURE,
            DECODE (PCD.PROPERTY_1_VALUE,
                    '-999.999', '0.0000',
                    '', '0.0000',
                    PCD.PROPERTY_1_VALUE)
               DATA1,
            NVL (PCD.PROPERTY_2_VALUE, '0.0000') DATA2,
            NVL (PCD.PROPERTY_3_VALUE, '0.0000') DATA3,
            PCD.PROPERTY_4_VALUE DATA4,
            NVL (PCD.PROPERTY_5_VALUE, '0.0000') DATA5,
            NVL (PCD.PROPERTY_6_VALUE, '0.0000') DATA6,
            NVL (1 / PCD.PROPERTY_6_VALUE, '0.0000') DATA6_SEPS,
            NVL (PCD.PROPERTY_7_VALUE, '0.0000') DATA7,
            NVL (PCD.PROPERTY_8_VALUE, '0.0000') DATA8,
            
NVL (PCD.PROPERTY_9_VALUE, '0.0000') DATA9,
            NVL (PCD.PROPERTY_10_VALUE, '0.0000') DATA10,
            NVL (PCD.PROPERTY_11_VALUE, '0.0000') DATA11
       FROM pvt_curve_data pcd, PVT_Curve_Data_Set pcds
      WHERE pcd.PVT_CURVE_DATA_SET_ID = pcds.id
   ORDER BY 3 DESC
   


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

Copyright © 2018 Schlumberger. All rights reserved.