Search Results po_vend_cls




Overview
Explore in AI Chat

Overview

The PO_VEND_CLS table is a core reference table within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the master repository for defining and maintaining vendor classification codes. In procurement and supply chain management, vendor classes are critical for categorizing suppliers based on predefined criteria such as business type, commodity supplied, or procurement strategy. This classification enables standardized reporting, streamlined sourcing, and the consistent application of business rules and approval workflows across groups of similar suppliers. Its role is foundational, providing a validated list of codes that ensure data integrity when classifying vendors in the broader supplier master data.

Key Information Stored

While the provided ETRM metadata does not list specific columns, the structure of a typical classification table and the documented constraints indicate the key data elements. The primary column is VEND_CLASS, which stores the unique alphanumeric code identifying the vendor class. Based on standard EBS design patterns, the table likely also includes descriptive columns such as a name (e.g., VEND_CLASS_DESC) and enabled/disabled status flags. The existence of a foreign key relationship with the PO_TEXT_HDR table via a TEXT_CODE column suggests PO_VEND_CLS also stores a reference to a standard text block, allowing for class-specific terms and conditions to be automatically associated with vendors in this category.

Common Use Cases and Queries

This table is primarily used in master data setup, reporting, and as a validation source. Common operational scenarios include populating list of values (LOVs) in the "Vendor Class" field during supplier entry in the PO_VEND_MST form and generating reports that segment supplier performance or spend analysis by class. A typical query to retrieve all active vendor classes with their descriptions and associated text would follow this pattern:

  • SELECT vend_class, vend_class_desc, text_code FROM gml.po_vend_cls WHERE enabled_flag = 'Y' ORDER BY vend_class;

For integration or data migration, scripts often reference this table to validate vendor class codes before loading records into the supplier master (PO_VEND_MST).

Related Objects

As per the documented foreign keys, PO_VEND_CLS has direct relationships with several key tables. The primary relationship is with the PO_VEND_MST (Vendor Master) table, where the VEND_CLASS column is a foreign key referencing PO_VEND_CLS. This enforces that every vendor's classification must be a valid code from this table. Secondly, a relationship with PO_TEXT_HDR exists via the TEXT_CODE column, linking a class to standardized contractual text. Consequently, any forms, reports, or APIs that interact with vendor classification or leveraged text for a vendor class will depend on this table.