Oracle Fusion/Procurement/Suppliers

POZ_SUPPLIER_SITES_ALL_M

Supplier site — a specific address and purpose (ordering, pay/remit-to, RFQ) for a supplier; purchase orders and invoices reference a site, not just the supplier header.

Key Columns

VENDOR_SITE_IDVENDOR_IDPURCHASING_SITE_FLAGPAY_SITE_FLAG

Parent Table

POZ_SUPPLIERS

Supplier (vendor) header — the master record for a company or individual that Procurement and Payables transact with.

Common Joins

POZ_SUPPLIERSvia VENDOR_ID

The supplier this site belongs to.

PO_HEADERS_ALLvia VENDOR_SITE_ID

Purchase orders issued against this supplier site.

AP_INVOICES_ALLvia VENDOR_SITE_ID

AP invoices recorded against this supplier site.

Used In

PurchasingAP

Notes

Verify the exact table name (naming has shifted across releases) against your instance before relying on it.

Supplier data model: header vs. site

A Fusion supplier has a single header record (the company/individual identity) but one or more sites, each representing a distinct address and purpose — an ordering site a buyer creates POs against, and a pay/remit-to site AP sends payment to, which are often different addresses for the same supplier. Purchase orders and AP invoices both reference a specific supplier site, which is why '3-way matching' really means matching at the site level, not just the supplier level.