| Name | EXP_GAE_PVT_COUNT_TOT |
|---|---|
| Entity Type | ObjectView |
| Description | Custom Exporters - EXP_GAE_PVT_COUNT_TOT |
| 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_TOT(ID, DIFF) AS select fluid_analysis_id, sum(count) from
(SELECT fluid_analysis_id, 0 count
FROM Material_Composition
WHERE MATERIAL_TYPE <> 'RESERVOIR_STREAM_FLUID'
union
SELECT fluid_analysis_id, COUNT (*) count
FROM Material_Composition
WHERE MATERIAL_TYPE = 'RESERVOIR_STREAM_FLUID'
GROUP BY fluid_analysis_id) group by fluid_analysis_id
|