| 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 |
| Name | Value Domain | Property / Storage Unit | Description | Required / 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 |
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'))
|