EXP_GAE_PVT_HYDRO


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

General Information

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


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
COMP STRING64 NA
_ No
VARCHAR2(64)
FLUID_ANALYSIS_ID NUMBER NA
_ No
NUMBER
Id ID No_Unit
Unique identifier Yes
NUMBER(38)
MOLECULAR_WEIGHT NUMBER NA
_ No
NUMBER
MOLE_FRACTION NUMBER NA
_ No
NUMBER


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW EXP_GAE_PVT_HYDRO(COMP, ID, MOLE_FRACTION, MOLECULAR_WEIGHT, FLUID_ANALYSIS_ID) AS SELECT "COMP",
          "ID",
          "MOLE_FRACTION",
          "MOLECULAR_WEIGHT",
          "FLUID_ANALYSIS_ID"
     FROM (SELECT NULL COMP,
                  NULL ID,
                  NULL MOLE_FRACTION,
                  NULL MOLECULAR_WEIGHT,
                  fluid_analysis_id
             FROM Material_Composition
            WHERE MATERIAL_TYPE <> 'RESERVOIR_STREAM_FLUID')
   UNION
   (SELECT "COMP",
           "ID",
           "MOLE_FRACTION",
           "MOLECULAR_WEIGHT",
           "FLUID_ANALYSIS_ID"
      FROM (  SELECT DISTINCT
                     DECODE (component_material_type,
                             'CH4', 'C1',
                             'C2H6', 'C2',
                             'C3H8', 'C3',
                             'C4H10', 'C4',
                             'i_C4H10', 'IC4',
                             'n_C4H10', 'NC4',
              
               'C5H12', 'C5',
                             'i_C5H12', 'IC5',
                             'n_C5H12', 'NC5',
                             'pseudo C6H14', 'C6',
                             'pseudo C7H16', 'C7',
                             'pseudo C8H18', 'C8',
                             'pseudo C9H20', 'C9',
                             'pseudo C10H22', 'C10',
                             'pseudo C11H24', 'C11',
                             'pseudo C12H26', 'C12',
                             'pseudo C13H28', 'C13',
                             'pseudo C14H30', 'C14',
                             'pseudo C15H32', 'C15',
                             'pseudo C16H34', 'C16',
                             'pseudo C17H36', 'C17',
                             'pseudo C18H38', 'C18',
                             'pseudo C19H40', 'C19',
                             component_material_type)
                        comp,
                     mc.id,
                     
(Mole_Fraction / 100) Mole_Fraction,
                     Molecular_Weight,
                     mc.fluid_analysis_id
                FROM Material_Composition mc, R_Material_Category r_mc
               WHERE     mc.MATERIAL_TYPE = 'RESERVOIR_STREAM_FLUID'
                     AND MC.COMPONENT_MATERIAL_TYPE = r_mc.PRODUCTION_MATERIAL
                     AND r_mc.material_category = 'ALL_COMPONENTS'
            ORDER BY 5)
     WHERE comp IN ('H2', 'N2', 'CO', 'CO2', 'H2S', 'H2O'))
   


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

Copyright © 2018 Schlumberger. All rights reserved.