<ROOT>
 <APPS_INITIALIZE_DATA>
  <USER_NAME>ENGINATICS</USER_NAME>
  <RESPONSIBILITY_KEY>SYSTEM_ADMINISTRATOR</RESPONSIBILITY_KEY>
  <APPLICATION_SHORT_NAME>SYSADMIN</APPLICATION_SHORT_NAME>
 </APPS_INITIALIZE_DATA>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: AR Customer Profiles -->
 <REPORTS_ROW>
  <GUID>61AD1DAE484E4EC1A60F63B3FE5FFD54</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
hp.party_name customer_name,
hp.duns_number_c duns_number,
hca.account_number,
haouv.name operating_unit,
hcsua.location site_location,
hps.party_site_number site_number,
hps.party_site_name site_name,
hz_format_pub.format_address(hps.location_id,null,null,&apos; , &apos;) site_address,
ftv.territory_short_name site_country,
xxen_util.meaning(hcsua.site_use_code,&apos;SITE_USE_CODE&apos;,222) site_use,
case
when hcp.site_use_id is not null then nvl(xxen_util.meaning(&apos;SITE&apos;,&apos;HZ_CONS_BILL_LEVEL&apos;,222),&apos;Site&apos;)
when hcp.cust_account_id=-1 then nvl(xxen_util.meaning(&apos;PARTY&apos;,&apos;REQUESTED_BY&apos;,222),&apos;Party&apos;)
else nvl(xxen_util.meaning(&apos;ACCOUNT&apos;,&apos;HZ_CONS_BILL_LEVEL&apos;,222),&apos;Account&apos;)
end profile_level,
hcpc.name profile_class,
hcpc.description profile_class_description,
xxen_util.meaning(hcp.status,&apos;CODE_STATUS&apos;,222) profile_status,
rtv.name payment_terms,
xxen_util.yes(hcp.override_terms) override_terms,
xxen_util.yes(hcp.discount_terms) discount_allowed,
hcp.discount_grace_days,
hcp.payment_grace_days receipt_grace_days,
ac.name collector,
xxen_util.meaning(hcp.credit_rating,&apos;CREDIT_RATING&apos;,222) credit_rating,
hcp.last_credit_review_date,
hcp.next_credit_review_date,
xxen_util.meaning(hcp.risk_code,&apos;RISK_CODE&apos;,222) risk_code,
xxen_util.yes(hcp.credit_hold) credit_hold,
xxen_util.yes(hcp.credit_checking) credit_check,
hcp.tolerance,
hcp.percent_collectable,
xxen_util.meaning(hcp.account_status,&apos;ACCOUNT_STATUS&apos;,222) account_status,
xxen_util.yes(hcp.send_statements) send_statements,
ascl.name statement_cycle,
xxen_util.yes(hcp.credit_balance_statements) send_credit_balance_statements,
xxen_util.yes(hcp.interest_charges) charge_interest,
hcp.interest_period_days,
xxen_util.yes(hcp.charge_on_finance_charge_flag) compound_interest,
xxen_util.yes(hcp.dunning_letters) dunning_letters,
adls.name dunning_letter_set,
aah.hierarchy_name autocash_rule_set,
xxen_util.yes(hcp.auto_rec_incl_disputed_flag) include_disputed_items,
xxen_util.meaning(hcp.tax_printing_option,&apos;TAX_PRINTING_OPTION&apos;,222) tax_printing,
rgr.name grouping_rule,
xxen_util.yes(hcp.cons_inv_flag) balance_forward_billing,
xxen_util.meaning(decode(hcp.cons_inv_flag,&apos;Y&apos;,nvl(hcp.cons_inv_type,&apos;SUMMARY&apos;),hcp.cons_inv_type),&apos;HZ_CONS_INV_TYPE&apos;,222) balance_forward_bill_type,
hcpa.currency_code,
hcpa.interest_rate,
hcpa.max_interest_charge,
hcpa.min_fc_balance_amount min_finance_charge_balance,
hcpa.min_fc_invoice_amount min_finance_charge_invoice,
hcpa.min_statement_amount,
hcpa.auto_rec_min_receipt_amount min_receipt_amount,
hcpa.min_dunning_amount,
hcpa.min_dunning_invoice_amount,
hcpa.overall_credit_limit credit_limit,
hcpa.trx_credit_limit order_credit_limit
from
hz_cust_accounts hca,
hz_parties hp,
(
select
hcp.cust_account_id join_cust_account_id,
hcp.*
from
hz_customer_profiles hcp
union all
select
hca0.cust_account_id join_cust_account_id,
hcp.*
from
hz_cust_accounts hca0,
hz_customer_profiles hcp
where
hca0.party_id=hcp.party_id and
hcp.cust_account_id=-1
) hcp,
hz_cust_profile_classes hcpc,
ar_collectors ac,
ra_terms_vl rtv,
ar_statement_cycles ascl,
ar_dunning_letter_sets adls,
ar_autocash_hierarchies aah,
ra_grouping_rules rgr,
hz_cust_site_uses_all hcsua,
hz_cust_acct_sites_all hcasa,
hz_party_sites hps,
hr_all_organization_units_vl haouv,
fnd_territories_vl ftv,
hz_locations hl,
hz_cust_profile_amts hcpa
where
1=1 and
hca.cust_account_id=hcp.join_cust_account_id and
hca.party_id=hp.party_id and
hcp.profile_class_id=hcpc.profile_class_id(+) and
hcp.collector_id=ac.collector_id and
hcp.standard_terms=rtv.term_id(+) and
hcp.statement_cycle_id=ascl.statement_cycle_id(+) and
hcp.dunning_letter_set_id=adls.dunning_letter_set_id(+) and
hcp.autocash_hierarchy_id=aah.autocash_hierarchy_id(+) and
hcp.grouping_rule_id=rgr.grouping_rule_id(+) and
hcp.site_use_id=hcsua.site_use_id(+) and
hcsua.cust_acct_site_id=hcasa.cust_acct_site_id(+) and
hcsua.org_id=haouv.organization_id(+) and
hcasa.party_site_id=hps.party_site_id(+) and
hps.location_id=hl.location_id(+) and
hl.country=ftv.territory_code(+) and
hcp.cust_account_profile_id=hcpa.cust_account_profile_id(+) and
(hcp.site_use_id is null or hcsua.site_use_code in (&apos;BILL_TO&apos;,&apos;STMTS&apos;,&apos;DUN&apos;) and hcsua.org_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;OU&apos;))
order by
hp.party_name,
hca.account_number,
hcsua.location,
decode(hcp.cust_account_id,-1,2,1),
hcpa.currency_code</SQL_TEXT>
  <VERSION_COMMENTS>Party profiles, Profile Level, DUNS Number, Site Name and credit review date columns. Site profiles of Bill To, Statements and Dunning site uses only. The Operating Unit parameter selects the accounts with a site in the operating unit. Show active only parameter.</VERSION_COMMENTS>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>AR تقرير مراجع العميل (بتنسيق XML)</REPORT_NAME>
    <DESCRIPTION>Application: المقبوضات
