Product: | CS - Service |
---|---|
Description: | Counter values view |
Implementation/DBA Data: | Not implemented in this database |
SELECT A.ROWID
, A.OBJECT_VERSION_NUMBER
, A.COUNTER_GRP_LOG_ID
, A.COUNTER_ID
, A.COUNTER_VALUE_ID
, B.COUNTER_GROUP_ID
, C.NAME
, C.DESCRIPTION
, A.VALUE_TIMESTAMP
, A.COUNTER_READING
, DECODE(A.RESET_FLAG
, 'Y'
, NVL(A.PRE_RESET_LAST_RDG
, 0) + NVL(A.COUNTER_READING
, 0) - NVL(A.MISC_READING
, 0) - NVL(A.POST_RESET_FIRST_RDG
, 0) - NVL(A.PREV_NET_CURR_DIFF
, 0)
, NVL(A.COUNTER_READING
, 0) - NVL(A.MISC_READING
, 0) - NVL(A.PREV_NET_CURR_DIFF
, 0) ) NET_READING
, A.RESET_FLAG
, A.RESET_REASON
, A.PRE_RESET_LAST_RDG
, A.POST_RESET_FIRST_RDG
, A.MISC_READING_TYPE
, CSL.MEANING MISC_READING_TYPE_DESC
, A.MISC_READING
, B.SOURCE_TRANSACTION_ID
, B.SOURCE_TRANSACTION_CODE
, C.INITIAL_READING
, C.STEP_VALUE
, C.UOM_CODE
, C.TOLERANCE_PLUS
, C.TOLERANCE_MINUS
, C.TYPE
, C.ROLLOVER_LAST_READING
, C.ROLLOVER_FIRST_READING
, A1.COUNTER_READING PREV_COUNTER_READING
, DECODE(A1.RESET_FLAG
, 'Y'
, NVL(A1.PRE_RESET_LAST_RDG
, 0) + NVL( A1.COUNTER_READING
, 0) - NVL(A1.MISC_READING
, 0) - NVL(A1.POST_RESET_FIRST_RDG
, 0) - NVL(A1.PREV_NET_CURR_DIFF
, 0)
, NVL(A1.COUNTER_READING
, 0) - NVL(A1.MISC_READING
, 0) - NVL(A1.PREV_NET_CURR_DIFF
, 0) ) PREV_NET_READING
, C.START_DATE_ACTIVE
, C.END_DATE_ACTIVE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.CONTEXT
, A.VALID_FLAG
, A.OVERRIDE_VALID_FLAG
, A.FILTER_TYPE
, A.FILTER_READING_COUNT
, A.FILTER_TIME_UOM
, A.COMMENTS
FROM CS_COUNTER_VALUES A
, CS_COUNTER_GRP_LOG B
, CS_COUNTERS C
, CS_COUNTER_VALUES A1
, (SELECT LOOKUP_CODE
, MEANING
FROM CS_LOOKUPS
WHERE LOOKUP_TYPE = 'CS_CTR_MISC_READING_TYPE') CSL
WHERE A.COUNTER_GRP_LOG_ID = B.COUNTER_GRP_LOG_ID
AND A.COUNTER_ID = C.COUNTER_ID
AND A1.COUNTER_ID (+) = A.COUNTER_ID
AND A1.SEQ_NO (+) = A.SEQ_NO - 1
AND CSL.LOOKUP_CODE(+)= A.MISC_READING_TYPE