ECC Lease Contracts, Manual Rebooks

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