Source: تقرير مراجع العميل (بتنسيق XML)
Short Name: ARXCCP_XML
DB package: AR_ARXCCP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>AR Kunden - Kreditprofile</REPORT_NAME>
    <DESCRIPTION>Application: Debitoren
Source: Kunden - Kreditprofile (XML)
Short Name: ARXCCP_XML
DB package: AR_ARXCCP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>AR Etat Profils de crédit clients</REPORT_NAME>
    <DESCRIPTION>Application: Receivables
Source: Etat Profils de crédit clients (XML)
Short Name: ARXCCP_XML
DB package: AR_ARXCCP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>AR Customer Profiles</REPORT_NAME>
    <DESCRIPTION>Customer party, account and site level profile details such as profile class, payment terms, statement, dunning, collector and credit settings, including the profile amount limits per currency.

A party profile is reported once for each account of the party, and site level profiles for Bill To, Statements and Dunning site uses only. The Operating Unit parameter selects the accounts with a site in the operating unit, with their party and account profiles and their site profiles in that operating unit.

Application: Receivables
Source: Customer Profiles Report (XML)
Short Name: ARXCCP_XML
DB package: AR_ARXCCP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>AR 客户配置文件报表</REPORT_NAME>
    <DESCRIPTION>Application: 应收帐款
Source: 客户配置文件报表 (XML)
Short Name: ARXCCP_XML
DB package: AR_ARXCCP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Enginatics</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>1=1</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>hca.cust_account_id in (select hcasa2.cust_account_id from hz_cust_acct_sites_all hcasa2, hr_operating_units hou where hcasa2.org_id=hou.organization_id and hou.name=:operating_unit) and (hcp.site_use_id is null or haouv.name=:operating_unit)</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>HR Operating Unit</LOV_NAME>
    <LOV_GUID>8E2FF36EDEB979D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
