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:

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 Avalara VAT listing 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 LinesData ECC Service Contracts, Service Contract Contact Details RK: AR Transactions and Lines
Blitz Report™

Blitz Report™ provides multiple benefits: