Product: | EAM - Enterprise Asset Management |
---|---|
Description: | View gives details about meter and meter readings. |
Implementation/DBA Data: | APPS.EAM_METER_READINGS_V |
SELECT EC.METER_ID METER_ID
, EC.METER_NAME METER_NAME
, EC.METER_TYPE METER_TYPE
, EC.METER_UOM METER_UOM
, EC.VALUE_CHANGE_DIR VALUE_CHANGE_DIR
, CCR.COUNTER_VALUE_ID METER_READING_ID
, CCR.COUNTER_READING CURRENT_READING
, CCR.VALUE_TIMESTAMP CURRENT_READING_DATE
, DECODE(CCR.RESET_MODE
, 'SOFT'
, 'Y'
, 'N') RESET_FLAG
, CCR.DISABLED_FLAG DISABLE_FLAG
, DECODE(CCT.TRANSACTION_TYPE_ID
, 92
, CCT.SOURCE_HEADER_REF_ID
, TO_NUMBER(NULL)) WIP_ENTITY_ID
, CCR.LIFE_TO_DATE_READING
, CCR.COMMENTS DESCRIPTION
, EC.FROM_EFFECTIVE_DATE
, EC.TO_EFFECTIVE_DATE
, CCR.CREATED_BY
, CCR.CREATION_DATE
, CCR.LAST_UPDATE_LOGIN
, CCR.LAST_UPDATE_DATE
, CCR.LAST_UPDATED_BY
, CCR.ATTRIBUTE_CATEGORY
, 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
, TO_NUMBER(NULL) CURR_READING_NEW
, TO_DATE(NULL) CURR_READING_DATE
, TO_NUMBER(NULL) CURR_CHANGE
, CCR.COMMENTS PREV_DESC
, CCR.ROWID ROW_ID
, DECODE(CCR.RESET_MODE
, 'SOFT'
, 'Y'
, 'N') PREV_RESET
, 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
FROM EAM_COUNTERS_V EC
, CSI_COUNTER_READINGS CCR
, CSI_TRANSACTIONS CCT
WHERE EC.METER_ID = CCR.COUNTER_ID (+)
AND CCR.TRANSACTION_ID = CCT.TRANSACTION_ID(+)