ECC Service Contracts, Service Contract Counter Details

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: oks-counter
Query Procedure: OKS_ECC_UTIL_PVT.get_ecc_data_load_info
Security Procedure:
Run ECC Service Contracts, Service Contract Counter Details and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
 
Related Blitz Reports
ECC Lease Contracts, Lease Meter Errors ECC Service Contracts, Service Contract Contact Details ECC Service Contracts, Service Contract Sales Credit Details ECC Service Contracts, Service Contract Customer Details ECC Service Contracts, Service Contract Renewal Details ECC Service Contracts, Service Contract Details Avalara VAT listing Avalara VAT LinesData RK: AR Transactions and Lines
Blitz Report™

Blitz Report™ provides multiple benefits: