[Home] [Help]
View: OKS_COUNTERS_V
Product: | OKS - Service Contracts |
Description: | Counters View for Service Contracts |
Implementation/DBA Data: |
APPS.OKS_COUNTERS_V
|
View Text
SELECT CG.COUNTER_GROUP_ID COUNTER_GROUP_ID
, CT.COUNTER_ID COUNTER_ID
, CG.NAME || '.' || CT.NAME NAME
, CT.TYPE TYPE
, CT.UOM_CODE UOM_CODE
, CT.NET_READING NET_READING
, CT.VALUE_TIMESTAMP VALUE_TIMESTAMP
, CG.SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, CG.SOURCE_OBJECT_CODE SOURCE_OBJECT_CODE
, CG.TEMPLATE_FLAG
FROM OKX_COUNTER_GROUPS_V CG
, OKX_COUNTERS_V CT
WHERE CG.COUNTER_GROUP_ID = CT.COUNTER_GROUP_ID
Columns
Name |
COUNTER_GROUP_ID |
COUNTER_ID |
NAME |
TYPE |
UOM_CODE |
NET_READING |
VALUE_TIMESTAMP |
SOURCE_OBJECT_ID |
SOURCE_OBJECT_CODE |
TEMPLATE_FLAG |