VIEW: APPS.OKX_COUNTERS_V

Source

View Text - Preformatted

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 (+) = OKS_AUTH_UTIL_PVT.GET_NET_READING(C.COUNTER_ID)

View Text - HTML Formatted

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 (+) = OKS_AUTH_UTIL_PVT.GET_NET_READING(C.COUNTER_ID)