View: OKX_COUNTERS_V

Product:	OKX - Contracts Integration
Description:	Counters, counter instances and counter templates
Implementation/DBA Data:	APPS.OKX_COUNTERS_V

View Text

SELECT C.COUNTER_ID ID1
, '#' ID2
, C.COUNTER_ID COUNTER_ID
, C.COUNTER_GROUP_ID COUNTER_GROUP_ID
, C.NAME NAME
, C.DESCRIPTION DESCRIPTION
, C.TYPE TYPE
, C.START_DATE_ACTIVE START_DATE_ACTIVE
, C.END_DATE_ACTIVE END_DATE_ACTIVE
, C.CREATED_FROM_COUNTER_TMPL_ID CREATED_FROM_COUNTER_TMPL_ID
, C.CREATED_FROM_COUNTER_TMPL_ID SOURCE_COUNTER_ID
, C.INITIAL_READING INITIAL_READING
, C.UOM_CODE UOM_CODE
, C.USAGE_ITEM_ID USAGE_ITEM_ID
, C.CTR_VAL_MAX_SEQ_NO CTR_VAL_MAX_SEQ_NO
, CV.COUNTER_VALUE_ID COUNTER_VALUE_ID
, CV.VALUE_TIMESTAMP VALUE_TIMESTAMP
, CV.COUNTER_READING COUNTER_READING
, CV.NET_READING NET_READING
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(C.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(C.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, C.UOM_CODE PRIMARY_UOM_CODE
FROM CSI_COUNTERS_BC_V C
, CSI_COUNTER_READINGS CV
WHERE CV.COUNTER_ID (+) = C.COUNTER_ID
AND CV.COUNTER_VALUE_ID (+) = CSI_COUNTER_READINGS_PVT.GET_LATEST_READING(C.COUNTER_ID)

Columns