HZ_customer_profiles in fusion

HZ_customer_profiles in fusion

In this post , we will discuss about HZ_customer_profiles in fusion. This table helps to store the customer Profiles Information's like Credit Limit , Payment Terms , Currency Collector name , Discount Related Information and Interest Information's and many other Important Information's of the Customers. Here below is the Important HZ_customer_profiles in fusion Tables and SQL query of Customer Profile Information in Oracle apps.

Tables of HZ_customer_profiles in fusion

1.HZ_CUSTOMER_PROFILES
2.HZ_CUST_PROFILE_CLASSES
3.HZ_CUST_PROFILE_AMTS_F : The HZ_CUST_PROFILE_AMTS table stores information about the credit limits specified for a customer profile in different currencies. This table is a child of the HZ_CUSTOMER_PROFILES table, which stores the profile information for customer accounts, customer account sites, or parties
4.AR_AUTOCASH_HIERARCHIES

SQL Query of HZ_customer_profiles in fusion

SELECT cp.cust_account_profile_id,

       cp.cust_account_id,

       cp.collector_id,

       col.NAME collector_name,

       cp.profile_class_id,

       cpc.NAME profile_class_name,

       cp.site_use_id,

       term.NAME standard_terms,

       cp.statement_cycle_id,

       cyc.NAME statement_cycle_name,

       cp.autocash_hierarchy_id,

       hier.hierarchy_name autocash_hierarchy_name,

       cp.grouping_rule_id,

       grp.NAME grouping_rule_name,

       cp.autocash_hierarchy_id_for_adr,

       hier_adr.hierarchy_name autocash_hierarchy_name_adr,

       cp.*

  FROM hz_customer_profiles cp,

       ar_collectors col,

       hz_cust_profile_classes cpc,

       ar_dunning_letter_sets dun_set,

       ar_statement_cycles cyc,

       ar_autocash_hierarchies hier,

       ra_grouping_rules grp,

       ra_terms term,

       ar_autocash_hierarchies hier_adr

 WHERE cp.collector_id          = col.collector_id

   AND cp.profile_class_id      = cpc.profile_class_id(+)

   AND cp.dunning_letter_set_id = dun_set.dunning_letter_set_id(+)

   AND cp.statement_cycle_id    = cyc.statement_cycle_id(+)

   AND cp.autocash_hierarchy_id = hier.autocash_hierarchy_id(+)

   AND cp.grouping_rule_id      = grp.grouping_rule_id(+)

   AND cp.standard_terms        = term.term_id(+)

   AND cp.autocash_hierarchy_id_for_adr = hier_adr.autocash_hierarchy_id(+)

   AND cp.party_id              = vl_party_id

   AND cp.cust_account_id       = vl_cust_account_id

   AND cp.site_use_id           = vl_site_use_id