Code Snippets: Various Queries on Customer Data (HZ Tables)
Posted by anilrpatil on November 18, 2009
There have been many instances where I have been asked by the Business Users to provide Customer Listing reports based on different parameters. The different requests typically are as follows
- Customer listing with all Sites for a specific Org
- A listing of only those Customer with whom we have had transactions in the last ‘x’ years
- A listing of all Customer Sites that do not have any Business purpose associated with it
- Customer Listing By Collector
- Customer Listing along with Profile Class names and Collector names
- And so on …
We have the Standard Customer Listing Reports in the application. However these reports are not org stripped because the HZ_CUST_ACCOUNTS data is not org stripped plus the standard reports could not be used for all different flavors of the Business requests. In these cases, I used the following queries
Click here to read the queries
[Keywords: hz_parties, hz_cust_accounts, hz_cust_site_uses_all, hz_party_sites, hz_cust_acct_sites_all, hz_locations]
Advertisement
Robbie said
These queries were good. Can you update this for R12?