Product: | CSI - Install Base |
---|---|
Description: | Backward compatible view for CS_CTR_PROPERTY_VALUES_V |
Implementation/DBA Data: | APPS.CSI_CTR_PROPERTY_VALUES_BCV_V |
SELECT CCPR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCR.TRANSACTION_ID COUNTER_GRP_LOG_ID
, CCPV.COUNTER_ID COUNTER_ID
, CCPR.COUNTER_PROP_VALUE_ID COUNTER_PROP_VALUE_ID
, CCPR.COUNTER_PROPERTY_ID COUNTER_PROPERTY_ID
, CCPR.COUNTER_VALUE_ID COUNTER_VALUE_ID
, CCPV.NAME PROPERTY_NAME
, CCPV.DESCRIPTION DESCRIPTION
, CCR.VALUE_TIMESTAMP VALUE_TIMESTAMP
, CCPR.PROPERTY_VALUE PROPERTY_VALUE
, CCPV.PROPERTY_DATA_TYPE PROPERTY_DATA_TYPE
, CCPV.DEFAULT_VALUE DEFAULT_VALUE
, CCPV.MINIMUM_VALUE MINIMUM_VALUE
, CCPV.MAXIMUM_VALUE MAXIMUM_VALUE
, CCPV.UOM_CODE UOM_CODE
, CCPV.IS_NULLABLE IS_NULLABLE
, CCPV.START_DATE_ACTIVE START_DATE_ACTIVE
, CCPV.END_DATE_ACTIVE END_DATE_ACTIVE
, CCR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCR.LAST_UPDATED_BY LAST_UPDATED_BY
, CCR.CREATION_DATE CREATION_DATE
, CCR.CREATED_BY CREATED_BY
, CCR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCR.ATTRIBUTE1 ATTRIBUTE1
, CCR.ATTRIBUTE2 ATTRIBUTE2
, CCR.ATTRIBUTE3 ATTRIBUTE3
, CCR.ATTRIBUTE4 ATTRIBUTE4
, CCR.ATTRIBUTE5 ATTRIBUTE5
, CCR.ATTRIBUTE6 ATTRIBUTE6
, CCR.ATTRIBUTE7 ATTRIBUTE7
, CCR.ATTRIBUTE8 ATTRIBUTE8
, CCR.ATTRIBUTE9 ATTRIBUTE9
, CCR.ATTRIBUTE10 ATTRIBUTE10
, CCR.ATTRIBUTE11 ATTRIBUTE11
, CCR.ATTRIBUTE12 ATTRIBUTE12
, CCR.ATTRIBUTE13 ATTRIBUTE13
, CCR.ATTRIBUTE14 ATTRIBUTE14
, CCR.ATTRIBUTE15 ATTRIBUTE15
, CCR.ATTRIBUTE_CATEGORY CONTEXT
FROM CSI_CTR_PROP_READINGS_BC_V CCPR
, CSI_CTR_PROPERTIES_BC_V CCPV
, CSI_COUNTER_READINGS CCR
WHERE CCPR.COUNTER_VALUE_ID = CCR.COUNTER_VALUE_ID
AND CCPR.COUNTER_PROPERTY_ID = CCPV.COUNTER_PROPERTY_ID