AR Customer Profiles

Description

Categories
Enginatics
Application
Receivables
Source
Customer Profiles Report (XML)
Short Name
ARXCCP_XML
DB package
AR_ARXCCP_XMLP_PKG
Repository
GitHub
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.

SQL 118 lines

Parameters 9

ParameterTypeList of values SQL
Operating UnitLOV
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)
Customer NameLOV
upper(hp.party_name) like upper(:customer_name)
Account NumberLOV
hca.account_number=:account_number
Account Number FromChar
hca.account_number>=:account_number_from
Account Number ToChar
hca.account_number<=:account_number_to
Profile ClassLOV
hcpc.name=:profile_class
CollectorLOV
ac.name=:collector
Credit HoldLOV
hcp.credit_hold=:credit_hold
Show active onlyLOV
hp.status='A' and
hca.status='A' and
nvl(hcasa.status,'A')='A' and
nvl(hcsua.status,'A')='A'