VIEW: APPS.OKS_USAGE_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 ,CG.SOURCE_OBJECT_ID SOURCE_OBJECT_ID ,CG.SOURCE_OBJECT_CODE SOURCE_OBJECT_CODE ,CT.USAGE_ITEM_ID USAGE_ITEM_ID ,IT.NAME SOURCE_DETAILS ,CII.SERIAL_NUMBER CURRENT_SERIAL_NUMBER ,to_char(CII.INSTANCE_NUMBER) REFERENCE_NUMBER ,CG.Template_Flag FROM OKX_COUNTER_GROUPS_V CG ,OKX_COUNTERS_V CT , CSI_ITEM_INSTANCES CII ,OKX_SYSTEM_ITEMS_V IT WHERE CG.COUNTER_GROUP_ID = CT.COUNTER_GROUP_ID AND CT.USAGE_ITEM_ID IS NOT NULL AND CG.SOURCE_OBJECT_ID = CII.INSTANCE_ID AND CG.SOURCE_OBJECT_CODE = 'CP' AND IT.ID1 = CII.INVENTORY_ITEM_ID AND IT.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID') UNION 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 ,CT.USAGE_ITEM_ID USAGE_ITEM_ID ,KL.NAME|| '-' ||KH.CONTRACT_NUMBER SOURCE_DETAILS ,NULL CURRENT_SERIAL_NUMBER ,NULL REFERENCE_NUMBER ,CG.Template_Flag FROM OKX_COUNTER_GROUPS_V CG ,OKX_COUNTERS_V CT ,OKC_K_LINES_V KL ,OKC_K_HEADERS_V KH WHERE CG.COUNTER_GROUP_ID = CT.COUNTER_GROUP_ID AND CT.USAGE_ITEM_ID IS NOT NULL AND CG.SOURCE_OBJECT_ID = KL.ID AND CG.SOURCE_OBJECT_CODE = 'CONTRACT_LINE' AND KH.ID = KL.DNZ_CHR_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
, CG.SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, CG.SOURCE_OBJECT_CODE SOURCE_OBJECT_CODE
, CT.USAGE_ITEM_ID USAGE_ITEM_ID
, IT.NAME SOURCE_DETAILS
, CII.SERIAL_NUMBER CURRENT_SERIAL_NUMBER
, TO_CHAR(CII.INSTANCE_NUMBER) REFERENCE_NUMBER
, CG.TEMPLATE_FLAG
FROM OKX_COUNTER_GROUPS_V CG
, OKX_COUNTERS_V CT
, CSI_ITEM_INSTANCES CII
, OKX_SYSTEM_ITEMS_V IT
WHERE CG.COUNTER_GROUP_ID = CT.COUNTER_GROUP_ID
AND CT.USAGE_ITEM_ID IS NOT NULL
AND CG.SOURCE_OBJECT_ID = CII.INSTANCE_ID
AND CG.SOURCE_OBJECT_CODE = 'CP'
AND IT.ID1 = CII.INVENTORY_ITEM_ID
AND IT.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT'
, 'ORGANIZATION_ID') UNION 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
, CT.USAGE_ITEM_ID USAGE_ITEM_ID
, KL.NAME|| '-' ||KH.CONTRACT_NUMBER SOURCE_DETAILS
, NULL CURRENT_SERIAL_NUMBER
, NULL REFERENCE_NUMBER
, CG.TEMPLATE_FLAG
FROM OKX_COUNTER_GROUPS_V CG
, OKX_COUNTERS_V CT
, OKC_K_LINES_V KL
, OKC_K_HEADERS_V KH
WHERE CG.COUNTER_GROUP_ID = CT.COUNTER_GROUP_ID
AND CT.USAGE_ITEM_ID IS NOT NULL
AND CG.SOURCE_OBJECT_ID = KL.ID
AND CG.SOURCE_OBJECT_CODE = 'CONTRACT_LINE'
AND KH.ID = KL.DNZ_CHR_ID