| Name | EXP_GAE_PVT_COUNT_CNAME |
|---|---|
| Entity Type | ObjectView |
| Description | Custom Exporters - EXP_GAE_PVT_COUNT_CNAME |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| DIFF | NUMBER | NA |
_ | No |
NUMBER |
| Id | ID | No_Unit |
Unique identifier | Yes |
NUMBER(38) |
CREATE OR REPLACE FORCE VIEW EXP_GAE_PVT_COUNT_CNAME(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 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
|