ONT Credit Exposure

SELECT 
party_level  party_level1 
,party_name  party_name_cust
, customer_name customer_name_cust
,customer_id customer_id_cust
,base_currency base_currency_cust
,unchecked_exposure unchecked_exposure_cust
,nvl(unchecked_exposure,0) unchecked_exposure_cust1
,credit_limit_currency cr_lim_currency_cust
,cr_cur_overall_limit cr_overall_cust
,cr_cur_exposure cr_exposure_cust
,cr_cur_available cr_available_cust
,decode(base_cur_overall_limit,-1,TO_NUMBER(NULL),-2,TO_NUMBER(NULL),base_cur_overall_limit) base_overall_cust
,decode(base_cur_exposure,-1,TO_NUMBER(NULL),-2,TO_NUMBER(NULL),base_cur_exposure) base_exposure_cust
,decode(base_cur_available,-1,TO_NUMBER(NULL),-2,TO_NUMBER(NULL),base_cur_available) base_available_cust,
decode(global_exposure_flag,'Y','*',NULL) global_exp_flag_cust, 
	ONT_OEXCEXP_XMLP_PKG.cf_get_b_currency_custformula(base_currency) CF_get_b_currency_cust,
	ONT_OEXCEXP_XMLP_PKG.CP_base_currency_cust_p CP_base_currency_cust, 
--	ONT_OEXCEXP_XMLP_PKG.cf_total_unchecked_exp_custfor(:CS_total_exp_and_unch, unchecked_exposure)
--    CF_TOTAL_unchecked_exp_cust, 
--	ONT_OEXCEXP_XMLP_PKG.cf_total_avail_party_custformu(:CS_total_overall_cust) CF_total_avail_party_cust,
	ONT_OEXCEXP_XMLP_PKG.CP_total_unchecked_exp_cust_p CP_total_unchecked_exp_cust,
	ONT_OEXCEXP_XMLP_PKG.CP_total_avail_party_cust_p CP_total_avail_party_cust, 
	ONT_OEXCEXP_XMLP_PKG.cf_get_exp_and_unchformula(decode ( base_cur_exposure , - 1 , TO_NUMBER ( NULL ) , - 2 , TO_NUMBER ( NULL ) , base_cur_exposure )) CF_get_exp_and_unch,
	ONT_OEXCEXP_XMLP_PKG.CP_exp_and_unchecked_p CP_exp_and_unchecked
FROM oe_credit_exposure_temp
WHERE party_parent_id=NVL(:P_SPECIFIC_PARTY_ID,:P_SPEC_PARTY_NUM_ID)  
AND bill_to_site_id IS NULL
AND party_id IS NOT NULL
AND customer_id IS NOT NULL
 order by 1