Search Results cust_account_number

Overview

The FUN_NET_RELATED_CUSTOMERS_V view is a reporting and integration object owned by the APPS schema in Oracle E-Business Suite, residing in the FND – Application Object Library product family. It presents the network of customer accounts that are related to a given party through receivable payment hierarchy relationships. Specifically, the view exposes customer accounts reachable from a parent party by traversing the HZ_HIERARCHY_NODES structure, filtered to relationship types belonging to the PARTY_REL_GRP_AR_PAY_TOP_DOWN and PARTY_REL_GRP_AR_PAY_ANY relationship-type groups. This allows applications and reports to resolve the set of related customers — and, critically, their account numbers and names — without embedding the complex hierarchy traversal logic themselves. It is a read-only presentation layer tailored for consumption in reporting, integration, and downstream processing scenarios where a flattened, denormalized listing of related accounts is required.

Underlying Base Objects

The view is defined over several HZ synonyms. The documented referenced base objects are HZ_CODE_ASSIGNMENTS, HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_RELATE_ALL, HZ_HIERARCHY_NODES, HZ_PARTIES, and HZ_RELATIONSHIP_TYPES. The primary driver in the view text is a join between HZ_HIERARCHY_NODES and HZ_CUST_ACCOUNTS, where a hierarchy node's child party identifier is matched to the customer account's party identifier. Relationship validity is enforced via an EXISTS subquery against HZ_CODE_ASSIGNMENTS joined to HZ_RELATIONSHIP_TYPES, confirming that the relationship type is active and belongs to the AR payment hierarchy group. Effective-dating is applied with SYSDATE BETWEEN HN.EFFECTIVE_START_DATE AND HN.EFFECTIVE_END_DATE, restricting results to currently active hierarchy nodes. The view is a UNION ALL of two branches: one retrieving direct children under a given party (top-down), and one retrieving the accounts beneath the top parent for pay-any hierarchies. Together these branches yield a comprehensive related-customer network.

Key Columns

• PARTY_ID — The parent (subject) party identifier from which the relationship network is evaluated.
• RELATED_PARTY_ID — The party identifier of the related customer account found within the hierarchy.
• RELATED_CUST_ACCOUNT_ID — The customer account identifier of the related party, sourced from HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID.
• CUST_ACCOUNT_NAME — The account name of the related customer.
• CUST_ACCOUNT_NUMBER — The account number of the related customer, derived from HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER. This is the column users typically search for as "cust_account_number."
• HIERARCHY_TYPE — The hierarchy or relationship type under which the related account is connected.
• RELATIONSHIP_TYPE_GROUP_NAME — A literal identifying the governing relationship-type group, either PARTY_REL_GRP_AR_PAY_TOP_DOWN or PARTY_REL_GRP_AR_PAY_ANY.

Common Use Cases and Queries

The view is commonly used to answer questions such as "which other customer accounts are related to this account number?" and to drive reporting centered on AR payment hierarchies.

To retrieve all related customer accounts for a specific account number:

SELECT related_cust_account_id,
       cust_account_number,
       cust_account_name,
       hierarchy_type,
       relationship_type_group_name
FROM   apps.fun_net_related_customers_v
WHERE  cust_account_number = :p_account_number;

To list all related accounts sharing a common parent party:

SELECT party_id,
       related_cust_account_id,
       cust_account_number
FROM   apps.fun_net_related_customers_v
WHERE  party_id = :p_party_id
ORDER  BY cust_account_number;

Because the view filters on SYSDATE, only currently effective relationships are returned, making it suitable for point-in-time operational reporting. Users searching for "cust_account_number" should note the related account number column is CUST_ACCOUNT_NUMBER, distinct from the account identifier columns.