View: CSI_COUNTER_READINGS_BCV_V

Product:	CSI - Install Base
Description:	Backward compatible view for CS_CTR_COUNTER_VALUES_V
Implementation/DBA Data:	APPS.CSI_COUNTER_READINGS_BCV_V

View Text

SELECT CCR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCR.TRANSACTION_ID COUNTER_GRP_LOG_ID
, CCR.COUNTER_ID COUNTER_ID
, CCR.COUNTER_VALUE_ID COUNTER_VALUE_ID
, CCB.COUNTER_GROUP_ID COUNTER_GROUP_ID
, CCB.NAME COUNTER_NAME
, CCB.DESCRIPTION COUNTER_DESCRIPTION
, CCR.VALUE_TIMESTAMP VALUE_TIMESTAMP
, CCR.COUNTER_READING COUNTER_READING
, CCR.NET_READING NET_READING
, DECODE(CCR.RESET_MODE
, NULL
, 'N'
, 'Y') RESET_FLAG
, CCR.RESET_REASON RESET_REASON
, CCR.ADJUSTMENT_TYPE MISC_READING_TYPE
, CSL.MEANING MISC_READING_TYPE_DESC
, CCR.ADJUSTMENT_READING MISC_READING
, CT.SOURCE_HEADER_REF_ID SOURCE_TRANSACTION_ID
, TO_CHAR(DECODE(CTT.TRANSACTION_TYPE_ID
, 10027
, 'CONTRACT_LINE'
, 10026
, 'CP'
, 10031
, 'OKL_CNTR_GRP'
, 10042
, 'FS'
, 10043
, 'DR')) SOURCE_TRANSACTION_CODE
, CCB.INITIAL_READING INITIAL_READING
, CCB.UOM_CODE UOM_CODE
, CCB.TOLERANCE_PLUS TOLERANCE_PLUS
, CCB.TOLERANCE_MINUS TOLERANCE_MINUS
, CCB.TYPE TYPE
, CCB.ROLLOVER_LAST_READING ROLLOVER_LAST_READING
, CCB.ROLLOVER_FIRST_READING ROLLOVER_FIRST_READING
, CSI_COUNTER_READINGS_PVT.GET_READING_BEFORE_RESET(CCR.COUNTER_ID
, CCR.VALUE_TIMESTAMP) PREV_COUNTER_READING
, CSI_COUNTER_READINGS_PVT.GET_PREVIOUS_NET_READING(CCR.COUNTER_ID
, CCR.VALUE_TIMESTAMP) PREV_NET_READING
, CCB.START_DATE_ACTIVE START_DATE_ACTIVE
, CCB.END_DATE_ACTIVE END_DATE_ACTIVE
, 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.ATTRIBUTE_CATEGORY CONTEXT
, CCR.DISABLED_FLAG VALID_FLAG
, CCB.FILTER_TYPE FILTER_TYPE
, CCB.FILTER_READING_COUNT FILTER_READING_COUNT
, CCB.FILTER_TIME_UOM FILTER_TIME_UOM
, CCR.COMMENTS COMMENTS
, TO_NUMBER(DECODE(CCR.RESET_MODE
, NULL
, NULL
, CSI_COUNTER_READINGS_PVT.GET_READING_BEFORE_RESET(CCR.COUNTER_ID
, CCR.VALUE_TIMESTAMP))) PRE_RESET_LAST_RDG
, TO_NUMBER(DECODE(CCR.RESET_MODE
, NULL
, NULL
, CCR.COUNTER_READING)) POST_RESET_FIRST_RDG
FROM CSI_COUNTER_READINGS CCR
, CSI_COUNTERS_BC_V CCB
, CSI_TRANSACTIONS CT
, (SELECT LOOKUP_CODE
, MEANING
FROM CSI_LOOKUPS
WHERE LOOKUP_TYPE = 'CSI_CTR_ADJUST_READING_TYPE') CSL
, CSI_TXN_TYPES CTT
WHERE CCR.TRANSACTION_ID = CT.TRANSACTION_ID
AND CCR.COUNTER_ID = CCB.COUNTER_ID
AND CT.TRANSACTION_TYPE_ID = CTT.TRANSACTION_TYPE_ID
AND CSL.LOOKUP_CODE (+) = CCR.ADJUSTMENT_TYPE

Columns