| Name | EXP_SCAL_CURVE_SET_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Custom Exporters - EXP_SCAL_CURVE_SET_DOV |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Id | ID | No_Unit |
Unique identifier | Yes |
NUMBER(38) |
| PROPERTY_1_DIV | NUMBER | NA |
_ | No |
NUMBER |
| PROPERTY_1_VALUE | NUMBER | NA |
_ | No |
NUMBER |
| PROPERTY_2_DIV | NUMBER | NA |
_ | No |
NUMBER |
| PROPERTY_2_VALUE | NUMBER | NA |
_ | No |
NUMBER |
| PROPERTY_3_VALUE | NUMBER | NA |
_ | No |
NUMBER |
| SCAL_ANALYSIS_ID | NUMBER | NA |
_ | No |
NUMBER |
CREATE OR REPLACE FORCE VIEW EXP_SCAL_CURVE_SET_DOV(PROPERTY_1_VALUE, PROPERTY_2_VALUE, PROPERTY_3_VALUE, PROPERTY_1_DIV, PROPERTY_2_DIV, SCAL_ANALYSIS_ID, ID) AS SELECT SCD.PROPERTY_1_VALUE,
SCD.PROPERTY_2_VALUE,
SCD.PROPERTY_3_VALUE,
SCD.PROPERTY_1_VALUE / 100 PROPERTY_1_DIV,
SCD.PROPERTY_2_VALUE / 100 PROPERTY_2_DIV,
SCD.SCAL_ANALYSIS_ID,
SCD.ID
FROM SCAL_CURVE_DATA_SET scd
|