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:
Run ECC Lease Contracts, Manual Rebooks and other Oracle EBS reports with Blitz Report™ on our demo environment
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
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV