ECC Lease Contracts, Assets

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