ECC Service Contracts, Service Contract Counter Details

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Contract Id, Contract, Line, Subline, Name, Source Dtls, Group Name, Counter Type, Reading Date ...
Imported from Enterprise Command Center
Dataset Key: oks-counter
Query Procedure: OKS_ECC_UTIL_PVT.get_ecc_data_load_info
Security Procedure:
select
x.*
from
(
select * from (SELECT
 /*+ leading(OKS_K_COUNTERS_ECC_V.hdr)
 index(OKS_K_COUNTERS_ECC_V.hdr OKC_K_HEADERS_ALL_B_N4) */
ECC_SPEC_ID,
LANGUAGE_CODE,
CONTRACT_ID,
CONTRACT,
LINE,
SUBLINE,
NAME,
SOURCE_DTLS,
COUNTER_NAME,
GROUP_NAME,
COUNTER_TYPE,
READING_DATE,
LATEST_READING,
READING_TYPE,
SERIAL_NUMBER,
INSTANCE_NUMBER,
UOM_CODE,
AUTOMATIC_ROLLOVER,
ROLLOVER_LAST_READING,
ROLLOVER_FIRST_READING,
USAGE_ITEM,
START_DATE_ACTIVE,
END_DATE_ACTIVE,
SUB_LINE_ID,
SOURCE_OBJECT_ID,
SOURCE_OBJECT_CODE,
COUNTER_ID,
NET_READING,
METER_ATTENTION
 FROM OKS_K_COUNTERS_ECC_V WHERE ((
                 language_code in ('US'))))
 pivot
(
max(COUNTER_NAME)	as	COUNTER_NAME,
max(READING_TYPE) as READING_TYPE
  for language_code in ('US' "US"))
) x
where
2=2