ONT Credit Exposure

Description
Categories: BI Publisher, Sales
Application: Order Management
Source: Credit Exposure Report (XML)
Short Name: OEXCEXP_XML
DB package: ONT_OEXCEXP_XMLP_PKG
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
Parameter Name SQL text Validation
ONT_CC_EXC_REP_DUMMY3
 
ONT_CC_EXC_REP_DUMMY2
 
ONT_CC_EXC_REP_DUMMY1
 
Credit Check Rule
 
LOV Oracle
To
 
LOV Oracle
Customer Numbers From
 
LOV Oracle
To
 
LOV Oracle
Customer Names From
 
LOV Oracle
To
 
LOV Oracle
Customer Profile Classes From
 
LOV Oracle
To
 
LOV Oracle
Party Numbers From
 
LOV Oracle
To
 
LOV Oracle
Party Names From
 
LOV Oracle
Party Number
 
LOV Oracle
Party Name
 
LOV Oracle
Report By
 
LOV Oracle