Search Results po_vendor_list_entries




Overview
Explore in AI Chat

Overview

PO_VENDOR_LIST_ENTRIES is a Purchasing (PO) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the individual supplier (vendor) list entries associated with a Request for Quotation (RFQ). Each row represents a single supplier — including its site and contact — that has been invited or considered for a specific RFQ sourcing event. The table operates under the PO schema and is classified as VALID in the ETRM data model.

From a dimensional modeling perspective, the heuristic Data Vault classification for this table is link. This reflects its role as an associative structure that resolves many-to-many relationships between RFQ sourcing documents and the supplier master entities. The table does not carry saturating descriptive payload beyond audit and DFF columns; instead, it connects an RFQ header to vendors, vendor sites, and vendor contacts.

Key Information Stored

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

The surrogate key uniquely identifies each supplier line, while the vendor/site/contact combination defines the sourcing intent for that RFQ.

Common Use Cases and Queries

Typical scenarios include reporting on RFQ invitee lists, auditing which suppliers were solicited for a given sourcing event, and reconciling supplier responses. A representative query joining to the header and vendor master is:

  • SELECT vle.vendor_list_entry_id, vle.vendor_id, vle.vendor_site_id FROM po.po_vendor_list_entries vle WHERE vle.vendor_list_header_id = :p_header_id;
  • Join PO_VENDORS and PO_VENDOR_SITES_ALL to resolve supplier names and site codes for RFQ distribution reports.
  • Join PO_VENDOR_CONTACTS to produce contact-level invitation lists.
  • Use REQUEST_ID and PROGRAM_ID to trace which concurrent program populated supplier entries for audit or troubleshooting.

Reporting use cases include RFQ cycle-time analysis, supplier participation counts, and DFF-driven supplier categorization.

Related Objects

The following objects are directly related through documented foreign keys:

  • PO_VENDOR_LIST_HEADERS — Parent RFQ supplier list; joined on VENDOR_LIST_HEADER_ID.
  • PO_VENDORS — Supplier master; joined on VENDOR_ID.
  • PO_VENDOR_SITES_ALL — Supplier sites; joined on VENDOR_SITE_ID.
  • PO_VENDOR_CONTACTS — Supplier contacts; joined on VENDOR_CONTACT_ID.

These four relationships form the core reference graph for RFQ supplier list maintenance and reporting in Oracle Purchasing.