VIEW: APPS.OKS_TEMPLATE_COUNTERS_V

Source

View Text - Preformatted

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 ,CA.SOURCE_OBJECT_ID SOURCE_OBJECT_ID ,CG.SOURCE_OBJECT_CODE FROM OKX_COUNTER_GROUPS_V CG ,OKX_COUNTERS_V CT ,OKX_CTR_ASSOCIATIONS_V CA WHERE CG.COUNTER_GROUP_ID = CT.COUNTER_GROUP_ID AND CG.COUNTER_GROUP_ID = CA.COUNTER_GROUP_ID

View Text - HTML Formatted

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
, CA.SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, CG.SOURCE_OBJECT_CODE
FROM OKX_COUNTER_GROUPS_V CG
, OKX_COUNTERS_V CT
, OKX_CTR_ASSOCIATIONS_V CA
WHERE CG.COUNTER_GROUP_ID = CT.COUNTER_GROUP_ID
AND CG.COUNTER_GROUP_ID = CA.COUNTER_GROUP_ID