Product: | CS - Service |
---|---|
Description: | This view contains the information pertaining to counters (values,groups) |
Implementation/DBA Data: | Not implemented in this database |
SELECT A.ROWID
, C.OBJECT_VERSION_NUMBER
, A.COUNTER_GRP_LOG_ID
, C.COUNTER_ID
, A.COUNTER_VALUE_ID
, C.COUNTER_GROUP_ID
, C.NAME
, C.DESCRIPTION
, A.VALUE_TIMESTAMP
, A.COUNTER_READING
, DECODE(A.RESET_FLAG
, 'Y'
, A.PRE_RESET_LAST_RDG + A.COUNTER_READING - A.MISC_READING - A.POST_RESET_FIRST_RDG - A.PREV_NET_CURR_DIFF
, A.COUNTER_READING - A.MISC_READING - A.PREV_NET_CURR_DIFF ) NET_READING
, A.RESET_FLAG
, A.RESET_REASON
, A.PRE_RESET_LAST_RDG
, A.POST_RESET_FIRST_RDG
, A.MISC_READING_TYPE
, A.MISC_READING
, 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
, A.PREV_NET_CURR_DIFF
, CP.CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, A.SEQ_NO SEQUENCE_NO
, CP.REFERENCE_NUMBER REFERENCE_NUMBER
, C.FORMULA_INCOMPL_FLAG
, MSITEM.CONCATENATED_SEGMENTS PRODUCT_NAME
, MSITEM.DESCRIPTION PRODUCT_DESCRIPTION
, CP.CURRENT_SERIAL_NUMBER SERIAL_NUMBER
, CP.LOT_NUMBER
, 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
FROM CS_COUNTERS C
, CS_COUNTER_VALUES A
, CS_COUNTER_GROUPS CTRGRP
, CS_CUSTOMER_PRODUCTS CP
, MTL_SYSTEM_ITEMS_KFV MSITEM
WHERE C.COUNTER_ID = A.COUNTER_ID (+)
AND C.CTR_VAL_MAX_SEQ_NO = A.SEQ_NO(+)
AND C.COUNTER_GROUP_ID(+) = CTRGRP.COUNTER_GROUP_ID
AND CTRGRP.SOURCE_OBJECT_CODE = 'CP'
AND CTRGRP.SOURCE_OBJECT_ID = CP.CUSTOMER_PRODUCT_ID
AND MSITEM.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID
AND MSITEM.ORGANIZATION_ID = ( SELECT CS_STD.GET_ITEM_VALDN_ORGZN_ID
FROM DUAL )