EXP_GAE_PVT_COUNT_LNAME


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

General Information

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


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
DIFF NUMBER NA
_ No
NUMBER
Id ID No_Unit
Unique identifier Yes
NUMBER(38)


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW EXP_GAE_PVT_COUNT_LNAME(ID, DIFF) AS SELECT fluid_analysis_id, SUM (DIFF)
       FROM (SELECT fluid_analysis_id, 0 DIFF
               FROM Material_Composition
              WHERE MATERIAL_TYPE <> 'RESERVOIR_STREAM_FLUID'
             UNION
             SELECT a.fluid_analysis_id id, b.num1 - a.num2 Diff
               FROM (  SELECT COUNT (*) num2, 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,
                                        Molecular_Weight,
                                        r_mc.ref_id,
                                        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 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')
                     GROUP BY fluid_analysis_id) a,
                    (  SELECT COUNT (*) num1, fluid_analysis_id
                         FROM Material_Composition
                        WHERE MATERIAL_TYPE = 'RESERVOIR_STREAM_FLUID'
                     GROUP BY fluid_analysis_id) b
              WHERE a.fluid_analysis_id = b.fluid_analysis_id)
   GROUP BY fluid_analysis_id
   


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

Copyright © 2018 Schlumberger. All rights reserved.