| Name | EXP_GAE_PVT_CURVE_DATA |
|---|---|
| Entity Type | ObjectView |
| Description | Custom Exporters - EXP_GAE_PVT_CURVE_DATA |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| CURVE_TYPE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| DATA1 | NUMBER | NA |
_ | No |
NUMBER |
| DATA10 | NUMBER | NA |
_ | No |
NUMBER |
| DATA11 | NUMBER | NA |
_ | No |
NUMBER |
| DATA2 | NUMBER | NA |
_ | No |
NUMBER |
| DATA2_DIFF | NUMBER | NA |
_ | No |
NUMBER |
| DATA3 | NUMBER | NA |
_ | No |
NUMBER |
| DATA4 | NUMBER | NA |
_ | No |
NUMBER |
| DATA5 | NUMBER | NA |
_ | No |
NUMBER |
| DATA6 | NUMBER | NA |
_ | No |
NUMBER |
| DATA7 | NUMBER | NA |
_ | No |
NUMBER |
| DATA8 | NUMBER | NA |
_ | No |
NUMBER |
| DATA9 | NUMBER | NA |
_ | No |
NUMBER |
| Id | ID | No_Unit |
Unique identifier | Yes |
NUMBER(38) |
| PRESSURE | NUMBER | NA |
_ | No |
NUMBER |
| SEQUENCE_NUMBER | NUMBER | NA |
_ | No |
NUMBER |
| TEMPERATURE | NUMBER | NA |
_ | No |
NUMBER |
CREATE OR REPLACE FORCE VIEW EXP_GAE_PVT_CURVE_DATA(ID, SEQUENCE_NUMBER, PRESSURE, CURVE_TYPE, TEMPERATURE, DATA1, DATA2_DIFF, DATA2, DATA3, DATA4, DATA5, DATA6, DATA7, DATA8, DATA9, DATA10, DATA11) AS SELECT pcds.fluid_analysis_id Id,
pcd.Sequence_Number,
pcd.Initial_Pressure,
pcds.curve_type,
PCD.TEMPERATURE,
NVL (PCD.PROPERTY_1_VALUE, '0.0000') DATA1,
NVL (PCD.PROPERTY_2_VALUE/1000, '0.0000') DATA2_DIFF,
NVL (PCD.PROPERTY_2_VALUE, '0.0000') DATA2,
NVL (PCD.PROPERTY_3_VALUE, '0.0000') DATA3,
NVL (PCD.PROPERTY_4_VALUE, '0.0000') DATA4,
NVL (PCD.PROPERTY_5_VALUE, '0.0000') DATA5,
NVL (PCD.PROPERTY_6_VALUE, '0.0000') DATA6,
NVL (PCD.PROPERTY_7_VALUE, '0.0000') DATA7,
NVL (PCD.PROPERTY_8_VALUE, '0.0000') DATA8,
NVL (PCD.PROPERTY_9_VALUE, '0.0000') DATA9,
NVL (PCD.PROPERTY_10_VALUE, '0.0000') DATA10,
NVL (PCD.PROPERTY_11_VALUE, '0.0000') DATA11
FROM pvt_curve_data pcd, PVT_Curve_Data_Set pcds, Fluid_Analysis fa
WHERE pcd.PVT_CURVE_DATA_SET_ID = pcds.id
AND FA.ID = PCDS.FLUID_ANALYSIS_ID
AND FA.ANALYSIS_TEMPERATURE = PCD.TEMPERATURE
ORDER BY 3 DESC
|