Product: | CSI - Install Base |
---|---|
Description: | Counter readings view |
Implementation/DBA Data: | APPS.CSI_COUNTER_READINGS_V |
SELECT CCR.COUNTER_VALUE_ID COUNTER_VALUE_ID
, CCV.NAME COUNTER_NAME
, CCV.DESCRIPTION COUNTER_DESCRIPTION
, CCV.INITIAL_READING INITIAL_READING
, CCV.READING_TYPE READING_TYPE
, CCV.UOM_CODE UOM_CODE
, CCV.DIRECTION DIRECTION
, CCV.COUNTER_TYPE COUNTER_TYPE
, CCV.ROLLOVER_LAST_READING ROLLOVER_LAST_READING
, CCV.ROLLOVER_FIRST_READING ROLLOVER_FIRST_READING
, CCV.CUSTOMER_VIEW CUSTOMER_VIEW
, CCV.FILTER_TYPE FILTER_TYPE
, CCV.FILTER_TIME_UOM FILTER_TIME_UOM
, CCV.GROUP_ID GROUP_ID
, CCR.COUNTER_ID COUNTER_ID
, CCR.VALUE_TIMESTAMP VALUE_TIMESTAMP
, CCR.COUNTER_READING COUNTER_READING
, CCR.RESET_MODE RESET_MODE
, CCR.RESET_REASON RESET_REASON
, CCR.ADJUSTMENT_TYPE ADJUSTMENT_TYPE
, CCR.ADJUSTMENT_READING ADJUSTMENT_READING
, CCR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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.ATTRIBUTE16 ATTRIBUTE16
, CCR.ATTRIBUTE17 ATTRIBUTE17
, CCR.ATTRIBUTE18 ATTRIBUTE18
, CCR.ATTRIBUTE19 ATTRIBUTE19
, CCR.ATTRIBUTE20 ATTRIBUTE20
, CCR.ATTRIBUTE21 ATTRIBUTE21
, CCR.ATTRIBUTE22 ATTRIBUTE22
, CCR.ATTRIBUTE23 ATTRIBUTE23
, CCR.ATTRIBUTE24 ATTRIBUTE24
, CCR.ATTRIBUTE25 ATTRIBUTE25
, CCR.ATTRIBUTE26 ATTRIBUTE26
, CCR.ATTRIBUTE27 ATTRIBUTE27
, CCR.ATTRIBUTE28 ATTRIBUTE28
, CCR.ATTRIBUTE29 ATTRIBUTE29
, CCR.ATTRIBUTE30 ATTRIBUTE30
, CCR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CCR.MIGRATED_FLAG MIGRATED_FLAG
, CCR.COMMENTS COMMENTS
, CCR.LIFE_TO_DATE_READING LIFE_TO_DATE_READING
, CCR.NET_READING NET_READING
, CCR.DISABLED_FLAG DISABLED_FLAG
, CCR.AUTOMATIC_ROLLOVER_FLAG AUTOMATIC_ROLLOVER_FLAG
, CCR.TRANSACTION_ID TRANSACTION_ID
, CCR.INCLUDE_TARGET_RESETS INCLUDE_TARGET_RESETS
, CCR.SOURCE_COUNTER_VALUE_ID SOURCE_COUNTER_VALUE_ID
, TO_NUMBER(DECODE(CCR.RESET_MODE
, NULL
, NULL
, CSI_COUNTER_READINGS_PVT.GET_READING_BEFORE_RESET(CCR.COUNTER_ID
, CCR.VALUE_TIMESTAMP))) READING_BEFORE_RESET
, TO_NUMBER(DECODE(CCR.RESET_MODE
, NULL
, NULL
, CCR.COUNTER_READING)) READING_AFTER_RESET
FROM CSI_COUNTERS_VL CCV
, CSI_COUNTER_READINGS CCR
WHERE CCV.COUNTER_ID = CCR.COUNTER_ID (+)