Oracle eTRM details of PO ASL tables

Table: PO_APPROVED_SUPPLIER_LIST

Description:	Approved supplier list

Primary Key: PO_APPROVED_SUPPLIER_LIST_PK

1. ASL_ID

Foreign Keys from this table:

Foreign Key Column	Foreign Table
PO_APPROVED_SUPPLIER_LIST.VENDOR_SITE_ID	PO_VENDOR_SITES_ALL
PO_APPROVED_SUPPLIER_LIST.VENDOR_ID	PO_VENDORS

Oracle Apps Purchasing - ASL Sourcing to Requisitions Setup

This blog post steps through the required setups that are necessary in order to use Sourcing functionality that is provided by Oracle Purchasing. This functionality will default the Source Document, Supplier, and Supplier Site onto a requisition when either a category (commodity) or item is entered onto a requisition.

Prerequisites:
1) Define items.
2) Create suppliers and supplier sites in the Suppliers window.