EXP_GAE_PVT_CNAME


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

General Information

[Next]
Name EXP_GAE_PVT_CNAME
Entity Type ObjectView
Description Custom Exporters - EXP_GAE_PVT_CNAME
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
REF_ID NUMBER NA
_ No
NUMBER


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW EXP_GAE_PVT_CNAME(COMP, ID, MOLE_FRACTION, MOLECULAR_WEIGHT, FLUID_ANALYSIS_ID, REF_ID) AS SELECT "COMP",
          "ID",
          "MOLE_FRACTION",
          "MOLECULAR_WEIGHT",
          "FLUID_ANALYSIS_ID",
          "REF_ID"
     FROM (SELECT NULL COMP,
                  NULL ID,
                  NULL MOLE_FRACTION,
                  NULL MOLECULAR_WEIGHT,
                  fluid_analysis_id,
                  NULL REF_ID
             FROM Material_Composition
            WHERE MATERIAL_TYPE <> 'RESERVOIR_STREAM_FLUID')
   UNION
   (SELECT "COMP",
           "ID",
           "MOLE_FRACTION",
           "MOLECULAR_WEIGHT",
           "FLUID_ANALYSIS_ID",
           "REF_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,
                   r_mc.ref_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')
     WHERE comp NOT IN
              ('H2',
               'N2',
               'CO',
               'CO2',
               'H2S',
               'H2O',
               'C1',
               'C2',
               'C3',
               'C4',
               'IC4',
               'NC4',
               'C5',
               'IC5',
               'NC5',
               'C6',
               'C7',
               'C8',
               'C9',
               'C10',
               'C11',
               'C12',
               'C13',
               'C14',
               
'C15',
               'C16',
               'C17',
               'C18',
               'C19',
               'C20',
               'C22',
               'C23',
               'C24',
               'C25',
               'C26',
               'C27',
               'C28',
               'C29',
               'C30',
               'C31',
               'C32',
               'C33',
               'C34',
               'C35',
               'C36',
               'C37',
               'C38',
               'C39',
               'C40',
               'C41',
               'C42',
               'C43',
               'C44',
               'C45'))
   


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

Copyright © 2018 Schlumberger. All rights reserved.