Product: | EAM - Enterprise Asset Management |
---|---|
Description: | Work Order Completion Counter readings |
Implementation/DBA Data: | APPS.EAM_CFR_COUNTER_READINGS_V |
SELECT CCRV.COUNTER_VALUE_ID
, CCRV.COUNTER_NAME
, CCRV.COUNTER_DESCRIPTION
, CCRV.INITIAL_READING
, CCRV.READING_TYPE
, CLK.MEANING READING_TYPE
, CCRV.UOM_CODE
, CCRV.DIRECTION
, CLK2.MEANING DIRECTION
, CCRV.COUNTER_TYPE
, CCRV.ROLLOVER_LAST_READING
, CCRV.ROLLOVER_FIRST_READING
, CCRV.CUSTOMER_VIEW
, CCRV.FILTER_TYPE
, CCRV.FILTER_TIME_UOM
, CCRV.GROUP_ID
, CCRV.COUNTER_ID
, CCRV.VALUE_TIMESTAMP
, CCRV.COUNTER_READING
, CCRV.RESET_MODE
, CCRV.RESET_REASON
, CCRV.ADJUSTMENT_TYPE
, CCRV.ADJUSTMENT_READING
, CCRV.OBJECT_VERSION_NUMBER
, CCRV.LAST_UPDATE_DATE
, CCRV.LAST_UPDATED_BY
, CCRV.CREATION_DATE
, CCRV.CREATED_BY
, CCRV.LAST_UPDATE_LOGIN
, CCRV.ATTRIBUTE1
, CCRV.ATTRIBUTE2
, CCRV.ATTRIBUTE3
, CCRV.ATTRIBUTE4
, CCRV.ATTRIBUTE5
, CCRV.ATTRIBUTE6
, CCRV.ATTRIBUTE7
, CCRV.ATTRIBUTE8
, CCRV.ATTRIBUTE9
, CCRV.ATTRIBUTE10
, CCRV.ATTRIBUTE11
, CCRV.ATTRIBUTE12
, CCRV.ATTRIBUTE13
, CCRV.ATTRIBUTE14
, CCRV.ATTRIBUTE15
, CCRV.ATTRIBUTE16
, CCRV.ATTRIBUTE17
, CCRV.ATTRIBUTE18
, CCRV.ATTRIBUTE19
, CCRV.ATTRIBUTE20
, CCRV.ATTRIBUTE21
, CCRV.ATTRIBUTE22
, CCRV.ATTRIBUTE23
, CCRV.ATTRIBUTE24
, CCRV.ATTRIBUTE25
, CCRV.ATTRIBUTE26
, CCRV.ATTRIBUTE27
, CCRV.ATTRIBUTE28
, CCRV.ATTRIBUTE29
, CCRV.ATTRIBUTE30
, CCRV.ATTRIBUTE_CATEGORY
, CCRV.MIGRATED_FLAG
, CCRV.COMMENTS
, CCRV.LIFE_TO_DATE_READING
, CCRV.NET_READING
, CCRV.DISABLED_FLAG
, CCRV.AUTOMATIC_ROLLOVER_FLAG
, CCRV.TRANSACTION_ID
, CCRV.INCLUDE_TARGET_RESETS
, CCRV.SOURCE_COUNTER_VALUE_ID
, CCRV.READING_BEFORE_RESET
, CCRV.READING_AFTER_RESET
FROM CSI_COUNTER_READINGS_V CCRV
, CSI_LOOKUPS CLK2
, CSI_LOOKUPS CLK
WHERE TO_CHAR(CCRV.READING_TYPE)=TO_CHAR(CLK.LOOKUP_CODE)
AND CLK.LOOKUP_TYPE='CSI_COUNTER_READING_TYPE'
AND NVL(CCRV.DIRECTION
, 'B')=CLK2.LOOKUP_CODE
AND CLK2.LOOKUP_TYPE='CSI_COUNTER_DIRECTION_TYPE'