Product: | CSI - Install Base |
---|---|
Description: | Backward compatible view for CS_COUNTER_VALUES |
Implementation/DBA Data: | APPS.CSI_COUNTER_READINGS_BC_V |
SELECT COUNTER_VALUE_ID COUNTER_VALUE_ID
, COUNTER_ID COUNTER_ID
, VALUE_TIMESTAMP VALUE_TIMESTAMP
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY CONTEXT
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TRANSACTION_ID COUNTER_GRP_LOG_ID
, COUNTER_READING COUNTER_READING
, DECODE(RESET_MODE
, NULL
, 'N'
, 'Y') RESET_FLAG
, RESET_REASON RESET_REASON
, ADJUSTMENT_TYPE MISC_READING_TYPE
, ADJUSTMENT_READING MISC_READING
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, DISABLED_FLAG VALID_FLAG
, COMMENTS COMMENTS
, TO_NUMBER(DECODE(RESET_MODE
, NULL
, NULL
, CSI_COUNTER_READINGS_PVT.GET_READING_BEFORE_RESET(COUNTER_ID
, VALUE_TIMESTAMP))) PRE_RESET_LAST_RDG
, TO_NUMBER(DECODE(RESET_MODE
, NULL
, NULL
, COUNTER_READING)) POST_RESET_FIRST_RDG
FROM CSI_COUNTER_READINGS