ECC Service Contracts, Service Contract Counter Details

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