Search Results po_approved_supplier_list




Overview
Explore in AI Chat

Overview

The PO_APPROVED_SUPPLIER_LIST table is a core data repository within Oracle E-Business Suite Purchasing (PO) module. It serves as the system of record for the Approved Supplier List (ASL) functionality, a critical component of strategic sourcing and procurement control. The ASL defines which suppliers are authorized to supply specific items or item categories to specific buying organizations, often under negotiated terms. This table enforces procurement policies by ensuring that purchase orders and requisitions can only be created against pre-approved supplier and item relationships, thereby maintaining compliance and leveraging negotiated contracts.

Key Information Stored

The table stores the fundamental relationships that constitute an ASL entry. Its primary key is the ASL_ID, a unique system-generated identifier. The most critical foreign key columns are VENDOR_ID and VENDOR_SITE_ID, which link to PO_VENDORS and PO_VENDOR_SITES_ALL respectively to identify the approved supplier and ship-to location. Other essential columns typically include ITEM_ID and CATEGORY_ID to specify the approved item or item category, ORGANIZATION_ID to define the internal inventory organization, and RELEASE_GENERATION_METHOD to control blanket agreement usage. The table also commonly holds attributes for effective date ranges, manufacturing details, and review cycle information to manage the lifecycle of the supplier approval.

Common Use Cases and Queries

A primary use case is validating supplier-item approval during requisition entry or purchase order creation. Procurement analysts frequently query this table for reporting and maintenance. Common SQL patterns include identifying all approved suppliers for a specific item, or listing all items a particular vendor is approved to supply. For example, to find approved suppliers for an inventory item ID 1000, a query would join PO_APPROVED_SUPPLIER_LIST with PO_VENDORS on VENDOR_ID. Another critical report is identifying ASL entries nearing their expiration date to initiate supplier re-evaluation. Data from this table is also essential for sourcing analysis, showing the breadth of supplier coverage for categories of spend.

Related Objects

As indicated by the foreign keys in the metadata, this table has direct dependencies on foundational supplier tables. PO_VENDORS supplies the vendor master record, and PO_VENDOR_SITES_ALL provides the specific ship-to address. The table is heavily referenced by other Purchasing entities, such as PO_REQUISITION_LINES and PO_LINES_ALL, to validate the ASL_ID during document creation. Key APIs, like PO_APPROVED_SUPPLIER_LIST_PUB, provide the standard programmatic interface for creating and maintaining ASL records. The PO_ASL_DOCUMENTS table may store supporting documents for the approval, and the PO_ASL_ATTRIBUTES table often holds additional descriptive flexfield data for the ASL relationship.