Search Results op_cust_asc




Overview
Explore in AI Chat

Overview

The OP_CUST_ASC table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It is designed to store and manage customer relationships, specifically capturing various types of associations between different customer entities. This table acts as a relational hub, enabling complex business models where a customer can be linked to other customers in defined roles, such as parent-child hierarchies, partner relationships, or other business affiliations. Its existence is critical for supporting advanced logistics, billing, and customer management processes within the manufacturing context of Oracle EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is centered around defining the relationship between two customer entities. The primary key is a composite of three columns, ensuring a unique relationship definition: CUST_ID (the primary customer), ASSOC_TYPE (the type of association or relationship), and ASSOCCUST_ID (the associated customer). The table also includes a TEXT_CODE column, which is a foreign key to the OP_TEXT_HDR table, allowing for descriptive text or notes to be attached to the specific customer association. This design allows for flexible modeling of diverse customer linkage scenarios within the enterprise.

Common Use Cases and Queries

A primary use case is managing corporate hierarchies, where a parent company (CUST_ID) is associated with its subsidiaries (ASSOCCUST_ID) using a specific ASSOC_TYPE like 'PARENT'. This is essential for consolidated reporting and roll-up of financial or order data. Another scenario involves defining partner or broker relationships within a supply chain. Common queries include finding all associations for a given customer or identifying all customers of a specific association type. A sample SQL pattern to retrieve relationship details is:

  • SELECT cust_id, assoc_type, assoccust_id, text_code FROM gml.op_cust_asc WHERE cust_id = :p_customer_id;

Reporting often joins this table with OP_CUST_MST (customer master) twice—once for the primary customer details and once for the associated customer details—to generate meaningful relationship reports.

Related Objects

OP_CUST_ASC has defined dependencies on several other key tables, as indicated by its foreign keys. It references the OP_CUST_MST table twice: once via the CUST_ID column and once via the ASSOCCUST_ID column. This ensures referential integrity, meaning both the primary and associated customer IDs must exist as valid records in the customer master table. Furthermore, the TEXT_CODE column is a foreign key to the OP_TEXT_HDR table, which manages flexible descriptive text blocks within the application. The table's primary key constraint is named OP_CUST_ASC_PK. Understanding these relationships is crucial for any data integration, extension, or reporting effort involving customer associations.