ECC Lease Contracts, Payments

select
x.*
from
(
select * from (SELECT /*+ leading(t) push_pred(oep) */  rgp_lalevl_id
				|| '-'||version_code||'-'
				|| chr_id||'-'||nvl(stub_amount,0)||start_Date ecc_spec_id
			   ,rgp_lalevl_id
			   ,chr_id contract_id
			   ,(select org_id from okc_k_headers_all_b where id = chr_id) org_id
			   ,major_version version_number
			   ,contract_number
			   ,cle_id
			   ,lse_id
			   ,parent_cle_id
			   ,rul_laslh_id
			   ,okl_cv_ecc_util_pvt.get_fee_service_name (chr_id
														 ,cle_id
														 ,lse_id
														 ,parent_cle_id
														 ,language) fee_or_service
			   ,okl_deal_payments_pvt.get_asset_number (chr_id
													   ,cle_id
													   ,lse_id) asset_number
			   ,sty_id
			   ,sty_name
			   ,start_date
			   ,frequency_code
			   ,frequency_name
			   ,structure_code
			   ,structure_name
			   ,arrears_yn
			   ,arrears_yn_name
		           ,periods
		          ,periodic_amount
			  /* ,decode (count_sll
					   ,1
					   ,periods
					   ,okl_lla_util_pvt.get_lookup_meaning ('OKL_LA_PAYMENT_PERIODS'
															,'MULTIPLE')) periods
			   ,decode (count_sll
					   ,1
					   ,periodic_amount
					   ,NULL) periodic_amount*/
			   ,count_sll
			   ,currency_code
			   ,decode (interim_payment_amount
					   ,0
					   ,NULL
					   ,okl_accounting_util.format_amount (interim_payment_amount
														  ,currency_code)) interim_payment_amount
			   ,to_date (decode (interim_start_date
								,to_date ('1'
										 ,'j')
								,NULL
								,interim_start_date)) interim_start_date
			   ,okl_accounting_util.format_amount (evg_payment_amount
												  ,currency_code) evg_payment_amount
			   ,okl_lla_util_pvt.get_lookup_meaning ('OKL_FREQUENCY'
													,evg_frequency_code) evg_pay_freq_name,
			   language,
		           stub_days,
		           stub_amount
		FROM    OKL_ECC_CV_PAYMENTS_V oep,okl_ecc_cv_process_t t
		where   oep.language in ('US') and oep.chr_id = t.khr_id)
				PIVOT
				  (
				   MAX(FREQUENCY_NAME) AS FREQUENCY_NAME ,
				   MAX(STRUCTURE_NAME) AS STRUCTURE_NAME ,
				   MAX(ARREARS_YN_NAME) AS ARREARS_YN_NAME ,
				   MAX(STY_NAME) AS STY_NAME,
                                   MAX(VERSION_NUMBER) AS VERSION_NUMBER
				   for LANGUAGE in ('US' "US"))
) x
where
2=2