ECC Lease Contracts, Manual Rebooks
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Description: Contract Rebooks
Dataset Key: okl-cv-rebooks
Query Procedure: OKL_CV_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
Description: Contract Rebooks
Dataset Key: okl-cv-rebooks
Query Procedure: OKL_CV_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 rcpt_v.*, okl_accounting_util.get_lookup_meaning_lang('OKL_REBOOK_REASON', rcpt_v.REVISION_REASON, 540, 0, rcpt_v.language) revision_reason_meaning, okl_accounting_util.get_lookup_meaning_lang('OKL_SNAP_REVISION_SOURCE', rcpt_v.REBOOK_SOURCE, 540, 0, rcpt_v.language) rebook_Source_meaning, decode(rcpt_v.chr_sts_code,'TERMINATED','Y','EXPIRED','Y','N') terminated_flag FROM OKL_ECC_MANL_REBOOKS_V rcpt_v, okl_ecc_cv_process_t process_t WHERE rcpt_v.khr_id = process_t.khr_id AND process_t.incremental_flag = 'N' AND rcpt_v.language in ('US')) PIVOT (MAX(OPERATING_UNIT) as OPERATING_UNIT, MAX(REVISION_TYPE) as REVISION_TYPE, MAX(REVISION_REASON_MEANING) as REVISION_REASON_MEANING, MAX(REBOOK_SOURCE_MEANING) as REBOOK_SOURCE_MEANING, MAX(CHR_STS_MEANING) AS CHR_STS_MEANING, MAX(REVISION_CONTRCT_STATUS) AS REVISION_CONTRCT_STATUS, MAX(CONTRACT_DESCRIPTION) AS CONTRACT_DESCRIPTION for LANGUAGE in ('US' "US")) ) x where 2=2 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV |