ECC Lease Contracts, Assets
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Description: Contract Assets
Dataset Key: okl-cv-ctr-assets
Query Procedure: OKL_CV_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
Description: Contract Assets
Dataset Key: okl-cv-ctr-assets
Query Procedure: OKL_CV_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
Run
ECC Lease Contracts, Assets and other Oracle EBS reports with Blitz Report™ on our demo environment
select x.* from ( SELECT * from (SELECT rcpt_v.*, decode(rcpt_v.asset_status_code,'TERMINATED','Y','EXPIRED','Y','N') terminated_flag FROM OKL_ECC_CV_ASSET_LINES_V rcpt_v, okl_ecc_cv_process_t process_t WHERE rcpt_v.dnz_chr_id = process_t.khr_id AND process_t.incremental_flag = 'N' AND language in ('US') ) PIVOT (MAX(ASSET_NUMBER) as ASSET_NUMBER , MAX(OPERATING_UNIT) as OPERATING_UNIT, MAX(ITEM) AS ITEM, MAX(DESCRIPTION) as DESCRIPTION, MAX(VERSION_NUMBER) as VERSION_NUMBER for LANGUAGE in ('US' "US")) ) x where 2=2 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV |