ECC Service Contracts, Service Contract Counter Details
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:
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 |