Search Results vend_id




Overview
Explore in AI Chat

Overview

The PO_VEND_ASC table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the master repository for defining and storing formal associations or relationships between different vendor entities (suppliers) in the system. This functionality is critical for modeling complex supply chain scenarios where a single corporate entity may have multiple distinct vendor records, or where vendors have formal partnerships, subsidiaries, or other hierarchical linkages. The table enables the system to maintain and enforce these business relationships, which can influence procurement processes, reporting, and compliance.

Key Information Stored

The table's structure centers on identifying the parties involved and the nature of their association. The primary key is a composite of three columns, underscoring the uniqueness of a specific relationship definition. The critical columns are:

  • VEND_ID: The identifier for the primary vendor in the relationship.
  • ASSOCVEND_ID: The identifier for the associated or related vendor.
  • ASSOC_TYPE: A code defining the type of association (e.g., parent company, subsidiary, partner). The specific values are defined by the application's lookup codes.

Additionally, the table includes a TEXT_CODE column, which is a foreign key to the PO_TEXT_HDR table. This allows for attaching descriptive notes or terms and conditions specifically to the vendor association record.

Common Use Cases and Queries

A primary use case is consolidated reporting and analysis across a corporate family of suppliers. For instance, procurement analytics may require spend aggregation for all subsidiaries of a parent vendor. Another scenario is enforcing business rules during purchasing, such as preventing transactions with both a parent and its subsidiary simultaneously if prohibited by contract.

A typical query to retrieve all associations for a given vendor would be:

SELECT v.vend_name AS Primary_Vendor,
       av.vend_name AS Associated_Vendor,
       a.assoc_type
FROM   gml.po_vend_asc a,
       po_vend_mst v,
       po_vend_mst av
WHERE  a.vend_id = v.vend_id
AND    a.assocvend_id = av.vend_id
AND    a.vend_id = 12345;

This table is also essential for data integrity when vendor records are merged or inactivated, as the system must update or cascade changes through the defined relationships.

Related Objects

PO_VEND_ASC has direct dependencies on several key tables, as defined by its foreign key constraints:

  • PO_VEND_MST (Vendor Master): The table is referenced twice—once for the VEND_ID column and once for the ASSOCVEND_ID column. This ensures that both parties in an association are valid, active vendors in the system.
  • PO_TEXT_HDR (Text Header): The TEXT_CODE foreign key allows descriptive text to be linked to the association record.

The table's primary key constraint, PO_VEND_ASC_PK, enforces the uniqueness of each vendor relationship combination. As a table specific to the Process Manufacturing (GML) product family, its usage and integration are primarily within the logistics and procurement flows of that vertical.