Search Results po_vendor_list_headers_u2

Overview

PO.PO_VENDOR_LIST_HEADERS is a transactional table in the Oracle Purchasing (PO) schema that stores the header-level definition of supplier quotation lists, also referred to as RFQ lists. Each row represents one supplier quotation list title, capturing its name, description, inactive status, and descriptive flexfield attributes. Oracle Purchasing uses this header information to group the supplier entries recorded in PO_VENDOR_LIST_ENTRIES, allowing buyers to build reusable sets of approved or candidate suppliers for sourcing and RFQ activity.

This table corresponds to the header region of the Supplier Lists window in the Purchasing application. It is one of two tables that jointly store supplier quotation list information; the companion detail table holds the individual supplier entries associated with each list. The primary key is VENDOR_LIST_HEADER_ID, populated from the sequence VENDOR_LIST_HEADERS_S. The table resides in the APPS_TS_TX_DATA tablespace with PCT Free 5, and its unique indexes are stored in APPS_TS_TX_IDX.

From a Data Vault modeling perspective, the mined classification for this object is hub-leaning. This suggests treating PO_VENDOR_LIST_HEADERS as the durable business-key hub representing a supplier quotation list, with descriptive and audit attributes (such as DESCRIPTION, INACTIVE_DATE, and the flexfield columns) available for modeling as a satellite if a normalized warehouse representation is required.

Key Information Stored

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

• VENDOR_LIST_HEADER_ID — NUMBER. Surrogate primary key and unique identifier for the supplier quotation list. Enforced by the unique index PO_VENDOR_LIST_HEADERS_U1.
• VENDOR_LIST_NAME — VARCHAR2(25). The business name of the RFQ list. Together with ORG_ID this forms the second unique index, PO_VENDOR_LIST_HEADERS_U2, which is the principal business-key candidate for the list within a given operating unit.
• ORG_ID — NUMBER. Operating unit identifier that partitions supplier lists by organization and participates in the PO_VENDOR_LIST_HEADERS_U2 business key.
• DESCRIPTION — VARCHAR2(240). Free-text description of the RFQ list.
• INACTIVE_DATE — DATE. Effective inactive date for the record, used to retire a list without deleting it.
• CREATION_DATE, CREATED_BY — Standard Who columns recording when and by whom the row was created.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Who columns capturing the most recent update event and the operating system login responsible.
• ATTRIBUTE_CATEGORY — VARCHAR2(30). Descriptive flexfield structure definition column.
• ATTRIBUTE1 through ATTRIBUTE15 — VARCHAR2(150). Descriptive flexfield segment columns for customer-defined list attributes.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program context columns identifying the request that last touched the row.

Common Use Cases and Queries

Supplier quotation lists are commonly queried for sourcing setup, RFQ preparation, and audit reporting. A typical lookup retrieves active lists for an operating unit:

• List all quotation lists for an organization: SELECT vendor_list_header_id, vendor_list_name, description FROM po_vendor_list_headers WHERE org_id = :p_org_id ORDER BY vendor_list_name;
• Resolve a list by its business name: join PO_VENDOR_LIST_ENTRIES on VENDOR_LIST_HEADER_ID to return the suppliers belonging to a named list.
• Identify inactive or retired lists for cleanup: SELECT vendor_list_header_id, vendor_list_name, inactive_date FROM po_vendor_list_headers WHERE inactive_date IS NOT NULL AND inactive_date <= SYSDATE;
• Audit recently changed lists: filter on LAST_UPDATE_DATE and LAST_UPDATED_BY, resolving the user via FND_USER.USER_ID.
• Backfill or interface population: PO_HEADERS_INTERFACE carries VENDOR_LIST_HEADER_ID, so header records can be matched when importing purchasing documents that reference a quotation list.

Reports frequently join headers to entries to produce a list-to-supplier matrix, and to PO_HEADERS_INTERFACE for interface validation and reconciliation.

Related Objects

• PO_VENDOR_LIST_ENTRIES — Child detail table. Joins on PO_VENDOR_LIST_ENTRIES.VENDOR_LIST_HEADER_ID = PO_VENDOR_LIST_HEADERS.VENDOR_LIST_HEADER_ID, holding the individual suppliers on each list.
• PO_HEADERS_INTERFACE — Interface table referencing this table via VENDOR_LIST_HEADER_ID, used when importing purchasing documents tied to a quotation list.
• PO_VENDOR_LIST_HEADERS_U1 / _U2 — Unique indexes enforcing the surrogate key and the (VENDOR_LIST_NAME, ORG_ID) business key.
• VENDOR_LIST_HEADERS_S — Sequence that generates the primary key values.
• FND_USER — Referenced by CREATED_BY and LAST_UPDATED_BY for Who-column resolution.
• FND_LOGINS — Referenced by LAST_UPDATE_LOGIN.

Together these objects define the complete supplier quotation list model used throughout Oracle Purchasing sourcing workflows.