Product: | CS - Service |
---|---|
Description: | Counter property values view |
Implementation/DBA Data: | Not implemented in this database |
SELECT A.ROWID
, A.OBJECT_VERSION_NUMBER
, D.COUNTER_GRP_LOG_ID
, C.COUNTER_ID
, A.COUNTER_PROP_VALUE_ID
, A.COUNTER_PROPERTY_ID
, A.COUNTER_VALUE_ID
, C.NAME
, C.DESCRIPTION
, A.VALUE_TIMESTAMP
, A.PROPERTY_VALUE
, C.PROPERTY_DATA_TYPE
, C.DEFAULT_VALUE
, C.MINIMUM_VALUE
, C.MAXIMUM_VALUE
, C.UOM_CODE
, C.IS_NULLABLE
, C.START_DATE_ACTIVE
, C.END_DATE_ACTIVE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.CONTEXT
FROM CS_COUNTER_PROP_VALUES A
, CS_COUNTER_GRP_LOG B
, CS_COUNTER_PROPERTIES C
, CS_COUNTER_VALUES D
WHERE A.COUNTER_VALUE_ID = D.COUNTER_VALUE_ID
AND A.COUNTER_PROPERTY_ID = C.COUNTER_PROPERTY_ID
AND D.COUNTER_GRP_LOG_ID = B.COUNTER_GRP_LOG_ID