Name | EXP_GAE_PVT_EXP_DEW |
---|---|
Entity Type | ObjectView |
Description | Custom Exporters - EXP_GAE_PVT_EXP_DEW |
Submodel | Data_Object |
Entity Scope | Project |
Primary Key | Id |
Natural Key | |
Generalizations | |
Specializations |
Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
---|---|---|---|---|---|
ANALYSIS_METHOD | STRING64 | NA |
_ | No |
VARCHAR2(64) |
DEW_POINT_PRESS | NUMBER | NA |
_ | No |
NUMBER |
FLUID_ANALYSIS_ID | NUMBER | NA |
_ | No |
NUMBER |
Id | ID | No_Unit |
Unique identifier | Yes |
NUMBER(38) |
ROWNUM1 | NUMBER | NA |
_ | No |
NUMBER |
TEMPERATURE | NUMBER | NA |
_ | No |
NUMBER |
CREATE OR REPLACE FORCE VIEW EXP_GAE_PVT_EXP_DEW(TEMPERATURE, DEW_POINT_PRESS, ANALYSIS_METHOD, ID, FLUID_ANALYSIS_ID, ROWNUM1) AS SELECT EXP.*, ROWNUM FROM ( SELECT DISTINCT fa.Analysis_Temperature TEMPERATURE, NVL (fsps.Dew_Point_Pressure, 0) DEW_POINT_PRESS, fa.ANALYSIS_METHOD, fa.fluid_sample_id ID, FA1.ID fluid_analysis_id FROM fluid_analysis fa, fluid_analysis fa1, fluid_sample fs, Fluid_State_Pty_Set fsps WHERE FA1.FLUID_SAMPLE_ID = FS.ID AND FS.ID = FA.FLUID_SAMPLE_ID AND FSPS.FLUID_ANALYSIS_ID(+) = FA.ID AND fa.ANALYSIS_METHOD IN ('DIFFERENTIAL_VAPORIZATION', 'PRESSURE_VOLUME_RELATION', 'SEPARATION') ORDER BY fa.ANALYSIS_METHOD, fa.Analysis_Temperature) EXP |