| Name | EXP_GAE_PVT_CURVE_SEPS |
|---|---|
| Entity Type | ObjectView |
| Description | Custom Exporters - EXP_GAE_PVT_CURVE_SEPS |
| 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) |
| DATA5 | NUMBER | NA |
_ | No |
NUMBER |
| Id | ID | No_Unit |
Unique identifier | Yes |
NUMBER(38) |
CREATE OR REPLACE FORCE VIEW EXP_GAE_PVT_CURVE_SEPS(ID, DATA5, CURVE_TYPE) AS SELECT pcds.fluid_analysis_id Id,
NVL (PCD.PROPERTY_5_VALUE, '0.0000') DATA5,
pcds.curve_type
FROM pvt_curve_data pcd, PVT_Curve_Data_Set pcds
WHERE pcd.PVT_CURVE_DATA_SET_ID = pcds.id
AND PCD.SEQUENCE_NUMBER =
(SELECT MAX (PCD1.SEQUENCE_NUMBER)
FROM pvt_curve_data pcd1
WHERE pcd1.PVT_CURVE_DATA_SET_ID = pcds.id)
|