hou.name value,
null description
from
hr_operating_units hou
where
sysdate between hou.date_from and nvl(hou.date_to,sysdate) and
(:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)=&apos;Y&apos;)) and
hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;OU&apos;)
order by
hou.name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>رقم العميل من</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Von Kundennummer</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Numéro de client - De</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Operating Unit</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>客户编号下限</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>upper(hp.party_name) like upper(:customer_name)</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>AR Customer Name</LOV_NAME>
    <LOV_GUID>8E2FF36EDE8679D2E0530100007F1FF2</LOV_GUID>
    <FREE_TEXT>Y</FREE_TEXT>
    <LOV_QUERY_DSP>select
hp.party_name value,
hca.account_number||&apos; (&apos;||initcap(hp.party_type)||&apos;)&apos;  description
from
hz_parties hp,
hz_cust_accounts hca
where
hp.party_id=hca.party_id and
hca.cust_account_id in (
select
hcasa.cust_account_id
from
hr_all_organization_units_vl haouv,
hz_cust_acct_sites_all hcasa
where
xxen_util.contains(:$flex$.operating_unit,haouv.name)=&apos;Y&apos; and
haouv.organization_id=hcasa.org_id
union all
select
hca2.cust_account_id
from
hz_cust_accounts hca2
where
:$flex$.operating_unit is null
)
order by
hp.party_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>رقم العميل إلى</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Bis Kundennummer</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Numéro de client - A</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Customer Name</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>客户编号上限</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>3</SORT_ORDER>
    <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>hca.account_number=:account_number</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>AR Account Number</LOV_NAME>
    <LOV_GUID>8E2FF36EDE7F79D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
hca.account_number value,
hp.party_name||&apos; (&apos;||initcap(hp.party_type)||&apos;)&apos; description
from
hz_parties hp,
hz_cust_accounts hca
where
hp.party_id=hca.party_id and
hca.cust_account_id in (
select
hcasa.cust_account_id
from
hr_all_organization_units_vl haouv,
hz_cust_acct_sites_all hcasa
where
xxen_util.contains(:$flex$.operating_unit,haouv.name)=&apos;Y&apos; and
haouv.organization_id=hcasa.org_id
union all
select
hca2.cust_account_id
from
hz_cust_accounts hca2
where
:$flex$.operating_unit is null
)
order by
hp.party_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Account Number</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>4</SORT_ORDER>
    <DISPLAY_SEQUENCE>40</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>hca.account_number&gt;=:account_number_from</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Account Number From</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>5</SORT_ORDER>
    <DISPLAY_SEQUENCE>50</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>hca.account_number&lt;=:account_number_to</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>:$flex$.Account_Number_From</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Account Number To</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>6</SORT_ORDER>
    <DISPLAY_SEQUENCE>60</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>hcpc.name=:profile_class</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
hcpc.name value,
hcpc.description
from
hz_cust_profile_classes hcpc
order by
hcpc.name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Profile Class</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>7</SORT_ORDER>
    <DISPLAY_SEQUENCE>70</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>ac.name=:collector</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
ac.name value,
ac.description
from
ar_collectors ac
order by
ac.name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Collector</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>8</SORT_ORDER>
    <DISPLAY_SEQUENCE>80</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>hcp.credit_hold=:credit_hold</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>Yes</LOV_NAME>
    <LOV_GUID>8E2FF36EDEA679D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select &apos;Y&apos; id, xxen_util.meaning(&apos;Y&apos;,&apos;YES_NO&apos;,0) value, null description from dual</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Credit Hold</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>9</SORT_ORDER>
    <DISPLAY_SEQUENCE>90</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>hp.status=&apos;A&apos; and
hca.status=&apos;A&apos; and
nvl(hcasa.status,&apos;A&apos;)=&apos;A&apos; and
nvl(hcsua.status,&apos;A&apos;)=&apos;A&apos;</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>Yes</LOV_NAME>
    <LOV_GUID>8E2FF36EDEA679D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select &apos;Y&apos; id, xxen_util.meaning(&apos;Y&apos;,&apos;YES_NO&apos;,0) value, null description from dual</LOV_QUERY_DSP>
    <DEFAULT_VALUE>Y</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Show active only</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
