| Name | EXP_GAE_PVT_EXP1 |
|---|---|
| Entity Type | ObjectView |
| Description | Custom Exporters - EXP_GAE_PVT_EXP1 |
| 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) |
| BUBBLE_POINT_PRESS | NUMBER | NA |
_ | No |
NUMBER |
| DEW_POINT_PRESS | NUMBER | NA |
_ | No |
NUMBER |
| EXTERNAL_REFERENCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| 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_EXP1(TEMPERATURE, BUBBLE_POINT_PRESS, DEW_POINT_PRESS, ANALYSIS_METHOD, ID, FLUID_ANALYSIS_ID, EXTERNAL_REFERENCE, ROWNUM1) AS SELECT EXP.*, ROWNUM
FROM ( SELECT DISTINCT
fa.Analysis_Temperature TEMPERATURE,
NVL (fsps.Bubble_Point_Pressure, 0) Bubble_Point_Pressure,
NVL (fsps.Dew_Point_Pressure, 0) DEW_POINT_PRESS,
fa.ANALYSIS_METHOD,
fa.ID ID,
FA1.ID fluid_analysis_id,
FA.EXTERNAL_REFERENCE
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
ORDER BY fa.Analysis_Temperature DESC, fa.ANALYSIS_METHOD DESC) EXP
|