Search Results po_vendor_list_headers




Overview
Explore in AI Chat

Overview

PO_VENDOR_LIST_HEADERS is a Purchasing (PO) module table that stores the header records for RFQ supplier lists in Oracle E-Business Suite 12.1.1 and 12.2.2. Each row represents a named supplier list that can be attached to a Request for Quotation so that the sourcing organization can control which suppliers are invited to respond. The table is owned by the PO schema and is classified as VALID in the ETRM repository.

From a dimensional modeling perspective, the metadata's heuristic Data Vault classification is hub-leaning. PO_VENDOR_LIST_HEADERS behaves as a business hub: it holds the durable identity of a supplier list (the list name and its owning operating unit) while supplier-level detail is captured separately in a dependent child table. The classification is a modeling suggestion only; in native EBS terms the table is a standard transactional/administrative master record with multi-org and audit column conventions.

Key Information Stored

The table contains 30 documented columns. The most significant are:

Common Use Cases and Queries

Reporting and integration scenarios typically resolve a supplier list header to its member suppliers, or validate that a list is active before an RFQ is issued.

  • List active supplier lists for an operating unit:
    SELECT vendor_list_header_id, vendor_list_name FROM po_vendor_list_headers WHERE org_id = :org_id AND inactive_date IS NULL;
  • Resolve list members by joining to the entries table:
    SELECT h.vendor_list_name, e.vendor_id FROM po_vendor_list_headers h, po_vendor_list_entries e WHERE h.vendor_list_header_id = e.vendor_list_header_id;
  • Audit recently changed lists using LAST_UPDATE_DATE and the concurrent program columns.
  • Map interfaced RFQ data back to a source list via PO_HEADERS_INTERFACE.VENDOR_LIST_HEADER_ID.

Because supplier lists are referenced during RFQ creation, queries against this table are commonly embedded in sourcing extracts and in validation logic for supplier invitation processes.

Related Objects

  • PO_VENDOR_LIST_ENTRIES — the child table holding individual suppliers on each list; joined on VENDOR_LIST_HEADER_ID, which is a foreign key back to this table.
  • PO_HEADERS_INTERFACE — the purchasing documents interface references VENDOR_LIST_HEADER_ID, allowing RFQs and related documents loaded through the interface to point at a source supplier list.
  • PO_VENDOR_LIST_HEADERS_PK / _U1 — the primary key constraint and unique index on VENDOR_LIST_HEADER_ID.
  • PO_VENDOR_LIST_HEADERS_U2 — the unique index on VENDOR_LIST_NAME and ORG_ID that enforces list-name uniqueness per operating unit.
  • PO_HEADERS_ALL, PO_LINES_ALL, and the RFQ/PO APIs — document tables and public APIs that consume supplier lists when building sourcing documents.

Together these objects form the supplier-list component of the RFQ sourcing model, with PO_VENDOR_LIST_HEADERS acting as the stable parent record and PO_VENDOR_LIST_ENTRIES supplying the member detail.