Introduction

This Post illustrates steps required to Report will fetch and display all customer credit card snapshot details in excel format in Oracle EBS R12.

Data Defination

<?xml version=”1.0″ encoding=”UTF-8″?>
<!– $Header: ARXCCS_XML.xml 120.0 2007/12/27 15:07:07 abraghun noship $ –>
<!– dbdrv: exec java oracle/apps/xdo/oa/util XDOLoader.class java &phase=dat checkfile:~PROD:patch/115/publisher/defs:ARXCCS_XML.xml UPLOAD -DB_USERNAME &un_apps -DB_PASSWORD &pw_apps -JDBC_CONNECTION &jdbc_db_addr -LOB_TYPE DATA_TEMPLATE -APPS_SHORT_NAME ~PROD -LOB_CODE ARXCCS_XML -LANGUAGE 00 -XDO_FILE_TYPE XML-DATA-TEMPLATE -FILE_NAME &fullpath:~PROD:patch/115/publisher/defs:ARXCCS_XML.xml –>
<!– GSCC_Category=”Xdo Data Definition” –>
<dataTemplate name=”ARXCCS” defaultPackage=”AR_ARXCCS_XMLP_PKG” version=”1.0″>
<properties>
<property name=”xml_tag_case” value=”upper” />
</properties>
<parameters>
<parameter name=”P_CONC_REQUEST_ID” dataType=”number” defaultValue=”0″></parameter>
<parameter name=”P_CUSTOMER_NUMBER_LOW” dataType=”character”></parameter>
<parameter name=”P_CUSTOMER_NUMBER_HIGH” dataType=”character”></parameter>
<parameter name=”P_CUSTOMER_NAME_LOW” dataType=”character”></parameter>
<parameter name=”P_CUSTOMER_NAME_HIGH” dataType=”character”></parameter>
<parameter name=”P_BUCKET_NAME_LOW” dataType=”character” defaultValue=”Credit Snapshot”></parameter>
<parameter name=”P_BUCKET_NAME_HIGH” dataType=”character” defaultValue=”Credit SnapShot”></parameter>
<parameter name=”P_COLLECTOR_LOW” dataType=”character”></parameter>
<parameter name=”P_COLLECTOR_HIGH” dataType=”character”></parameter>
<!–<parameter name=”LP_CUSTOMER_NAME_LOW” dataType = “character”></parameter>
<parameter name=”LP_CUSTOMER_NAME_HIGH” dataType = “character”></parameter>
<parameter name=”LP_CUSTOMER_NUMBER_LOW” dataType = “character”></parameter>
<parameter name=”LP_CUSTOMER_NUMBER_HIGH” dataType = “character”></parameter>
<parameter name=”P_COLLECTOR_MAX” dataType = “character”></parameter>
<parameter name=”P_COLLECTOR_MIN” dataType = “character”></parameter>–>
<!–<parameter name=”LP_COLL_NAME_LOW” dataType = “character”></parameter>
<parameter name=”LP_COLL_NAME_HIGH” dataType = “character”></parameter>–>
<parameter name=”P_ATRATE” dataType=”character” defaultValue=”X”></parameter>
<!–<parameter name=”P_ORG_WHERE_AD” dataType = “character”></parameter>
<parameter name=”P_ORG_WHERE_PS” dataType = “character”></parameter>
<parameter name=”P_ORG_WHERE_SU” dataType = “character”></parameter>–>
<parameter name=”P_REPORTING_ENTITY_ID” dataType=”number”></parameter>
<!–<parameter name=”P_REPORTING_ENTITY_NAME” dataType = “character”></parameter>–>
<parameter name=”P_REPORTING_LEVEL” dataType=”character” defaultValue=”1″></parameter>
<!–<parameter name=”P_REPORTING_LEVEL_NAME” dataType = “character”></parameter>
<parameter name=”P_ORG_WHERE_PARAM” dataType = “character”></parameter>–>
</parameters>
<lexicals></lexicals>
<dataQuery>
<sqlStatement name=”Q_SETUP”><![CDATA[
SELECT param.org_id setup_org_id,
sob.name Company_Name,
sob.chart_of_accounts_id coa_id,
sob.currency_code Functional_Currency,
cur.precision Functional_Currency_Precision,
AR_ARXCCS_XMLP_PKG.report_nameformula(sob.name) Report_Name
FROM gl_sets_of_books sob,
ar_system_parameters_all param,
fnd_currencies cur
WHERE sob.set_of_books_id = param.set_of_books_id
AND sob.currency_code = cur.currency_code
&p_org_where_param
]]></sqlStatement>
<sqlStatement name=”Q_CUST”><![CDATA[
select :setup_org_id qcust_org_id,
cust_acct.cust_account_id Customer_id,
cust_acct.account_number Customer_Number,
substrb(party.party_name,1,50) Customer_Name,
round((trunc(sysdate) – cust_acct.creation_date)/365,1) Customer_Age,
round((trunc(sysdate) – acct_site.creation_date)/365,1) Address_Age,
acct_site.cust_acct_site_id Address_id,
loc.address1 Address1 ,
loc.address2 Address2 ,
loc.address3 Address3 ,
loc.address4 Address4 ,
decode(loc.city, NULL, NULL, loc.city || ‘,’) City,
nvl(loc.state, loc.province) State,
loc.postal_code Postal_Code,
terr.territory_short_name Country,
site_uses.site_use_id Site_Use_id,
site_uses.location Location,
cp.cust_account_profile_id Customer_Profile_Id,
AR_ARXCCS_XMLP_PKG.c_last_credit_memo_formulaform(:FUNCTIONAL_CURRENCY,cust_acct.cust_account_id, site_uses.site_use_id) C_LAST_CREDIT_MEMO_FORMULA,
AR_ARXCCS_XMLP_PKG.c_data_not_foundformula(substrb ( party.party_name , 1 , 50 )) C_DATA_NOT_FOUND,
AR_ARXCCS_XMLP_PKG.c_customer_ageformula(round ( ( trunc ( sysdate ) – cust_acct.creation_date ) / 365 , 1 )) c_customer_age,
AR_ARXCCS_XMLP_PKG.sel_contactformula(acct_site.cust_acct_site_id) Sel_Contact,
AR_ARXCCS_XMLP_PKG.c_address_ageformula(round ( ( trunc ( sysdate ) – acct_site.creation_date ) / 365 , 1 )) c_address_age,
AR_ARXCCS_XMLP_PKG.c_city_state_zipformula(decode ( loc.city , NULL , NULL , loc.city || ‘,’ ), nvl ( loc.state , loc.province ), loc.postal_code) c_city_state_zip,
AR_ARXCCS_XMLP_PKG.c_credit_summaryformula(cust_acct.cust_account_id, site_uses.site_use_id) C_CREDIT_SUMMARY,
AR_ARXCCS_XMLP_PKG.c_last_invoice_formulaformula(:FUNCTIONAL_CURRENCY, cust_acct.cust_account_id, site_uses.site_use_id) C_LAST_INVOICE_FORMULA,
–AR_ARXCCS_XMLP_PKG.c_last_credit_memo_formulaform(cust_acct.cust_account_id, site_uses.site_use_id) –C_LAST_CREDIT_MEMO_FORMULA,
AR_ARXCCS_XMLP_PKG.c_guarantee_formulaformula(:FUNCTIONAL_CURRENCY, cust_acct.cust_account_id, site_uses.site_use_id) C_GUARANTEE_FORMULA,
AR_ARXCCS_XMLP_PKG.c_last_deposit_formulaformula(:FUNCTIONAL_CURRENCY, cust_acct.cust_account_id, site_uses.site_use_id) C_LAST_DEPOSIT_FORMULA,
AR_ARXCCS_XMLP_PKG.c_last_dm_formulaformula(:FUNCTIONAL_CURRENCY, cust_acct.cust_account_id, site_uses.site_use_id) C_LAST_DM_FORMULA,
AR_ARXCCS_XMLP_PKG.c_last_cb_formulaformula(:FUNCTIONAL_CURRENCY, cust_acct.cust_account_id, site_uses.site_use_id) C_LAST_CB_FORMULA,
AR_ARXCCS_XMLP_PKG.c_last_payment_formulaformula(:FUNCTIONAL_CURRENCY, cust_acct.cust_account_id, site_uses.site_use_id) C_LAST_PAYMENT_FORMULA,
AR_ARXCCS_XMLP_PKG.c_last_adj_formulaformula(:FUNCTIONAL_CURRENCY, cust_acct.cust_account_id, site_uses.site_use_id) C_LAST_ADJ_FORMULA,
AR_ARXCCS_XMLP_PKG.c_last_writeoff_formulaformula(:FUNCTIONAL_CURRENCY, cust_acct.cust_account_id, site_uses.site_use_id) C_LAST_WRITEOFF_FORMULA,
AR_ARXCCS_XMLP_PKG.c_last_statement_formulaformul(cust_acct.cust_account_id, site_uses.site_use_id) C_LAST_STATEMENT_FORMULA,
AR_ARXCCS_XMLP_PKG.c_last_dn_formulaformula(cust_acct.cust_account_id, site_uses.site_use_id) C_LAST_DN_FORMULA,
AR_ARXCCS_XMLP_PKG.c_last_nsf_formulaformula(:FUNCTIONAL_CURRENCY, cust_acct.cust_account_id, site_uses.site_use_id) C_LAST_NSF_FORMULA,
AR_ARXCCS_XMLP_PKG.c_last_contact_formulaformula(:FUNCTIONAL_CURRENCY, cust_acct.cust_account_id, site_uses.site_use_id) C_LAST_CONTACT_FORMULA,
AR_ARXCCS_XMLP_PKG.c_last_hold_formulaformula(cust_acct.cust_account_id, site_uses.site_use_id) C_LAST_HOLD_FORMULA,
AR_ARXCCS_XMLP_PKG.C_Contact_p C_Contact,
AR_ARXCCS_XMLP_PKG.C_Phone_Number_p C_Phone_Number,
AR_ARXCCS_XMLP_PKG.c_profile_site_use_id_p c_profile_site_use_id,
AR_ARXCCS_XMLP_PKG.c_customer_profile_id_p c_customer_profile_id,
AR_ARXCCS_XMLP_PKG.c_cred_summ_collector_p c_cred_summ_collector,
AR_ARXCCS_XMLP_PKG.c_cred_summ_exempt_dun_p c_cred_summ_exempt_dun,
AR_ARXCCS_XMLP_PKG.c_cred_summ_terms_p c_cred_summ_terms,
AR_ARXCCS_XMLP_PKG.c_cred_summ_account_status_p c_cred_summ_account_status,
AR_ARXCCS_XMLP_PKG.c_cred_summ_credit_hold_p c_cred_summ_credit_hold,
AR_ARXCCS_XMLP_PKG.c_cred_summ_risk_code_p c_cred_summ_risk_code,
AR_ARXCCS_XMLP_PKG.c_cred_summ_credit_rating_p c_cred_summ_credit_rating,
AR_ARXCCS_XMLP_PKG.c_cred_summ_limit_tolerance_p c_cred_summ_limit_tolerance,
–AR_ARXCCS_XMLP_PKG.c_cred_summ_limit_expire_date c_cred_summ_limit_expire_date,
AR_ARXCCS_XMLP_PKG.c_cred_summ_lt_exp_date_p c_cred_summ_limit_expire_date,
AR_ARXCCS_XMLP_PKG.c_last_invoice_days_since_p c_last_invoice_days_since,
AR_ARXCCS_XMLP_PKG.c_last_invoice_date_p c_last_invoice_date,
AR_ARXCCS_XMLP_PKG.c_last_invoice_converted_p c_last_invoice_converted,
AR_ARXCCS_XMLP_PKG.c_last_invoice_amount_p c_last_invoice_amount,
AR_ARXCCS_XMLP_PKG.c_last_invoice_currency_p c_last_invoice_currency,
AR_ARXCCS_XMLP_PKG.c_last_invoice_type_p c_last_invoice_type,
AR_ARXCCS_XMLP_PKG.c_last_invoice_number_p c_last_invoice_number,
AR_ARXCCS_XMLP_PKG.c_last_cm_rel_invoice_p c_last_cm_rel_invoice,
AR_ARXCCS_XMLP_PKG.c_last_cm_converted_p c_last_cm_converted,
AR_ARXCCS_XMLP_PKG.c_last_cm_amount_p c_last_cm_amount,
AR_ARXCCS_XMLP_PKG.c_last_cm_id_p c_last_cm_id,
AR_ARXCCS_XMLP_PKG.c_last_cm_prev_trx_p c_last_cm_prev_trx,
AR_ARXCCS_XMLP_PKG.c_last_cm_days_since_p c_last_cm_days_since,
AR_ARXCCS_XMLP_PKG.c_last_cm_date_p c_last_cm_date,
AR_ARXCCS_XMLP_PKG.c_last_cm_currency_p c_last_cm_currency,
AR_ARXCCS_XMLP_PKG.c_last_cm_type_p c_last_cm_type,
AR_ARXCCS_XMLP_PKG.c_last_guar_days_since_p c_last_guar_days_since,
AR_ARXCCS_XMLP_PKG.c_last_guar_date_p c_last_guar_date,
AR_ARXCCS_XMLP_PKG.c_last_guar_converted_p c_last_guar_converted,
AR_ARXCCS_XMLP_PKG.c_last_guar_amount_p c_last_guar_amount,
AR_ARXCCS_XMLP_PKG.c_last_guar_currency_p c_last_guar_currency,
AR_ARXCCS_XMLP_PKG.c_last_guar_type_p c_last_guar_type,
AR_ARXCCS_XMLP_PKG.c_last_guar_number_p c_last_guar_number,
AR_ARXCCS_XMLP_PKG.c_last_dep_days_since_p c_last_dep_days_since,
AR_ARXCCS_XMLP_PKG.c_last_dep_date_p c_last_dep_date,
AR_ARXCCS_XMLP_PKG.c_last_dep_converted_p c_last_dep_converted,
AR_ARXCCS_XMLP_PKG.c_last_dep_amount_p c_last_dep_amount,
AR_ARXCCS_XMLP_PKG.c_last_dep_currency_p c_last_dep_currency,
AR_ARXCCS_XMLP_PKG.c_last_dep_type_p c_last_dep_type,
AR_ARXCCS_XMLP_PKG.c_last_dep_number_p c_last_dep_number,
AR_ARXCCS_XMLP_PKG.c_last_dm_days_since_p c_last_dm_days_since,
AR_ARXCCS_XMLP_PKG.c_last_dm_date_p c_last_dm_date,
AR_ARXCCS_XMLP_PKG.c_last_dm_converted_p c_last_dm_converted,
AR_ARXCCS_XMLP_PKG.c_last_dm_amount_p c_last_dm_amount,
AR_ARXCCS_XMLP_PKG.c_last_dm_currency_p c_last_dm_currency,
AR_ARXCCS_XMLP_PKG.c_last_dm_type_p c_last_dm_type,
AR_ARXCCS_XMLP_PKG.c_last_dm_number_p c_last_dm_number,
AR_ARXCCS_XMLP_PKG.c_last_cb_days_since_p c_last_cb_days_since,
AR_ARXCCS_XMLP_PKG.c_last_cb_date_p c_last_cb_date,
AR_ARXCCS_XMLP_PKG.c_last_cb_converted_p c_last_cb_converted,
AR_ARXCCS_XMLP_PKG.c_last_cb_amount_p c_last_cb_amount,
AR_ARXCCS_XMLP_PKG.c_last_cb_currency_p c_last_cb_currency,
AR_ARXCCS_XMLP_PKG.c_last_cb_type_p c_last_cb_type,
AR_ARXCCS_XMLP_PKG.c_last_cm_number_p c_last_cm_number,
AR_ARXCCS_XMLP_PKG.c_last_cb_number_p c_last_cb_number,
AR_ARXCCS_XMLP_PKG.c_last_payment_rel_invoice_p c_last_payment_rel_invoice,
AR_ARXCCS_XMLP_PKG.c_last_payment_days_since_p c_last_payment_days_since,
AR_ARXCCS_XMLP_PKG.c_last_payment_date_p c_last_payment_date,
AR_ARXCCS_XMLP_PKG.c_last_payment_converted_p c_last_payment_converted,
AR_ARXCCS_XMLP_PKG.c_last_payment_amount_p c_last_payment_amount,
AR_ARXCCS_XMLP_PKG.c_last_payment_currency_p c_last_payment_currency,
AR_ARXCCS_XMLP_PKG.c_last_payment_type_p c_last_payment_type,
AR_ARXCCS_XMLP_PKG.c_last_payment_number_p c_last_payment_number,
AR_ARXCCS_XMLP_PKG.c_last_adj_days_since_p c_last_adj_days_since,
AR_ARXCCS_XMLP_PKG.c_last_adj_date_p c_last_adj_date,
AR_ARXCCS_XMLP_PKG.c_last_adj_converted_p c_last_adj_converted,
AR_ARXCCS_XMLP_PKG.c_last_adj_amount_p c_last_adj_amount,
AR_ARXCCS_XMLP_PKG.c_last_adj_currency_p c_last_adj_currency,
AR_ARXCCS_XMLP_PKG.c_last_adj_rel_invoice_p c_last_adj_rel_invoice,
AR_ARXCCS_XMLP_PKG.c_last_adj_type_p c_last_adj_type,
AR_ARXCCS_XMLP_PKG.c_last_adj_number_p c_last_adj_number,
AR_ARXCCS_XMLP_PKG.c_last_wo_days_since_p c_last_wo_days_since,
AR_ARXCCS_XMLP_PKG.c_last_wo_date_p c_last_wo_date,
AR_ARXCCS_XMLP_PKG.c_last_wo_converted_p c_last_wo_converted,
AR_ARXCCS_XMLP_PKG.c_last_wo_amount_p c_last_wo_amount,
AR_ARXCCS_XMLP_PKG.c_last_wo_currency_p c_last_wo_currency,
AR_ARXCCS_XMLP_PKG.c_last_wo_rel_invoice_p c_last_wo_rel_invoice,
AR_ARXCCS_XMLP_PKG.c_last_wo_type_p c_last_wo_type,
AR_ARXCCS_XMLP_PKG.c_last_wo_number_p c_last_wo_number,
AR_ARXCCS_XMLP_PKG.c_last_stmnt_next_trx_date_p c_last_stmnt_next_trx_date,
AR_ARXCCS_XMLP_PKG.c_last_st_date_p c_last_st_date,
AR_ARXCCS_XMLP_PKG.c_last_st_type_p c_last_st_type,
AR_ARXCCS_XMLP_PKG.c_last_st_number_p c_last_st_number,
AR_ARXCCS_XMLP_PKG.c_last_st_days_since_p c_last_st_days_since,
AR_ARXCCS_XMLP_PKG.c_last_dn_days_since_p c_last_dn_days_since,
AR_ARXCCS_XMLP_PKG.c_last_dn_date_p c_last_dn_date,
AR_ARXCCS_XMLP_PKG.c_last_dn_currency_p c_last_dn_currency,
AR_ARXCCS_XMLP_PKG.c_last_dn_amount_p c_last_dn_amount,
AR_ARXCCS_XMLP_PKG.c_last_dn_type_p c_last_dn_type,
AR_ARXCCS_XMLP_PKG.c_last_dn_number_p c_last_dn_number,
AR_ARXCCS_XMLP_PKG.c_last_nsf_currency_p c_last_nsf_currency,
AR_ARXCCS_XMLP_PKG.c_last_nsf_days_since_p c_last_nsf_days_since,
AR_ARXCCS_XMLP_PKG.c_last_nsf_date_p c_last_nsf_date,
AR_ARXCCS_XMLP_PKG.c_last_nsf_converted_p c_last_nsf_converted,
AR_ARXCCS_XMLP_PKG.c_last_nsf_amount_p c_last_nsf_amount,
AR_ARXCCS_XMLP_PKG.c_last_nsf_type_p c_last_nsf_type,
AR_ARXCCS_XMLP_PKG.c_last_nsf_number_p c_last_nsf_number,
AR_ARXCCS_XMLP_PKG.c_last_contact_days_since_p c_last_contact_days_since,
AR_ARXCCS_XMLP_PKG.c_last_contact_date_p c_last_contact_date,
AR_ARXCCS_XMLP_PKG.c_last_contact_amount_p c_last_contact_amount,
AR_ARXCCS_XMLP_PKG.c_last_contact_converted_p c_last_contact_converted,
AR_ARXCCS_XMLP_PKG.c_last_contact_currency_p c_last_contact_currency,
AR_ARXCCS_XMLP_PKG.c_last_contact_rel_invoice_p c_last_contact_rel_invoice,
AR_ARXCCS_XMLP_PKG.c_last_contact_number_p c_last_contact_number,
AR_ARXCCS_XMLP_PKG.c_last_hold_days_since_p c_last_hold_days_since,
AR_ARXCCS_XMLP_PKG.c_last_hold_date_p c_last_hold_date,
AR_ARXCCS_XMLP_PKG.c_last_hold_amount_p c_last_hold_amount,
AR_ARXCCS_XMLP_PKG.c_last_hold_number_p c_last_hold_number,
‘X’ dummy
from hz_cust_accounts cust_acct,
hz_parties party,
hz_cust_acct_sites acct_site,
hz_party_sites party_site,
hz_locations loc,
hz_cust_site_uses_all site_uses,
fnd_territories_vl terr,
ar_collectors coll,
hz_customer_profiles cp
where cp.cust_account_id = cust_acct.cust_account_id
and cust_acct.party_id = party.party_id
and cp.collector_id = coll.collector_id
and acct_site.org_id = :setup_org_id
and site_uses.status = ‘A’
&lp_customer_name_low
&lp_customer_name_high
&lp_customer_number_low
&lp_customer_number_high
&lp_coll_name_low
&lp_coll_name_high
&p_org_where_ad
&p_org_where_su
and cust_acct.cust_account_id = acct_site.cust_account_id
and site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
and acct_site.party_site_id = party_site.party_site_id
and loc.location_id = party_site.location_id
and site_uses.site_use_code = ‘BILL_TO’
and site_uses.status = ‘A’
and loc.country = terr.territory_code
and cp.cust_account_profile_id = (
select max(cp2.cust_account_profile_id)
from hz_customer_profiles cp2
where cust_acct.cust_account_id = cp2.cust_account_id
and (site_uses.site_use_id = cp2.site_use_id
or
cp2.site_use_id is null
))
order by party.party_name, site_uses.primary_flag desc, site_uses.location
]]></sqlStatement>
<sqlStatement name=”Q_BUCKET”><![CDATA[
select ps.invoice_currency_code Currency_Bucket,
sum(ps.amount_due_remaining) Aging_Balance_Outstanding,
sum(decode(:rp_bucket_line_type_0,
‘DISPUTE_ONLY’,decode(nvl(ps.amount_in_dispute,0),0,0,1),
‘PENDADJ_ONLY’,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
‘DISPUTE_PENDADJ’,decode(nvl(ps.amount_in_dispute,0),
0,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
1),
decode( greatest(:rp_bucket_days_from_0,
ceil(trunc(sysdate)-ps.due_date)),
least(:rp_bucket_days_to_0,
ceil(trunc(sysdate)-ps.due_date)),1,
0)
* decode(nvl(ps.amount_in_dispute,0), 0, 1,
decode(”,
‘DISPUTE_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1))
* decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
decode(”,
‘PENDADJ_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1)))
* ps.amount_due_remaining
* 1) Total_Cust_b0,
sum(decode(:rp_bucket_line_type_1,
‘DISPUTE_ONLY’,decode(nvl(ps.amount_in_dispute,0),0,0,1),
‘PENDADJ_ONLY’,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
‘DISPUTE_PENDADJ’,decode(nvl(ps.amount_in_dispute,0),
0,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
1),
decode( greatest(to_number(:rp_bucket_days_from_1),
ceil(trunc(sysdate)-ps.due_date)),
least(to_number(:rp_bucket_days_to_1),
ceil(trunc(sysdate)-ps.due_date)),1,
0)
* decode(nvl(ps.amount_in_dispute,0), 0, 1,
decode(”,
‘DISPUTE_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1))
* decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
decode(”,
‘PENDADJ_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1)))
* ps.amount_due_remaining
* 1) Total_Cust_b1,
sum(decode(:rp_bucket_line_type_2,
‘DISPUTE_ONLY’,decode(nvl(ps.amount_in_dispute,0),0,0,1),
‘PENDADJ_ONLY’,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
‘DISPUTE_PENDADJ’,decode(nvl(ps.amount_in_dispute,0),
0,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
1),
decode( greatest(:rp_bucket_days_from_2,
ceil(trunc(sysdate)-ps.due_date)),
least(:rp_bucket_days_to_2,
ceil(trunc(sysdate)-ps.due_date)),1,
0)
* decode(nvl(ps.amount_in_dispute,0), 0, 1,
decode(”,
‘DISPUTE_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1))
* decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
decode(”,
‘PENDADJ_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1)))
* ps.amount_due_remaining
* 1) Total_Cust_b2,
sum(decode(:rp_bucket_line_type_3,
‘DISPUTE_ONLY’,decode(nvl(ps.amount_in_dispute,0),0,0,1),
‘PENDADJ_ONLY’,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
‘DISPUTE_PENDADJ’,decode(nvl(ps.amount_in_dispute,0),
0,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
1),
decode( greatest(:rp_bucket_days_from_3,
ceil(trunc(sysdate)-ps.due_date)),
least(:rp_bucket_days_to_3,
ceil(trunc(sysdate)-ps.due_date)),1,
0)
* decode(nvl(ps.amount_in_dispute,0), 0, 1,
decode(”,
‘DISPUTE_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1))
* decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
decode(”,
‘PENDADJ_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1)))
* ps.amount_due_remaining
* 1) Total_Cust_b3,
sum(decode(:rp_bucket_line_type_4,
‘DISPUTE_ONLY’,decode(nvl(ps.amount_in_dispute,0),0,0,1),
‘PENDADJ_ONLY’,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
‘DISPUTE_PENDADJ’,decode(nvl(ps.amount_in_dispute,0),
0,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
1),
decode( greatest(:rp_bucket_days_from_4,
ceil(trunc(sysdate)-ps.due_date)),
least(:rp_bucket_days_to_4,
ceil(trunc(sysdate)-ps.due_date)),1,
0)
* decode(nvl(ps.amount_in_dispute,0), 0, 1,
decode(”,
‘DISPUTE_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1))
* decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
decode(”,
‘PENDADJ_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1)))
* ps.amount_due_remaining
* 1) Total_Cust_b4,
sum(decode(:rp_bucket_line_type_5,
‘DISPUTE_ONLY’,decode(nvl(ps.amount_in_dispute,0),0,0,1),
‘PENDADJ_ONLY’,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
‘DISPUTE_PENDADJ’,decode(nvl(ps.amount_in_dispute,0),
0,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
1),
decode( greatest(:rp_bucket_days_from_5,
ceil(trunc(sysdate)-ps.due_date)),
least(:rp_bucket_days_to_5,
ceil(trunc(sysdate)-ps.due_date)),1,
0)
* decode(nvl(ps.amount_in_dispute,0), 0, 1,
decode(”,
‘DISPUTE_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1))
* decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
decode(”,
‘PENDADJ_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1)))
* ps.amount_due_remaining
* 1) Total_Cust_b5,
sum(decode(:rp_bucket_line_type_6,
‘DISPUTE_ONLY’,decode(nvl(ps.amount_in_dispute,0),0,0,1),
‘PENDADJ_ONLY’,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
‘DISPUTE_PENDADJ’,decode(nvl(ps.amount_in_dispute,0),
0,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
1),
decode( greatest(:rp_bucket_days_from_6,
ceil(trunc(sysdate)-ps.due_date)),
least(:rp_bucket_days_to_6,
ceil(trunc(sysdate)-ps.due_date)),1,
0)
* decode(nvl(ps.amount_in_dispute,0), 0, 1,
decode(”,
‘DISPUTE_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1))
* decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
decode(”,
‘PENDADJ_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1)))
* ps.amount_due_remaining
* 1) Total_Cust_b6,
max(decode(ps.invoice_currency_code, :functional_currency, NULL,
decode(ps.exchange_rate, NULL, ‘*’, NULL))) Aging_Convert_Bucket
, ps.customer_id ps_customer
, ps.Customer_site_use_id ps_site,
–AR_ARXCCS_XMLP_PKG.c_calc_percentformula() C_CALC_PERCENT,
AR_ARXCCS_XMLP_PKG.C_CALC_PERCENTFormula(sum(ps.amount_due_remaining),sum(decode(:rp_bucket_line_type_0,
‘DISPUTE_ONLY’,decode(nvl(ps.amount_in_dispute,0),0,0,1),
‘PENDADJ_ONLY’,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
‘DISPUTE_PENDADJ’,decode(nvl(ps.amount_in_dispute,0),
0,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
1),
decode( greatest(:rp_bucket_days_from_0,
ceil(trunc(sysdate)-ps.due_date)),
least(:rp_bucket_days_to_0,
ceil(trunc(sysdate)-ps.due_date)),1,
0)
* decode(nvl(ps.amount_in_dispute,0), 0, 1,
decode(”,
‘DISPUTE_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1))
* decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
decode(”,
‘PENDADJ_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1)))
* ps.amount_due_remaining
* 1), sum(decode(:rp_bucket_line_type_1,
‘DISPUTE_ONLY’,decode(nvl(ps.amount_in_dispute,0),0,0,1),
‘PENDADJ_ONLY’,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
‘DISPUTE_PENDADJ’,decode(nvl(ps.amount_in_dispute,0),
0,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
1),
decode( greatest(to_number(:rp_bucket_days_from_1),
ceil(trunc(sysdate)-ps.due_date)),
least(to_number(:rp_bucket_days_to_1),
ceil(trunc(sysdate)-ps.due_date)),1,
0)
* decode(nvl(ps.amount_in_dispute,0), 0, 1,
decode(”,
‘DISPUTE_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1))
* decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
decode(”,
‘PENDADJ_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1)))
* ps.amount_due_remaining
* 1),sum(decode(:rp_bucket_line_type_2,
‘DISPUTE_ONLY’,decode(nvl(ps.amount_in_dispute,0),0,0,1),
‘PENDADJ_ONLY’,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
‘DISPUTE_PENDADJ’,decode(nvl(ps.amount_in_dispute,0),
0,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
1),
decode( greatest(:rp_bucket_days_from_2,
ceil(trunc(sysdate)-ps.due_date)),
least(:rp_bucket_days_to_2,
ceil(trunc(sysdate)-ps.due_date)),1,
0)
* decode(nvl(ps.amount_in_dispute,0), 0, 1,
decode(”,
‘DISPUTE_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1))
* decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
decode(”,
‘PENDADJ_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1)))
* ps.amount_due_remaining
* 1), sum(decode(:rp_bucket_line_type_3,
‘DISPUTE_ONLY’,decode(nvl(ps.amount_in_dispute,0),0,0,1),
‘PENDADJ_ONLY’,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
‘DISPUTE_PENDADJ’,decode(nvl(ps.amount_in_dispute,0),
0,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
1),
decode( greatest(:rp_bucket_days_from_3,
ceil(trunc(sysdate)-ps.due_date)),
least(:rp_bucket_days_to_3,
ceil(trunc(sysdate)-ps.due_date)),1,
0)
* decode(nvl(ps.amount_in_dispute,0), 0, 1,
decode(”,
‘DISPUTE_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1))
* decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
decode(”,
‘PENDADJ_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1)))
* ps.amount_due_remaining
* 1), sum(decode(:rp_bucket_line_type_4,
‘DISPUTE_ONLY’,decode(nvl(ps.amount_in_dispute,0),0,0,1),
‘PENDADJ_ONLY’,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
‘DISPUTE_PENDADJ’,decode(nvl(ps.amount_in_dispute,0),
0,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
1),
decode( greatest(:rp_bucket_days_from_4,
ceil(trunc(sysdate)-ps.due_date)),
least(:rp_bucket_days_to_4,
ceil(trunc(sysdate)-ps.due_date)),1,
0)
* decode(nvl(ps.amount_in_dispute,0), 0, 1,
decode(”,
‘DISPUTE_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1))
* decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
decode(”,
‘PENDADJ_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1)))
* ps.amount_due_remaining
* 1), sum(decode(:rp_bucket_line_type_5,
‘DISPUTE_ONLY’,decode(nvl(ps.amount_in_dispute,0),0,0,1),
‘PENDADJ_ONLY’,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
‘DISPUTE_PENDADJ’,decode(nvl(ps.amount_in_dispute,0),
0,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
1),
decode( greatest(:rp_bucket_days_from_5,
ceil(trunc(sysdate)-ps.due_date)),
least(:rp_bucket_days_to_5,
ceil(trunc(sysdate)-ps.due_date)),1,
0)
* decode(nvl(ps.amount_in_dispute,0), 0, 1,
decode(”,
‘DISPUTE_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1))
* decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
decode(”,
‘PENDADJ_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1)))
* ps.amount_due_remaining
* 1),sum(decode(:rp_bucket_line_type_6,
‘DISPUTE_ONLY’,decode(nvl(ps.amount_in_dispute,0),0,0,1),
‘PENDADJ_ONLY’,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
‘DISPUTE_PENDADJ’,decode(nvl(ps.amount_in_dispute,0),
0,decode(nvl(ps.amount_adjusted_pending,0),0,0,1),
1),
decode( greatest(:rp_bucket_days_from_6,
ceil(trunc(sysdate)-ps.due_date)),
least(:rp_bucket_days_to_6,
ceil(trunc(sysdate)-ps.due_date)),1,
0)
* decode(nvl(ps.amount_in_dispute,0), 0, 1,
decode(”,
‘DISPUTE_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1))
* decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
decode(”,
‘PENDADJ_ONLY’, 0, ‘DISPUTE_PENDADJ’, 0,
1)))
* ps.amount_due_remaining
* 1)) C_CALC_PERCENT,
AR_ARXCCS_XMLP_PKG.c_compute_amtformula(:FUNCTIONAL_CURRENCY, :CUSTOMER_ID, :SITE_USE_ID, ps.invoice_currency_code, sum ( ps.amount_due_remaining )) C_COMPUTE_AMT,
AR_ARXCCS_XMLP_PKG.c_high_inv_formulaformula(:FUNCTIONAL_CURRENCY, :CUSTOMER_ID, :SITE_USE_ID, ps.invoice_currency_code) C_HIGH_INV_FORMULA,
AR_ARXCCS_XMLP_PKG.c_cust_hist_high_limit_amtform(:CUSTOMER_ID, :SITE_USE_ID) c_cust_hist_high_limit_amt,
AR_ARXCCS_XMLP_PKG.c_rolling_summary_calcformula(:FUNCTIONAL_CURRENCY, :CUSTOMER_ID, :SITE_USE_ID, ps.invoice_currency_code) C_ROLLING_SUMMARY_CALC,
AR_ARXCCS_XMLP_PKG.c_currency_lookupformula(:SITE_USE_ID, ps.invoice_currency_code) C_currency_lookup,
AR_ARXCCS_XMLP_PKG.CP_DEFAULT_FLAG_p CP_DEFAULT_FLAG,
AR_ARXCCS_XMLP_PKG.c_percent_b0_p c_percent_b0,
AR_ARXCCS_XMLP_PKG.c_percent_b1_p c_percent_b1,
AR_ARXCCS_XMLP_PKG.c_percent_b2_p c_percent_b2,
AR_ARXCCS_XMLP_PKG.c_percent_b3_p c_percent_b3,
AR_ARXCCS_XMLP_PKG.c_percent_b4_p c_percent_b4,
AR_ARXCCS_XMLP_PKG.c_percent_b5_p c_percent_b5,
AR_ARXCCS_XMLP_PKG.c_percent_b6_p c_percent_b6,
AR_ARXCCS_XMLP_PKG.c_aging_on_account_p c_aging_on_account,
AR_ARXCCS_XMLP_PKG.c_aging_unapplied_p c_aging_unapplied,
AR_ARXCCS_XMLP_PKG.c_aging_convert_on_account_p c_aging_convert_on_account,
AR_ARXCCS_XMLP_PKG.c_aging_convert_unapplied_p c_aging_convert_unapplied,
AR_ARXCCS_XMLP_PKG.c_aging_credit_p c_aging_credit,
AR_ARXCCS_XMLP_PKG.c_aging_convert_credit_p c_aging_convert_credit,
AR_ARXCCS_XMLP_PKG.c_adjusted_balance_p c_adjusted_balance,
AR_ARXCCS_XMLP_PKG.c_aging_convert_collection_p c_aging_convert_collection,
AR_ARXCCS_XMLP_PKG.c_aging_in_collection_p c_aging_in_collection,
AR_ARXCCS_XMLP_PKG.c_cust_hist_high_invoice_amt_p c_cust_hist_high_invoice_amt,
–AR_ARXCCS_XMLP_PKG.c_cust_hist_conv_high_invoice c_cust_hist_conv_high_invoice,
AR_ARXCCS_XMLP_PKG.c_cust_hist_conv_high_inv_p c_cust_hist_conv_high_invoice,
— AR_ARXCCS_XMLP_PKG.c_cust_hist_high_invoice_date c_cust_hist_high_invoice_date,
AR_ARXCCS_XMLP_PKG.c_cust_hist_high_inv_date_p c_cust_hist_high_invoice_date,
AR_ARXCCS_XMLP_PKG.c_cust_hist_high_limit_date_p c_cust_hist_high_limit_date,
AR_ARXCCS_XMLP_PKG.c_ytd_nsf_count_p c_ytd_nsf_count,
AR_ARXCCS_XMLP_PKG.c_ytd_convert_nsf_p c_ytd_convert_nsf,
AR_ARXCCS_XMLP_PKG.c_ytd_nsf_amount_p c_ytd_nsf_amount,
AR_ARXCCS_XMLP_PKG.c_ytd_conv_unearned_discount_p c_ytd_conv_unearned_discount,
AR_ARXCCS_XMLP_PKG.c_ytd_unearned_discount_amoun c_ytd_unearned_discount_amount,
— AR_ARXCCS_XMLP_PKG.c_ytd_convert_earned_discount c_ytd_convert_earned_discount,
AR_ARXCCS_XMLP_PKG.c_ytd_convert_earned_dis_p c_ytd_convert_earned_discount,
AR_ARXCCS_XMLP_PKG.c_ytd_earned_discount_amount_p c_ytd_earned_discount_amount,
AR_ARXCCS_XMLP_PKG.c_ytd_on_time_payments_count_p c_ytd_on_time_payments_count,
AR_ARXCCS_XMLP_PKG.c_ytd_late_payments_count_p c_ytd_late_payments_count,
AR_ARXCCS_XMLP_PKG.c_ytd_average_days_late_p c_ytd_average_days_late,
AR_ARXCCS_XMLP_PKG.c_ytd_average_payment_days_p c_ytd_average_payment_days,
AR_ARXCCS_XMLP_PKG.c_ytd_finance_charge_count_p c_ytd_finance_charge_count,
AR_ARXCCS_XMLP_PKG.c_ytd_convert_finance_charge_p c_ytd_convert_finance_charge,
AR_ARXCCS_XMLP_PKG.c_ytd_finance_charge_amount_p c_ytd_finance_charge_amount,
AR_ARXCCS_XMLP_PKG.c_ytd_credit_count_p c_ytd_credit_count,
AR_ARXCCS_XMLP_PKG.c_ytd_convert_credit_p c_ytd_convert_credit,
AR_ARXCCS_XMLP_PKG.c_ytd_credit_amount_p c_ytd_credit_amount,
AR_ARXCCS_XMLP_PKG.c_ytd_payment_count_p c_ytd_payment_count,
AR_ARXCCS_XMLP_PKG.c_ytd_convert_payment_p c_ytd_convert_payment,
AR_ARXCCS_XMLP_PKG.c_ytd_payment_amount_p c_ytd_payment_amount,
AR_ARXCCS_XMLP_PKG.c_ytd_sales_count_p c_ytd_sales_count,
AR_ARXCCS_XMLP_PKG.c_ytd_convert_sales_p c_ytd_convert_sales,
AR_ARXCCS_XMLP_PKG.c_ytd_sales_amount_p c_ytd_sales_amount,
AR_ARXCCS_XMLP_PKG.c_ytd_convert_writeoff_p c_ytd_convert_writeoff,
AR_ARXCCS_XMLP_PKG.c_ytd_writeoff_amount_p c_ytd_writeoff_amount,
AR_ARXCCS_XMLP_PKG.CP_limit_currency_p CP_limit_currency,
AR_ARXCCS_XMLP_PKG.CP_related_currencies_p CP_related_currencies,
AR_ARXCCS_XMLP_PKG.CP_txn_cur_p CP_txn_cur
from ar_payment_schedules_all ps
where ps.customer_id = :customer_id
and ps.customer_site_use_id = :site_use_id
and ps.class not in (‘CM’, ‘PMT’)
and ps.org_id = :qcust_org_id
&p_org_where_ps
and ps.customer_id=:Customer_id
and ps.Customer_site_use_id=:Site_Use_id
group by ps.invoice_currency_code, ps.customer_id, ps.customer_site_use_id
order by ps.invoice_currency_code
]]></sqlStatement>
<sqlStatement name=”Q_CREDIT_AMOUNTS”><![CDATA[
select cust_account_id qc_customer,
site_use_id qc_site,
currency_code currency_credit,
trx_credit_limit order_credit_limit,
overall_credit_limit credit_limit,
— AR_ARXCCS_XMLP_PKG.c_credit_amounts_calcformula(cust_account_id, site_use_id) C_CREDIT_AMOUNTS_CALC,
AR_ARXCCS_XMLP_PKG.c_credit_amounts_calcformula(cust_account_id,site_use_id,:functional_currency,currency_code,overall_credit_limit) C_CREDIT_AMOUNTS_CALC,
AR_ARXCCS_XMLP_PKG.c_cred_summ_convert_limit_p c_cred_summ_convert_limit,
AR_ARXCCS_XMLP_PKG.c_cred_summ_exceeded_p c_cred_summ_exceeded,
AR_ARXCCS_XMLP_PKG.c_cred_summ_available_p c_cred_summ_available,
AR_ARXCCS_XMLP_PKG.CP_trx_amount_p CP_trx_amount,
AR_ARXCCS_XMLP_PKG.CP_trx_curr_p CP_trx_curr
from hz_cust_profile_amts
where cust_account_profile_id = :c_customer_profile_id
and currency_code = :cp_limit_currency
and :cp_default_flag = ‘N’
UNION
select to_number(:ps_customer) qc_customer,
to_number(:ps_site) qc_site,
pa.currency_code currency_credit,
pa.trx_credit_limit order_credit_limit,
pa.overall_credit_limit credit_limit,
AR_ARXCCS_XMLP_PKG.c_credit_amounts_calcformula(to_number(:ps_customer),to_number(:ps_site),:functional_currency,pa.currency_code,pa.overall_credit_limit) C_CREDIT_AMOUNTS_CALC,
AR_ARXCCS_XMLP_PKG.c_cred_summ_convert_limit_p c_cred_summ_convert_limit,
AR_ARXCCS_XMLP_PKG.c_cred_summ_exceeded_p c_cred_summ_exceeded,
AR_ARXCCS_XMLP_PKG.c_cred_summ_available_p c_cred_summ_available,
AR_ARXCCS_XMLP_PKG.CP_trx_amount_p CP_trx_amount,
AR_ARXCCS_XMLP_PKG.CP_trx_curr_p CP_trx_curr
from hz_credit_profiles p,
hz_credit_profile_amts pa
where p.credit_profile_id = pa.credit_profile_id
and pa.currency_code = :cp_limit_currency
and NVL(p.effective_date_from, sysdate-1) < sysdate
and NVL(p.effective_date_to, sysdate+1) > sysdate
and NVL(p.enable_flag, ‘N’) =’Y’
and :cp_default_flag = ‘Y’
and rownum = 1
]]></sqlStatement>
<sqlStatement name=”Q_TRX_CONVERSION”><![CDATA[
SELECT Invoice_currency_code trx_cur
, customer_id trx_cust
, customer_site_use_id trx_site
, NVL(SUM(AMOUNT_DUE_REMAINING), 0) trx_amount_due
, exchange_rate_type,
AR_ARXCCS_XMLP_PKG.cf_calc_rate_amountformula(Invoice_currency_code, :CUSTOMER_ID, :SITE_USE_ID, NVL ( SUM ( AMOUNT_DUE_REMAINING ) , 0 )) CF_calc_RATE_amount,
AR_ARXCCS_XMLP_PKG.CP_limit_curr_amt_p CP_limit_curr_amt,
AR_ARXCCS_XMLP_PKG.CP_rate_p CP_rate,
AR_ARXCCS_XMLP_PKG.CP_adjusted_amount_p CP_adjusted_amount
FROM AR_PAYMENT_SCHEDULES_ALL PS
WHERE ps.customer_id = :customer_id
AND (ps.customer_site_use_id = :site_use_id OR (:site_use_id is NULL))
AND ps.status= ‘OP’
AND ps.class not IN (‘CM’,’PMT’)
and ps.org_id = :qcust_org_id
&p_org_where_ps
group by ps.invoice_currency_code, customer_id, customer_site_use_id,exchange_rate_type
]]></sqlStatement>
<sqlStatement name=”Q_customer_limit”><![CDATA[
SELECT Invoice_currency_code trx_cur2
, customer_id trx_cust2
, customer_site_use_id trx_site2
, NVL(SUM(AMOUNT_DUE_REMAINING), 0) trx_amount_due
,exchange_rate_type,
AR_ARXCCS_XMLP_PKG.cf_calc_rate_amount_formula1fo(Invoice_currency_code, :CUSTOMER_ID, :SITE_USE_ID, NVL ( SUM ( AMOUNT_DUE_REMAINING ) , 0 )) CF_CALC_RATE_AMOUNT_FORMULA1,
AR_ARXCCS_XMLP_PKG.CP_limit_curr_amt1_p CP_limit_curr_amt1,
AR_ARXCCS_XMLP_PKG.CP_rate1_p CP_rate1,
AR_ARXCCS_XMLP_PKG.CP_adjusted_amount1_p CP_adjusted_amount1
FROM AR_PAYMENT_SCHEDULES_ALL PS
WHERE ps.customer_id = :customer_id
AND ps.status= ‘OP’
and ps.class not in (‘CM’, ‘PMT’)
&p_org_where_ps
and customer_id=:qc_customer1
group by ps.invoice_currency_code, customer_id, customer_site_use_id, exchange_rate_type,amount_due_remaining
order by ps.invoice_currency_code
]]></sqlStatement>
<sqlStatement name=”Q_ORG”><![CDATA[
select currency_code org_Currency_code ,
OVERALL_CREDIT_LIMIT org_overall_limit,
TRX_CREDIT_LIMIT Org_trx_Limit,
–AR_ARXCCS_XMLP_PKG.c_org_credit_calcformula(:CUSTOMER_ID, :SITE_USE_ID) C_OERG_CREDIT_CALC,
AR_ARXCCS_XMLP_PKG.c_org_credit_calcformula(:CUSTOMER_ID, :SITE_USE_ID,:functional_currency,currency_code,OVERALL_CREDIT_LIMIT) C_OERG_CREDIT_CALC,
–AR_ARXCCS_XMLP_PKG.c_org_profileformula(:SITE_USE_ID) C_org_profile,
AR_ARXCCS_XMLP_PKG.c_org_profileformula() C_org_profile,
AR_ARXCCS_XMLP_PKG.C_cred_summ_exceeded2_p C_cred_summ_exceeded2,
AR_ARXCCS_XMLP_PKG.C_cred_summ_available2_p C_cred_summ_available2,
AR_ARXCCS_XMLP_PKG.C_cred_convert_limit2_p C_cred_convert_limit2,
AR_ARXCCS_XMLP_PKG.CP_trx_amount2_p CP_trx_amount2,
AR_ARXCCS_XMLP_PKG.CP_trx_cur2_p CP_trx_cur2,
AR_ARXCCS_XMLP_PKG.C_org_credit_hold_p C_org_credit_hold,
AR_ARXCCS_XMLP_PKG.C_org_credit_rating_p C_org_credit_rating,
AR_ARXCCS_XMLP_PKG.C_Org_limit_tolerance_p C_Org_limit_tolerance,
AR_ARXCCS_XMLP_PKG.C_credit_profile_id_p C_credit_profile_id
from HZ_Credit_profile_amts cpa
where cpa.credit_profile_id IN ( Select credit_profile_id
From HZ_Credit_Profiles
Where Organization_id = :p_reporting_entity_id
and enable_flag = ‘Y’
and Effective_Date_From <= SYSDATE
and Effective_Date_To >= SYSDATE)
and currency_code = :LIMIT_CURRENCY
]]></sqlStatement>
<sqlStatement name=”Q_org_trx”><![CDATA[
SELECT Invoice_currency_code org_trx_cur
, customer_id org_trx_cust
, customer_site_use_id org_trx_site
, NVL(SUM(AMOUNT_DUE_REMAINING), 0) trx_amount_due,
AR_ARXCCS_XMLP_PKG.cf_org_calc_amountformula(Invoice_currency_code, :CUSTOMER_ID, :SITE_USE_ID, NVL ( SUM ( AMOUNT_DUE_REMAINING ) , 0 )) CF_org_calc_amount,
AR_ARXCCS_XMLP_PKG.CP_limit_curr_amt2_p CP_limit_curr_amt2,
AR_ARXCCS_XMLP_PKG.CP_Rate2_p CP_Rate2,
AR_ARXCCS_XMLP_PKG.CP_adjusted_amount2_p CP_adjusted_amount2
FROM AR_PAYMENT_SCHEDULES_ALL PS
WHERE ps.customer_id = :customer_id
AND ps.status= ‘OP’
and ps.class not in (‘CM’, ‘PMT’)
&p_org_where_ps
group by ps.invoice_currency_code, customer_id, customer_site_use_id, amount_due_remaining
order by ps.invoice_currency_code
]]></sqlStatement>
<sqlStatement name=”Q_CREDIT_LIMITS”><![CDATA[
select currency_code currency_credit1 ,
overall_credit_limit credit_limit1,
trx_credit_limit order_credit_limit1,
cust_account_id qc_customer1,
site_use_id qc_site1,
— AR_ARXCCS_XMLP_PKG.c_credit_amounts_calcformu0114(:CUSTOMER_ID, :SITE_USE_ID) C_CREDIT_AMOUNTS_CALC1,
AR_ARXCCS_XMLP_PKG.c_credit_amounts_calcformu0114(:CUSTOMER_ID, :SITE_USE_ID,:functional_currency,currency_code,overall_credit_limit) C_CREDIT_AMOUNTS_CALC1,
AR_ARXCCS_XMLP_PKG.cf_currency_lookupformula(cust_account_id, currency_code, site_use_id, :SITE_USE_ID) CF_CURRENCY_LOOKUP,
AR_ARXCCS_XMLP_PKG.CP_TRX_AMOUNT1_p CP_TRX_AMOUNT1,
AR_ARXCCS_XMLP_PKG.C_CRED_SUMM_AVAILABLE1_p C_CRED_SUMM_AVAILABLE1,
AR_ARXCCS_XMLP_PKG.C_CRED_CONVERT_LIMIT1_p C_CRED_CONVERT_LIMIT1,
AR_ARXCCS_XMLP_PKG.C_CRED_SUMM_EXCEEDED1_p C_CRED_SUMM_EXCEEDED1,
AR_ARXCCS_XMLP_PKG.CP_TRX_CUR1_p CP_TRX_CUR1,
AR_ARXCCS_XMLP_PKG.DEFAULT_FLAG_p DEFAULT_FLAG,
AR_ARXCCS_XMLP_PKG.LIMIT_CURRENCY_p LIMIT_CURRENCY,
AR_ARXCCS_XMLP_PKG.RELATED_CURRENCIES_p RELATED_CURRENCIES
from hz_cust_profile_amts
where cust_account_profile_id = :c_customer_profile_id
]]></sqlStatement>
</dataQuery>
<dataTrigger name=”afterParameterFormTrigger” source=”AR_ARXCCS_XMLP_PKG.afterpform” />
<dataTrigger name=”beforeReportTrigger” source=”AR_ARXCCS_XMLP_PKG.beforereport” />
<dataStructure>
<group name=”G_SETUP” dataType=”varchar2″ source=”Q_SETUP”>
<element name=”setup_org_id” dataType=”number” value=”SETUP_ORG_ID” />
<element name=”Company_Name” dataType=”varchar2″ value=”COMPANY_NAME” />
<element name=”coa_id” dataType=”number” value=”COA_ID” />
<element name=”Functional_Currency” dataType=”varchar2″ value=”FUNCTIONAL_CURRENCY” />
<element name=”Functional_Currency_Preci” dataType=”number” value=”FUNCTIONAL_CURRENCY_PRECISION” />
<element name=”Report_Name” dataType=”varchar2″ value=”Report_Name” />
<group name=”G_CUST” dataType=”varchar2″ source=”Q_CUST”>
<element name=”qcust_org_id” dataType=”number” value=”QCUST_ORG_ID” />
<element name=”Customer_Name” dataType=”varchar2″ value=”CUSTOMER_NAME” />
<element name=”C_DATA_NOT_FOUND” dataType=”number” value=”C_DATA_NOT_FOUND” />
<element name=”Customer_Number” dataType=”varchar2″ value=”CUSTOMER_NUMBER” />
<element name=”Customer_Age” dataType=”number” value=”CUSTOMER_AGE” />
<element name=”c_customer_age” dataType=”varchar2″ value=”c_customer_age” />
<element name=”Customer_id” dataType=”number” value=”CUSTOMER_ID” />
<element name=”Address_Age” dataType=”number” value=”ADDRESS_AGE” />
<element name=”Address1″ dataType=”varchar2″ value=”ADDRESS1″ />
<element name=”Address2″ dataType=”varchar2″ value=”ADDRESS2″ />
<element name=”Address3″ dataType=”varchar2″ value=”ADDRESS3″ />
<element name=”Address4″ dataType=”varchar2″ value=”ADDRESS4″ />
<element name=”City” dataType=”varchar2″ value=”CITY” />
<element name=”State” dataType=”varchar2″ value=”STATE” />
<element name=”Postal_Code” dataType=”varchar2″ value=”POSTAL_CODE” />
<element name=”Country” dataType=”varchar2″ value=”COUNTRY” />
<element name=”Site_Use_id” dataType=”number” value=”SITE_USE_ID” />
<element name=”Address_id” dataType=”number” value=”ADDRESS_ID” />
<element name=”Location” dataType=”varchar2″ value=”LOCATION” />
<element name=”C_Contact” dataType=”varchar2″ value=”C_Contact” />
<element name=”C_Phone_Number” dataType=”varchar2″ value=”C_Phone_Number” />
<element name=”Sel_Contact” dataType=”varchar2″ value=”Sel_Contact” />
<element name=”c_address_age” dataType=”varchar2″ value=”c_address_age” />
<element name=”c_city_state_zip” dataType=”varchar2″ value=”c_city_state_zip” />
<element name=”C_CREDIT_SUMMARY” dataType=”number” value=”C_CREDIT_SUMMARY” />
<element name=”C_LAST_CREDIT_MEMO_FORMULA” dataType=”number” value=”C_LAST_CREDIT_MEMO_FORMULA” />
<element name=”c_profile_site_use_id” dataType=”number” value=”c_profile_site_use_id” />
<element name=”c_customer_profile_id” dataType=”number” value=”c_customer_profile_id” />
<element name=”c_cred_summ_collector” dataType=”varchar2″ value=”c_cred_summ_collector” />
<element name=”c_cred_summ_exempt_dun” dataType=”varchar2″ value=”c_cred_summ_exempt_dun” />
<element name=”c_cred_summ_terms” dataType=”varchar2″ value=”c_cred_summ_terms” />
<element name=”c_cred_summ_account_status” dataType=”varchar2″ value=”c_cred_summ_account_status” />
<element name=”c_cred_summ_credit_hold” dataType=”varchar2″ value=”c_cred_summ_credit_hold” />
<element name=”c_cred_summ_risk_code” dataType=”varchar2″ value=”c_cred_summ_risk_code” />
<element name=”c_cred_summ_credit_rating” dataType=”varchar2″ value=”c_cred_summ_credit_rating” />
<element name=”c_cred_summ_limit_tolerance” dataType=”varchar2″ value=”c_cred_summ_limit_tolerance” />
<element name=”c_cred_summ_limit_expire_date” dataType=”varchar2″ value=”c_cred_summ_limit_expire_date” />
<element name=”C_LAST_INVOICE_FORMULA” dataType=”number” value=”C_LAST_INVOICE_FORMULA” />
<element name=”c_last_invoice_days_since” dataType=”varchar2″ value=”c_last_invoice_days_since” />
<element name=”c_last_invoice_date” dataType=”varchar2″ value=”c_last_invoice_date” />
<element name=”c_last_invoice_converted” dataType=”varchar2″ value=”c_last_invoice_converted” />
<element name=”c_last_invoice_amount” dataType=”number” value=”c_last_invoice_amount” />
<element name=”cd_last_invoice_amount” dataType=”varchar2″ value=”c_last_invoice_amount” function=”CURRENCY_FORMAT” currencyCode=”c_last_invoice_currency” width=”19″ />
<element name=”c_last_invoice_currency” dataType=”varchar2″ value=”c_last_invoice_currency” />
<element name=”c_last_invoice_type” dataType=”varchar2″ value=”c_last_invoice_type” />
<element name=”c_last_invoice_number” dataType=”varchar2″ value=”c_last_invoice_number” />
<element name=”c_last_cm_rel_invoice” dataType=”varchar2″ value=”c_last_cm_rel_invoice” />
<element name=”c_last_cm_converted” dataType=”varchar2″ value=”c_last_cm_converted” />
<element name=”c_last_cm_amount” dataType=”number” value=”c_last_cm_amount” />
<element name=”c_last_cm_id” dataType=”number” value=”c_last_cm_id” />
<element name=”c_last_cm_prev_trx” dataType=”number” value=”c_last_cm_prev_trx” />
<element name=”c_last_cm_days_since” dataType=”varchar2″ value=”c_last_cm_days_since” />
<element name=”c_last_cm_date” dataType=”varchar2″ value=”c_last_cm_date” />
<element name=”c_last_cm_currency” dataType=”varchar2″ value=”c_last_cm_currency” />
<element name=”c_last_cm_type” dataType=”varchar2″ value=”c_last_cm_type” />
<element name=”c_last_cm_number” dataType=”varchar2″ value=”c_last_cm_number” />
<element name=”cd_last_cm_amount” dataType=”varchar2″ value=”c_last_cm_amount” function=”CURRENCY_FORMAT” currencyCode=”c_last_cm_currency” width=”19″ />
<element name=”C_GUARANTEE_FORMULA” dataType=”number” value=”C_GUARANTEE_FORMULA” />
<element name=”cd_last_guar_amount” dataType=”varchar2″ value=”c_last_guar_amount” function=”CURRENCY_FORMAT” currencyCode=”c_last_guar_currency” width=”19″ />
<element name=”c_last_guar_days_since” dataType=”varchar2″ value=”c_last_guar_days_since” />
<element name=”c_last_guar_date” dataType=”varchar2″ value=”c_last_guar_date” />
<element name=”c_last_guar_converted” dataType=”varchar2″ value=”c_last_guar_converted” />
<element name=”c_last_guar_amount” dataType=”number” value=”c_last_guar_amount” />
<element name=”c_last_guar_currency” dataType=”varchar2″ value=”c_last_guar_currency” />
<element name=”c_last_guar_type” dataType=”varchar2″ value=”c_last_guar_type” />
<element name=”c_last_guar_number” dataType=”varchar2″ value=”c_last_guar_number” />
<element name=”C_LAST_DEPOSIT_FORMULA” dataType=”number” value=”C_LAST_DEPOSIT_FORMULA” />
<element name=”cd_last_dep_amount” dataType=”varchar2″ value=”c_last_dep_amount” function=”CURRENCY_FORMAT” currencyCode=”c_last_dep_currency” width=”19″ />
<element name=”c_last_dep_days_since” dataType=”varchar2″ value=”c_last_dep_days_since” />
<element name=”c_last_dep_date” dataType=”varchar2″ value=”c_last_dep_date” />
<element name=”c_last_dep_converted” dataType=”varchar2″ value=”c_last_dep_converted” />
<element name=”c_last_dep_amount” dataType=”number” value=”c_last_dep_amount” />
<element name=”c_last_dep_currency” dataType=”varchar2″ value=”c_last_dep_currency” />
<element name=”c_last_dep_type” dataType=”varchar2″ value=”c_last_dep_type” />
<element name=”c_last_dep_number” dataType=”varchar2″ value=”c_last_dep_number” />
<element name=”C_LAST_DM_FORMULA” dataType=”number” value=”C_LAST_DM_FORMULA” />
<element name=”cd_last_dm_amount” dataType=”varchar2″ value=”c_last_dm_amount” function=”CURRENCY_FORMAT” currencyCode=”c_last_dm_currency” width=”19″ />
<element name=”c_last_dm_days_since” dataType=”varchar2″ value=”c_last_dm_days_since” />
<element name=”c_last_dm_date” dataType=”varchar2″ value=”c_last_dm_date” />
<element name=”c_last_dm_converted” dataType=”varchar2″ value=”c_last_dm_converted” />
<element name=”c_last_dm_amount” dataType=”number” value=”c_last_dm_amount” />
<element name=”c_last_dm_currency” dataType=”varchar2″ value=”c_last_dm_currency” />
<element name=”c_last_dm_type” dataType=”varchar2″ value=”c_last_dm_type” />
<element name=”c_last_dm_number” dataType=”varchar2″ value=”c_last_dm_number” />
<element name=”C_LAST_CB_FORMULA” dataType=”number” value=”C_LAST_CB_FORMULA” />
<element name=”cd_last_cb_amount” dataType=”varchar2″ value=”c_last_cb_amount” function=”CURRENCY_FORMAT” currencyCode=”c_last_cb_currency” width=”19″ />
<element name=”c_last_cb_days_since” dataType=”number” value=”c_last_cb_days_since” />
<element name=”c_last_cb_date” dataType=”varchar2″ value=”c_last_cb_date” />
<element name=”c_last_cb_converted” dataType=”varchar2″ value=”c_last_cb_converted” />
<element name=”c_last_cb_amount” dataType=”number” value=”c_last_cb_amount” />
<element name=”c_last_cb_currency” dataType=”varchar2″ value=”c_last_cb_currency” />
<element name=”c_last_cb_type” dataType=”varchar2″ value=”c_last_cb_type” />
<element name=”c_last_cb_number” dataType=”varchar2″ value=”c_last_cb_number” />
<element name=”C_LAST_PAYMENT_FORMULA” dataType=”number” value=”C_LAST_PAYMENT_FORMULA” />
<element name=”cd_last_payment_amount” dataType=”varchar2″ value=”c_last_payment_amount” function=”CURRENCY_FORMAT” currencyCode=”c_last_payment_currency” width=”19″ />
<element name=”c_last_payment_rel_invoice” dataType=”varchar2″ value=”c_last_payment_rel_invoice” />
<element name=”c_last_payment_days_since” dataType=”varchar2″ value=”c_last_payment_days_since” />
<element name=”c_last_payment_date” dataType=”varchar2″ value=”c_last_payment_date” />
<element name=”c_last_payment_converted” dataType=”varchar2″ value=”c_last_payment_converted” />
<element name=”c_last_payment_amount” dataType=”number” value=”c_last_payment_amount” />
<element name=”c_last_payment_currency” dataType=”varchar2″ value=”c_last_payment_currency” />
<element name=”c_last_payment_type” dataType=”varchar2″ value=”c_last_payment_type” />
<element name=”c_last_payment_number” dataType=”varchar2″ value=”c_last_payment_number” />
<element name=”C_LAST_ADJ_FORMULA” dataType=”number” value=”C_LAST_ADJ_FORMULA” />
<element name=”cd_last_adj_amount” dataType=”varchar2″ value=”c_last_adj_amount” function=”CURRENCY_FORMAT” currencyCode=”c_last_adj_currency” width=”19″ />
<element name=”c_last_adj_days_since” dataType=”varchar2″ value=”c_last_adj_days_since” />
<element name=”c_last_adj_date” dataType=”varchar2″ value=”c_last_adj_date” />
<element name=”c_last_adj_converted” dataType=”varchar2″ value=”c_last_adj_converted” />
<element name=”c_last_adj_amount” dataType=”number” value=”c_last_adj_amount” />
<element name=”c_last_adj_currency” dataType=”varchar2″ value=”c_last_adj_currency” />
<element name=”c_last_adj_rel_invoice” dataType=”varchar2″ value=”c_last_adj_rel_invoice” />
<element name=”c_last_adj_type” dataType=”varchar2″ value=”c_last_adj_type” />
<element name=”c_last_adj_number” dataType=”varchar2″ value=”c_last_adj_number” />
<element name=”C_LAST_WRITEOFF_FORMULA” dataType=”number” value=”C_LAST_WRITEOFF_FORMULA” />
<element name=”cd_last_wo_amount” dataType=”varchar2″ value=”c_last_wo_amount” function=”CURRENCY_FORMAT” currencyCode=”c_last_wo_currency” width=”19″ />
<element name=”c_last_wo_days_since” dataType=”varchar2″ value=”c_last_wo_days_since” />
<element name=”c_last_wo_date” dataType=”varchar2″ value=”c_last_wo_date” />
<element name=”c_last_wo_converted” dataType=”varchar2″ value=”c_last_wo_converted” />
<element name=”c_last_wo_amount” dataType=”number” value=”c_last_wo_amount” />
<element name=”c_last_wo_currency” dataType=”varchar2″ value=”c_last_wo_currency” />
<element name=”c_last_wo_rel_invoice” dataType=”varchar2″ value=”c_last_wo_rel_invoice” />
<element name=”c_last_wo_type” dataType=”varchar2″ value=”c_last_wo_type” />
<element name=”c_last_wo_number” dataType=”varchar2″ value=”c_last_wo_number” />
<element name=”C_LAST_STATEMENT_FORMULA” dataType=”number” value=”C_LAST_STATEMENT_FORMULA” />
<element name=”c_last_stmnt_next_trx_date” dataType=”varchar2″ value=”c_last_stmnt_next_trx_date” />
<element name=”c_last_st_date” dataType=”varchar2″ value=”c_last_st_date” />
<element name=”c_last_st_type” dataType=”varchar2″ value=”c_last_st_type” />
<element name=”c_last_st_number” dataType=”varchar2″ value=”c_last_st_number” />
<element name=”c_last_st_days_since” dataType=”varchar2″ value=”c_last_st_days_since” />
<element name=”C_LAST_DN_FORMULA” dataType=”number” value=”C_LAST_DN_FORMULA” />
<element name=”cd_last_dn_amount” dataType=”varchar2″ value=”c_last_dn_amount” function=”CURRENCY_FORMAT” currencyCode=”c_last_dn_currency” width=”19″ />
<element name=”c_last_dn_days_since” dataType=”varchar2″ value=”c_last_dn_days_since” />
<element name=”c_last_dn_date” dataType=”varchar2″ value=”c_last_dn_date” />
<element name=”c_last_dn_currency” dataType=”varchar2″ value=”c_last_dn_currency” />
<element name=”c_last_dn_amount” dataType=”number” value=”c_last_dn_amount” />
<element name=”c_last_dn_type” dataType=”varchar2″ value=”c_last_dn_type” />
<element name=”c_last_dn_number” dataType=”varchar2″ value=”c_last_dn_number” />
<element name=”C_LAST_NSF_FORMULA” dataType=”number” value=”C_LAST_NSF_FORMULA” />
<element name=”cd_last_nsf_amount” dataType=”varchar2″ value=”c_last_nsf_amount” function=”CURRENCY_FORMAT” currencyCode=”c_last_nsf_currency” width=”19″ />
<element name=”c_last_nsf_currency” dataType=”varchar2″ value=”c_last_nsf_currency” />
<element name=”c_last_nsf_days_since” dataType=”varchar2″ value=”c_last_nsf_days_since” />
<element name=”c_last_nsf_date” dataType=”varchar2″ value=”c_last_nsf_date” />
<element name=”c_last_nsf_converted” dataType=”varchar2″ value=”c_last_nsf_converted” />
<element name=”c_last_nsf_amount” dataType=”number” value=”c_last_nsf_amount” />
<element name=”c_last_nsf_type” dataType=”varchar2″ value=”c_last_nsf_type” />
<element name=”c_last_nsf_number” dataType=”varchar2″ value=”c_last_nsf_number” />
<element name=”C_LAST_CONTACT_FORMULA” dataType=”number” value=”C_LAST_CONTACT_FORMULA” />
<element name=”cd_last_contact_amount” dataType=”varchar2″ value=”c_last_contact_amount” function=”CURRENCY_FORMAT” currencyCode=”c_last_contact_currency” width=”19″ />
<element name=”c_last_contact_days_since” dataType=”varchar2″ value=”c_last_contact_days_since” />
<element name=”c_last_contact_date” dataType=”varchar2″ value=”c_last_contact_date” />
<element name=”c_last_contact_amount” dataType=”number” value=”c_last_contact_amount” />
<element name=”c_last_contact_converted” dataType=”varchar2″ value=”c_last_contact_converted” />
<element name=”c_last_contact_currency” dataType=”varchar2″ value=”c_last_contact_currency” />
<element name=”c_last_contact_rel_invoice” dataType=”varchar2″ value=”c_last_contact_rel_invoice” />
<element name=”c_last_contact_number” dataType=”varchar2″ value=”c_last_contact_number” />
<element name=”C_LAST_HOLD_FORMULA” dataType=”number” value=”C_LAST_HOLD_FORMULA” />
<element name=”cd_last_hold_amount” dataType=”varchar2″ value=”c_last_hold_amount” function=”CURRENCY_FORMAT” currencyCode=”functional_currency” width=”19″ />
<element name=”c_last_hold_days_since” dataType=”varchar2″ value=”c_last_hold_days_since” />
<element name=”c_last_hold_date” dataType=”varchar2″ value=”c_last_hold_date” />
<element name=”c_last_hold_amount” dataType=”number” value=”c_last_hold_amount” />
<element name=”c_last_hold_number” dataType=”varchar2″ value=”c_last_hold_number” />
<element name=”Customer_Profile_Id” dataType=”number” value=”CUSTOMER_PROFILE_ID” />
<group name=”G_BUCKET” dataType=”varchar2″ source=”Q_BUCKET”>
<element name=”Currency_Bucket” dataType=”varchar2″ value=”CURRENCY_BUCKET” />
<element name=”Aging_Balance_Outstanding” dataType=”number” value=”AGING_BALANCE_OUTSTANDING” />
<element name=”cd_aging_balance_os” dataType=”varchar2″ value=”AGING_BALANCE_OUTSTANDING” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”Total_Cust_b0″ dataType=”number” value=”TOTAL_CUST_B0″ />
<element name=”Total_Cust_b1″ dataType=”number” value=”TOTAL_CUST_B1″ />
<element name=”Total_Cust_b2″ dataType=”number” value=”TOTAL_CUST_B2″ />
<element name=”Total_Cust_b3″ dataType=”number” value=”TOTAL_CUST_B3″ />
<element name=”Total_Cust_b4″ dataType=”number” value=”TOTAL_CUST_B4″ />
<element name=”Total_Cust_b5″ dataType=”number” value=”TOTAL_CUST_B5″ />
<element name=”Total_Cust_b6″ dataType=”number” value=”TOTAL_CUST_B6″ />
<element name=”CP_DEFAULT_FLAG” dataType=”varchar2″ value=”CP_DEFAULT_FLAG” />
<element name=”cd_total_cust_b6″ dataType=”varchar2″ value=”total_cust_b6″ function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_total_cust_b5″ dataType=”varchar2″ value=”total_cust_b5″ function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_total_cust_b4″ dataType=”varchar2″ value=”total_cust_b4″ function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_total_cust_b3″ dataType=”varchar2″ value=”total_cust_b3″ function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_total_cust_b2″ dataType=”varchar2″ value=”total_cust_b2″ function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_total_cust_b1″ dataType=”varchar2″ value=”TOTAL_CUST_B1″ function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_total_cust_b0″ dataType=”varchar2″ value=”total_cust_b0″ function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”Aging_Convert_Bucket” dataType=”varchar2″ value=”AGING_CONVERT_BUCKET” />
<element name=”C_CALC_PERCENT” dataType=”number” value=”C_CALC_PERCENT” />
<element name=”c_percent_b0″ dataType=”varchar2″ value=”c_percent_b0″ />
<element name=”c_percent_b1″ dataType=”varchar2″ value=”c_percent_b1″ />
<element name=”c_percent_b2″ dataType=”varchar2″ value=”c_percent_b2″ />
<element name=”c_percent_b3″ dataType=”varchar2″ value=”c_percent_b3″ />
<element name=”c_percent_b4″ dataType=”varchar2″ value=”c_percent_b4″ />
<element name=”c_percent_b5″ dataType=”varchar2″ value=”c_percent_b5″ />
<element name=”c_percent_b6″ dataType=”varchar2″ value=”c_percent_b6″ />
<element name=”C_COMPUTE_AMT” dataType=”number” value=”C_COMPUTE_AMT” />
<element name=”c_aging_on_account” dataType=”number” value=”c_aging_on_account” />
<element name=”c_aging_unapplied” dataType=”number” value=”c_aging_unapplied” />
<element name=”c_aging_convert_on_account” dataType=”varchar2″ value=”c_aging_convert_on_account” />
<element name=”c_aging_convert_unapplied” dataType=”varchar2″ value=”c_aging_convert_unapplied” />
<element name=”c_aging_credit” dataType=”number” value=”c_aging_credit” />
<element name=”c_aging_convert_credit” dataType=”varchar2″ value=”c_aging_convert_credit” />
<element name=”c_adjusted_balance” dataType=”number” value=”c_adjusted_balance” />
<element name=”c_aging_convert_collection” dataType=”varchar2″ value=”c_aging_convert_collection” />
<element name=”c_aging_in_collection” dataType=”number” value=”c_aging_in_collection” />
<element name=”cd_aging_in_collection” dataType=”varchar2″ value=”C_AGING_IN_COLLECTION” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_aging_on_account” dataType=”varchar2″ value=”C_AGING_ON_ACCOUNT” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_aging_unapplied” dataType=”varchar2″ value=”C_AGING_UNAPPLIED” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_aging_credit” dataType=”varchar2″ value=”C_AGING_CREDIT” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_adjusted_balance” dataType=”varchar2″ value=”C_ADJUSTED_BALANCE” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”c_cust_hist_high_invoice_amt” dataType=”number” value=”c_cust_hist_high_invoice_amt” />
<element name=”cd_cust_hist_high_inv_amt” dataType=”varchar2″ value=”C_CUST_HIST_HIGH_INVOICE_AMT” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”c_cust_hist_conv_high_invoice” dataType=”varchar2″ value=”c_cust_hist_conv_high_invoice” />
<element name=”c_cust_hist_high_invoice_date” dataType=”varchar2″ value=”c_cust_hist_high_invoice_date” />
<element name=”C_HIGH_INV_FORMULA” dataType=”number” value=”C_HIGH_INV_FORMULA” />
<element name=”c_cust_hist_high_limit_amt” dataType=”number” value=”c_cust_hist_high_limit_amt” />
<element name=”cd_cust_hist_high_lim_amt” dataType=”varchar2″ value=”C_CUST_HIST_HIGH_LIMIT_AMT” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”c_cust_hist_high_limit_date” dataType=”date” value=”c_cust_hist_high_limit_date” />
<element name=”c_ytd_nsf_count” dataType=”number” value=”c_ytd_nsf_count” />
<element name=”c_ytd_convert_nsf” dataType=”varchar2″ value=”c_ytd_convert_nsf” />
<element name=”c_ytd_nsf_amount” dataType=”number” value=”c_ytd_nsf_amount” />
<element name=”c_ytd_conv_unearned_discount” dataType=”varchar2″ value=”c_ytd_conv_unearned_discount” />
<element name=”c_ytd_unearned_discount_amount” dataType=”number” value=”c_ytd_unearned_discount_amount” />
<element name=”c_ytd_convert_earned_discount” dataType=”varchar2″ value=”c_ytd_convert_earned_discount” />
<element name=”c_ytd_earned_discount_amount” dataType=”number” value=”c_ytd_earned_discount_amount” />
<element name=”c_ytd_on_time_payments_count” dataType=”number” value=”c_ytd_on_time_payments_count” />
<element name=”c_ytd_late_payments_count” dataType=”number” value=”c_ytd_late_payments_count” />
<element name=”c_ytd_average_days_late” dataType=”number” value=”c_ytd_average_days_late” />
<element name=”c_ytd_average_payment_days” dataType=”number” value=”c_ytd_average_payment_days” />
<element name=”c_ytd_finance_charge_count” dataType=”number” value=”c_ytd_finance_charge_count” />
<element name=”c_ytd_convert_finance_charge” dataType=”varchar2″ value=”c_ytd_convert_finance_charge” />
<element name=”c_ytd_finance_charge_amount” dataType=”number” value=”c_ytd_finance_charge_amount” />
<element name=”c_ytd_credit_count” dataType=”number” value=”c_ytd_credit_count” />
<element name=”c_ytd_convert_credit” dataType=”varchar2″ value=”c_ytd_convert_credit” />
<element name=”c_ytd_credit_amount” dataType=”number” value=”c_ytd_credit_amount” />
<element name=”c_ytd_payment_count” dataType=”number” value=”c_ytd_payment_count” />
<element name=”c_ytd_convert_payment” dataType=”varchar2″ value=”c_ytd_convert_payment” />
<element name=”c_ytd_payment_amount” dataType=”number” value=”c_ytd_payment_amount” />
<element name=”c_ytd_sales_count” dataType=”number” value=”c_ytd_sales_count” />
<element name=”c_ytd_convert_sales” dataType=”varchar2″ value=”c_ytd_convert_sales” />
<element name=”c_ytd_sales_amount” dataType=”number” value=”c_ytd_sales_amount” />
<element name=”c_ytd_convert_writeoff” dataType=”varchar2″ value=”c_ytd_convert_writeoff” />
<element name=”c_ytd_writeoff_amount” dataType=”number” value=”c_ytd_writeoff_amount” />
<element name=”C_ROLLING_SUMMARY_CALC” dataType=”number” value=”C_ROLLING_SUMMARY_CALC” />
<element name=”cd_ytd_nsf_amount” dataType=”varchar2″ value=”C_YTD_NSF_AMOUNT” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_ytd_unearned_dis_amt” dataType=”varchar2″ value=”C_YTD_UNEARNED_DISCOUNT_AMOUNT” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_ytd_earned_dis_amt” dataType=”varchar2″ value=”C_YTD_EARNED_DISCOUNT_AMOUNT” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_ytd_fin_charge_amount” dataType=”varchar2″ value=”C_YTD_FINANCE_CHARGE_AMOUNT” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_ytd_credit_amount” dataType=”varchar2″ value=”C_YTD_CREDIT_AMOUNT” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_ytd_payment_amount” dataType=”varchar2″ value=”C_YTD_PAYMENT_AMOUNT” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”CP_limit_currency” dataType=”varchar2″ value=”CP_limit_currency” />
<element name=”C_currency_lookup” dataType=”number” value=”C_currency_lookup” />
<element name=”CP_related_currencies” dataType=”varchar2″ value=”CP_related_currencies” />
<element name=”CP_txn_cur” dataType=”varchar2″ value=”CP_txn_cur” />
<element name=”cd_ytd_sales_amount” dataType=”varchar2″ value=”C_YTD_SALES_AMOUNT” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”cd_ytd_writeoff_amount” dataType=”varchar2″ value=”C_YTD_WRITEOFF_AMOUNT” function=”CURRENCY_FORMAT” currencyCode=”Currency_Bucket” width=”19″ />
<element name=”ps_customer” dataType=”number” value=”PS_CUSTOMER” />
<element name=”ps_site” dataType=”number” value=”PS_SITE” />
<group name=”G_CREDIT_AMOUNTS” dataType=”varchar2″ source=”Q_CREDIT_AMOUNTS”>
<element name=”CREDIT_LIMIT” dataType=”number” value=”CREDIT_LIMIT” />
<element name=”QC_CUSTOMER” dataType=”number” value=”QC_CUSTOMER” />
<element name=”QC_SITE” dataType=”number” value=”QC_SITE” />
<element name=”ORDER_CREDIT_LIMIT” dataType=”number” value=”ORDER_CREDIT_LIMIT” />
<element name=”CURRENCY_CREDIT” dataType=”varchar2″ value=”CURRENCY_CREDIT” />
<element name=”C_CREDIT_AMOUNTS_CALC” dataType=”number” value=”C_CREDIT_AMOUNTS_CALC” />
<element name=”c_cred_summ_convert_limit” dataType=”varchar2″ value=”c_cred_summ_convert_limit” />
<element name=”c_cred_summ_exceeded” dataType=”number” value=”c_cred_summ_exceeded” />
<element name=”cd_credit_limit” dataType=”varchar2″ value=”credit_limit” function=”CURRENCY_FORMAT” currencyCode=”Currency_Credit” width=”19″ />
<element name=”c_cred_summ_available” dataType=”number” value=”c_cred_summ_available” />
<element name=”cd_order_credit_limit” dataType=”varchar2″ value=”order_credit_limit” function=”CURRENCY_FORMAT” currencyCode=”Currency_Credit” width=”19″ />
<element name=”cd_cred_summ_available” dataType=”varchar2″ value=”c_cred_summ_available” function=”CURRENCY_FORMAT” currencyCode=”Currency_Credit” width=”19″ />
<element name=”cd_cred_summ_exceeded” dataType=”varchar2″ value=”c_cred_summ_exceeded” function=”CURRENCY_FORMAT” currencyCode=”Currency_Credit” width=”19″ />
<element name=”CP_trx_amount” dataType=”number” value=”CP_trx_amount” />
<element name=”CP_trx_curr” dataType=”number” value=”CP_trx_curr” />
<group name=”G_TRX_CONVERSION” dataType=”varchar2″ source=”Q_TRX_CONVERSION”>
<element name=”exchange_rate_type” dataType=”varchar2″ value=”EXCHANGE_RATE_TYPE” />
<element name=”trx_cur” dataType=”varchar2″ value=”TRX_CUR” />
<element name=”trx_amount_due” dataType=”number” value=”TRX_AMOUNT_DUE” />
<element name=”CP_limit_curr_amt” dataType=”number” value=”CP_limit_curr_amt” />
<element name=”CF_calc_RATE_amount” dataType=”number” value=”CF_calc_RATE_amount” />
<element name=”trx_cust” dataType=”number” value=”TRX_CUST” />
<element name=”trx_site” dataType=”number” value=”TRX_SITE” />
<element name=”CD_TRX_AMOUNT” dataType=”varchar2″ value=”CP_adjusted_amount” function=”CURRENCY_FORMAT” currencyCode=”trx_cur” width=”19″ />
<element name=”CD_LIMIT_CUR_AMT” dataType=”varchar2″ value=”cp_limit_curr_amt” function=”CURRENCY_FORMAT” currencyCode=”cp_limit_currency” width=”19″ />
<element name=”CP_rate” dataType=”number” value=”CP_rate” />
<element name=”CP_adjusted_amount” dataType=”number” value=”CP_adjusted_amount” />
</group>
</group>
</group>
<group name=”G_CREDIT_LIMITS” dataType=”varchar2″ source=”Q_CREDIT_LIMITS”>
<element name=”currency_credit1″ dataType=”varchar2″ value=”CURRENCY_CREDIT1″ />
<element name=”credit_limit1″ dataType=”number” value=”CREDIT_LIMIT1″ />
<element name=”order_credit_limit1″ dataType=”number” value=”ORDER_CREDIT_LIMIT1″ />
<element name=”qc_customer1″ dataType=”number” value=”QC_CUSTOMER1″ />
<element name=”qc_site1″ dataType=”number” value=”QC_SITE1″ />
<element name=”CP_TRX_AMOUNT1″ dataType=”number” value=”CP_TRX_AMOUNT1″ />
<element name=”C_CRED_SUMM_AVAILABLE1″ dataType=”number” value=”C_CRED_SUMM_AVAILABLE1″ />
<element name=”CD_CREDIT_LIMIT1″ dataType=”varchar2″ value=”CREDIT_LIMIT1″ function=”CURRENCY_FORMAT” currencyCode=”Currency_Credit1″ width=”19″ />
<element name=”CD_CRED_SUMM_AVAILABLE1″ dataType=”varchar2″ value=”c_cred_summ_available1″ function=”CURRENCY_FORMAT” currencyCode=”Currency_Credit1″ width=”19″ />
<element name=”C_CRED_CONVERT_LIMIT1″ dataType=”varchar2″ value=”C_CRED_CONVERT_LIMIT1″ />
<element name=”C_CRED_SUMM_EXCEEDED1″ dataType=”number” value=”C_CRED_SUMM_EXCEEDED1″ />
<element name=”CP_TRX_CUR1″ dataType=”varchar2″ value=”CP_TRX_CUR1″ />
<element name=”DEFAULT_FLAG” dataType=”varchar2″ value=”DEFAULT_FLAG” />
<element name=”LIMIT_CURRENCY” dataType=”varchar2″ value=”LIMIT_CURRENCY” />
<element name=”C_CREDIT_AMOUNTS_CALC1″ dataType=”number” value=”C_CREDIT_AMOUNTS_CALC1″ />
<element name=”RELATED_CURRENCIES” dataType=”varchar2″ value=”RELATED_CURRENCIES” />
<element name=”CD_CRED_SUMM_EXCEEDED1″ dataType=”varchar2″ value=”c_cred_summ_exceeded1″ function=”CURRENCY_FORMAT” currencyCode=”Currency_Credit1″ width=”19″ />
<element name=”CD_ORDER_CREDIT_LIMIT1″ dataType=”varchar2″ value=”order_credit_limit1″ function=”CURRENCY_FORMAT” currencyCode=”Currency_Credit1″ width=”19″ />
<element name=”CF_CURRENCY_LOOKUP” dataType=”number” value=”CF_CURRENCY_LOOKUP” />
<group name=”G_org_Limits” dataType=”varchar2″ source=”Q_ORG”>
<element name=”org_Currency_code” dataType=”varchar2″ value=”ORG_CURRENCY_CODE” />
<element name=”org_overall_limit” dataType=”number” value=”ORG_OVERALL_LIMIT” />
<element name=”Org_trx_Limit” dataType=”number” value=”ORG_TRX_LIMIT” />
<element name=”C_cred_summ_exceeded2″ dataType=”number” value=”C_cred_summ_exceeded2″ />
<element name=”C_cred_summ_available2″ dataType=”number” value=”C_cred_summ_available2″ />
<element name=”Cd_credit_limit2″ dataType=”varchar2″ value=”org_overall_limit” function=”CURRENCY_FORMAT” currencyCode=”org_currency_code” width=”19″ />
<element name=”Cd_order_credit_limit2″ dataType=”varchar2″ value=”org_trx_limit” function=”CURRENCY_FORMAT” currencyCode=”Org_Currency_Code” width=”19″ />
<element name=”Cd_cred_summ_available2″ dataType=”varchar2″ value=”c_cred_summ_available2″ function=”CURRENCY_FORMAT” currencyCode=”org_currency_code” width=”19″ />
<element name=”C_cred_convert_limit2″ dataType=”varchar2″ value=”C_cred_convert_limit2″ />
<element name=”CP_trx_amount2″ dataType=”number” value=”CP_trx_amount2″ />
<element name=”CP_trx_cur2″ dataType=”varchar2″ value=”CP_trx_cur2″ />
<element name=”C_OERG_CREDIT_CALC” dataType=”number” value=”C_OERG_CREDIT_CALC” />
<element name=”Cd_cred_summ_exceeded2″ dataType=”varchar2″ value=”c_cred_summ_exceeded2″ function=”CURRENCY_FORMAT” currencyCode=”Org_currency_code” width=”19″ />
<element name=”C_org_profile” dataType=”number” value=”C_org_profile” />
<element name=”C_org_credit_hold” dataType=”varchar2″ value=”C_org_credit_hold” />
<element name=”C_org_credit_rating” dataType=”varchar2″ value=”C_org_credit_rating” />
<element name=”C_Org_limit_tolerance” dataType=”varchar2″ value=”C_Org_limit_tolerance” />
<element name=”C_credit_profile_id” dataType=”number” value=”C_credit_profile_id” />
<group name=”G_org_trx_cur” dataType=”varchar2″ source=”Q_org_trx”>
<element name=”org_trx_cur” dataType=”varchar2″ value=”ORG_TRX_CUR” />
<element name=”org_trx_cust” dataType=”number” value=”ORG_TRX_CUST” />
<element name=”org_trx_site” dataType=”number” value=”ORG_TRX_SITE” />
<element name=”trx_amount_due2″ dataType=”number” value=”TRX_AMOUNT_DUE” />
<element name=”CP_limit_curr_amt2″ dataType=”number” value=”CP_limit_curr_amt2″ />
<element name=”CP_Rate2″ dataType=”number” value=”CP_Rate2″ />
<element name=”CP_adjusted_amount2″ dataType=”number” value=”CP_adjusted_amount2″ />
<element name=”Cd_trx_amount2″ dataType=”varchar2″ value=”CP_adjusted_amount2″ function=”CURRENCY_FORMAT” currencyCode=”org_trx_cur” width=”19″ />
<element name=”Cd_limit_curr_amt2″ dataType=”number” value=”cp_limit_curr_amt2″ function=”CURRENCY_FORMAT” currencyCode=”limit_currency” width=”19″ />
<element name=”CF_org_calc_amount” dataType=”number” value=”CF_org_calc_amount” />
</group>
</group>
<group name=”G_customer_limit” dataType=”varchar2″ source=”Q_customer_limit”>
<element name=”exchange_rate_type1″ dataType=”varchar2″ value=”EXCHANGE_RATE_TYPE” />
<element name=”trx_amount_due1″ dataType=”number” value=”TRX_AMOUNT_DUE” />
<element name=”trx_cur2″ dataType=”varchar2″ value=”TRX_CUR2″ />
<element name=”trx_cust2″ dataType=”number” value=”TRX_CUST2″ />
<element name=”CP_limit_curr_amt1″ dataType=”number” value=”CP_limit_curr_amt1″ />
<element name=”CP_rate1″ dataType=”number” value=”CP_rate1″ />
<element name=”CP_adjusted_amount1″ dataType=”number” value=”CP_adjusted_amount1″ />
<element name=”Cd_trx_amount1″ dataType=”varchar2″ value=”CP_adjusted_amount1″ function=”CURRENCY_FORMAT” currencyCode=”trx_cur2″ width=”19″ />
<element name=”Cd_limit_cur_amt1″ dataType=”varchar2″ value=”cp_limit_curr_amt1″ function=”CURRENCY_FORMAT” currencyCode=”limit_currency” width=”19″ />
<element name=”CF_CALC_RATE_AMOUNT_FORMULA1″ dataType=”number” value=”CF_CALC_RATE_AMOUNT_FORMULA1″ />
<element name=”trx_site2″ dataType=”number” value=”TRX_SITE2″ />
</group>
</group>
</group>
</group>
<element name=”RP_COMPANY_NAME” dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_COMPANY_NAME_p” />
<element name=”RP_REPORT_NAME” dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_REPORT_NAME_p” />
<element name=”RP_DATA_FOUND” dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_DATA_FOUND_p” />
<element name=”RP_DATE_RANGE” dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_DATE_RANGE_p” />
<element name=”RP_BUCKET_DAYS_FROM_0″ dataType=”number” value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_DAYS_FROM_0_p” />
<element name=”RP_BUCKET_DAYS_FROM_1″ dataType=”number” value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_DAYS_FROM_1_p” />
<element name=”RP_BUCKET_DAYS_FROM_2″ dataType=”number” value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_DAYS_FROM_2_p” />
<element name=”RP_BUCKET_DAYS_FROM_3″ dataType=”number” value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_DAYS_FROM_3_p” />
<element name=”RP_BUCKET_DAYS_FROM_4″ dataType=”number” value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_DAYS_FROM_4_p” />
<element name=”RP_BUCKET_DAYS_FROM_5″ dataType=”number” value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_DAYS_FROM_5_p” />
<element name=”RP_BUCKET_DAYS_TO_0″ dataType=”number” value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_DAYS_TO_0_p” />
<element name=”RP_BUCKET_DAYS_TO_1″ dataType=”number” value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_DAYS_TO_1_p” />
<element name=”RP_BUCKET_DAYS_TO_2″ dataType=”number” value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_DAYS_TO_2_p” />
<element name=”RP_BUCKET_DAYS_TO_3″ dataType=”number” value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_DAYS_TO_3_p” />
<element name=”RP_BUCKET_DAYS_TO_4″ dataType=”number” value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_DAYS_TO_4_p” />
<element name=”RP_BUCKET_DAYS_TO_5″ dataType=”number” value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_DAYS_TO_5_p” />
<element name=”RP_BUCKET_LINE_TYPE_0″ dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_LINE_TYPE_0_p” />
<element name=”RP_BUCKET_LINE_TYPE_1″ dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_LINE_TYPE_1_p” />
<element name=”RP_BUCKET_LINE_TYPE_2″ dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_LINE_TYPE_2_p” />
<element name=”RP_BUCKET_LINE_TYPE_3″ dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_LINE_TYPE_3_p” />
<element name=”RP_BUCKET_LINE_TYPE_4″ dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_LINE_TYPE_4_p” />
<element name=”RP_BUCKET_LINE_TYPE_5″ dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_LINE_TYPE_5_p” />
<element name=”RP_BUCKET_TITLE0″ dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_TITLE0_p” />
<element name=”RP_BUCKET_TITLE1″ dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_TITLE1_p” />
<element name=”RP_BUCKET_TITLE2″ dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_TITLE2_p” />
<element name=”RP_BUCKET_TITLE3″ dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_TITLE3_p” />
<element name=”RP_BUCKET_TITLE4″ dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_TITLE4_p” />
<element name=”RP_BUCKET_TITLE5″ dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_TITLE5_p” />
<element name=”RP_BUCKET_CATEGORY” dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_CATEGORY_p” />
<element name=”RP_BUCKET_DAYS_FROM_6″ dataType=”number” value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_DAYS_FROM_6_p” />
<element name=”RP_BUCKET_DAYS_TO_6″ dataType=”number” value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_DAYS_TO_6_p” />
<element name=”RP_BUCKET_LINE_TYPE_6″ dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_LINE_TYPE_6_p” />
<element name=”RP_BUCKET_TITLE6″ dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_BUCKET_TITLE6_p” />
<element name=”C_industry_code” dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.C_industry_code_p” />
<element name=”C_sales_title” dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.C_sales_title_p” />
<element name=”RP_UNAVAILABLE” dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_UNAVAILABLE_p” />
<element name=”RP_YEARS” dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_YEARS_p” />
<element name=”RP_NONE” dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_NONE_p” />
<element name=”RP_NA_UPPER” dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_NA_UPPER_p” />
<element name=”RP_NO_LIMIT” dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_NO_LIMIT_p” />
<element name=”RP_MESSAGE” dataType=”varchar2″ value=”AR_ARXCCS_XMLP_PKG.RP_MESSAGE_p” />
</dataStructure>
<dataTrigger name=”afterReportTrigger” source=”AR_ARXCCS_XMLP_PKG.afterreport()” />
</dataTemplate>

 

Summary

This Post described about Report would fetch and display all customer credit card snapshot details in excel format in Oracle EBS R12

Got any queries?

Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.

Recommended Posts

Start typing and press Enter to search