Search Results po_vtrd_cls




Overview
Explore in AI Chat

Overview

The PO_VTRD_CLS table is a master data table within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as a foundational repository for vendor trade class codes, which are critical for categorizing and segmenting suppliers based on their business type or the nature of goods and services they provide. This classification is essential for enabling structured procurement processes, targeted reporting, and streamlined vendor management within a process manufacturing environment. The table's status as VALID and its ownership under the GML schema confirm its active role in the application's data architecture for both EBS 12.1.1 and 12.2.2 versions.

Key Information Stored

The core data element stored in PO_VTRD_CLS is the vendor trade class code. While the provided metadata does not list all column definitions, the primary key constraint PO_VTRD_CLS_PK on the column VENDTRADE_CLASS indicates this is the unique identifier for each trade class record. Typically, such a table would also contain descriptive columns, such as a name or description for the class, and potentially control attributes like enabled flags or creation dates. The table's design ensures referential integrity for vendor data across the procurement system.

Common Use Cases and Queries

The primary use case for PO_VTRD_CLS is to maintain the list of valid trade classes that can be assigned to vendors during their setup or maintenance. This enables organizations to filter, report, and analyze procurement activities by supplier type. A common reporting requirement is to list all vendors belonging to a specific trade class. A sample SQL pattern for such analysis would involve joining with the PO_VEND_MST table:

Another frequent operational query is to retrieve the list of all active trade class codes available for assignment in a vendor form or API integration.

Related Objects

PO_VTRD_CLS has defined relationships with several other key EBS tables, as indicated by its foreign key constraints. The PO_VEND_MST (Vendor Master) table holds a direct foreign key reference (PO_VEND_MST.VENDTRADE_CLASS) to PO_VTRD_CLS, meaning each vendor record can be associated with a single, valid trade class. This is the most significant relationship, anchoring the classification to the vendor base. Additionally, the table is referenced by the PO_TEXT_HDR table via the PO_VTRD_CLS.TEXT_CODE foreign key, suggesting that descriptive text (such as terms and conditions) can be associated at the trade class level. These relationships underscore the table's role as a central reference point for vendor categorization and its associated business rules.