Results for “lead_time”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PO_VNIT_MST is a table owned by the GML schema (Process Manufacturing Logistics) within Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as the Vendor Item master in the Oracle Process Manufacturing (OPM) purchasing domain, holding approved vendor-to-item sourcing records at the warehouse level. The table carries a documented status of VALID and is catalogued under the GML product family.

The ETRM documentation classifies PO_VNIT_MST as a vendor item table that is not supported in OPM Purchasing. This is a critical qualification: while the table exists physically in the schema with 19 documented columns, the Process Manufacturing purchasing flows do not consume it as an active source of vendor sourcing data. Practitioners should therefore treat it as a legacy or residual structure rather than an operational master.

From a Data Vault modeling perspective, the ETRM metadata assigns a heuristic classification of link. This is a modeling suggestion: the table's structure — a composite key spanning VENDOR_ID, ITEM_ID, and WHSE_CODE without extensive descriptive attributes — is characteristic of a relationship (link) entity connecting vendors, items, and warehouses rather than a hub or a descriptive satellite. The rating and MSDS attributes it carries behave as effectivity or quality descriptors on that link.

Key Information Stored

The primary key, PO_VNIT_MST_PK, is a composite business key comprising VENDOR_ID, ITEM_ID, and WHSE_CODE. These three columns establish uniqueness and represent the grain of the table: one row per vendor-item-warehouse combination.

• VENDOR_ID — identifies the supplier, referencing PO_VEND_MST.
• ITEM_ID — identifies the sourced item, referencing IC_ITEM_MST and IC_ITEM_MST_B.
• WHSE_CODE — the warehouse of record, referencing IC_WHSE_MST.
• LEAD_TIME — procurement lead time for the vendor-item-warehouse combination.
• TIMELINESS_RATING, PRICE_RATING, PREFERENCE_RATING, QUALITY_RATING — vendor performance and sourcing preference scores held against the relationship.
• MSDS_REQUIRED, MSDS_VERSION_NO, MSDS_ISSUANCE_DATE — Material Safety Data Sheet compliance attributes for the sourced item.
• DELETE_MARK — logical deletion flag rather than physical removal.
• TEXT_CODE — free-text or coded reference material.
• TRANS_CNT — transaction counter used for optimistic locking or change detection.
• CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle audit columns tracking record provenance and modification history.

Common Use Cases and Queries

Because OPM Purchasing does not support this table, the primary use cases are reconciliation, migration, and auditing of historical vendor-item associations. A typical query joins the table to its parent item master to resolve item descriptions for the base item:

• Vendor sourcing audit — list all vendor-item-warehouse combinations with lead time and ratings to assess preferred sources.
• MSDS compliance reporting — retrieve rows where MSDS_REQUIRED is set and MSDS_ISSUANCE_DATE is stale.
• Item master reconciliation — confirm every ITEM_ID in PO_VNIT_MST resolves to a valid IC_ITEM_MST_B or IC_ITEM_MST record.
• Logical deletion reporting — filter on DELETE_MARK to isolate active versus retired relationships.

A representative pattern is: SELECT p.VENDOR_ID, p.ITEM_ID, p.WHSE_CODE, p.LEAD_TIME FROM GML.PO_VNIT_MST p WHERE p.DELETE_MARK = 0, extended with joins to IC_ITEM_MST for descriptive item attributes.

Related Objects

• IC_ITEM_MST_B — joined on PO_VNIT_MST.ITEM_ID = IC_ITEM_MST_B.ITEM_ID; the base item master.
• IC_ITEM_MST — also joined on ITEM_ID; the item master view/table for descriptive attributes.
• IC_WHSE_MST — joined on PO_VNIT_MST.WHSE_CODE = IC_WHSE_MST.WHSE_CODE; the warehouse master.
• PO_VEND_MST — joined on PO_VNIT_MST.VENDOR_ID = PO_VEND_MST.VENDOR_ID; the vendor master.

These four foreign-key targets define the complete documented relationship surface of PO_VNIT_MST and provide the canonical join paths for any query or extract.