Search Results csc_acct_relationship_v




Overview
Explore in AI Chat

Overview

CSC_ACCT_RELATE_RELATIONSHIP_V is a view owned by the APPS schema within the CSC (Customer Care) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to retrieve related accounts for a customer account, exposing the relationship records that link one customer account to another through Oracle's Trading Community Architecture (TCA) and Receivables lookup infrastructure. The view provides a denormalized, read-only presentation of account-to-account relationships, resolving raw lookup codes into their descriptive equivalents so that downstream reporting, Customer Care self-service pages, and integration interfaces can consume relationship data without embedding multi-table join logic.

Because the view is defined in the APPS schema and is reported as VALID, it is treated as a supported read interface for querying account relationships. It is a key object where users investigate the CUSTOMER_RECIPROCAL_FLAG column, which indicates whether a defined relationship is reciprocal between the two accounts.

Underlying Base Objects

The view is defined over three documented base objects:

The relationship table is the driving source; the account master and both lookup references are joined to enrich each row. The outer join on RELATION_LOOKUP means relationships with an undefined relationship type code are still returned, with a null description.

Key Columns

Common Use Cases and Queries

Typical uses include Customer Care account 360 screens, relationship validation in integrations, and ad hoc reporting on account hierarchies and reciprocal relationships.

Retrieve all relationships for a given account:

  • SELECT related_account_name, related_account_number, relationship_description, customer_reciprocal_flag FROM csc_acct_relationship_v WHERE cust_account_id = :p_account_id;

List only reciprocal relationships:

  • SELECT cust_account_id, related_cust_account_id, relationship_type FROM csc_acct_relationship_v WHERE customer_reciprocal_flag = 'Y';

Filter active relationships by status description:

  • SELECT a.related_account_number, a.account_status_description FROM csc_acct_relationship_v a WHERE a.account_status_description = 'Active';

Because the view is read-only and resolves lookups internally, it is preferable to direct joins across the base TCA tables for ad hoc relationship queries.