Search Results po_vnit_mst




Overview
Explore in AI Chat

Overview

The PO_VNIT_MST table is a core data object within the Process Manufacturing Logistics (GML) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. As a vendor item master table, it is designed to store and manage relationships between specific items, vendors, and warehouses. Its primary role is to facilitate procurement processes by defining which items are sourced from which suppliers and the applicable warehouse locations for that sourcing. The official ETRM documentation explicitly notes that this table is "not supported in OPM Purchasing," indicating its usage is specific to the GML purchasing flows and not the broader Oracle Process Manufacturing (OPM) purchasing functionality. This delineation is critical for implementation and integration planning.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies a vendor item record. The key columns are VENDOR_ID, ITEM_ID, and WHSE_CODE. This combination ensures that for a given item and warehouse, a specific vendor relationship is defined. While the provided metadata does not list all columns, the foreign key relationships imply the table likely stores additional attributes pertaining to the vendor-item-warehouse association, which could include lead times, preferred status, pricing agreements, or minimum order quantities. The primary data entities it links are the vendor (from PO_VEND_MST), the item (from IC_ITEM_MST or IC_ITEM_MST_B), and the warehouse (from IC_WHSE_MST).

Common Use Cases and Queries

This table is essential for generating reports and enforcing business rules in GML procurement. A common use case is validating approved vendor lists during purchase order entry or requisition creation. System logic can query PO_VNIT_MST to confirm if a selected item can be sourced from a chosen vendor for a specific warehouse. Reporting use cases include generating lists of all approved vendors for a critical item or identifying all items sourced from a particular supplier. A foundational query pattern would be:

  • SELECT vnt.*, vend.vendor_name, item.item_no, whse.whse_code FROM gml.po_vnit_mst vnt JOIN po_vend_mst vend ON vnt.vendor_id = vend.vendor_id JOIN ic_item_mst item ON vnt.item_id = item.item_id JOIN ic_whse_mst whse ON vnt.whse_code = whse.whse_code WHERE item.item_no = '<ITEM_NUMBER>';

This retrieves all vendor relationships for a specified item across warehouses.

Related Objects

PO_VNIT_MST is centrally connected to several master tables in the GML schema, as defined by its foreign key constraints. Its integrity depends on the existence of records in these related tables:

  • PO_VEND_MST: The vendor master table. The VENDOR_ID column in PO_VNIT_MST references this table.
  • IC_ITEM_MST / IC_ITEM_MST_B: The item master tables. The ITEM_ID column references these tables to define the procured item.
  • IC_WHSE_MST: The warehouse master table. The WHSE_CODE column references this table to specify the applicable inventory organization.

These relationships ensure that any vendor item record corresponds to valid, existing entities within the system's foundational data.