Search Results mtl_supplier_sites_v




Overview
Explore in AI Chat

Overview

MTL_SUPPLIER_SITES_V is an APPS-owned database view in Oracle E-Business Suite, registered under the Inventory (INV) product module and marked VALID. It provides a consolidated, reporting-friendly projection of supplier site information by joining purchasing vendor site data to organization (operating unit) definitions. Because its defining query filters on purchasing-enabled and currently active supplier sites, the view exposes only those supplier sites that are usable for procurement-related activity rather than the complete set of vendor sites held in the purchasing tables.

The view is particularly relevant to the key term RFQ_ONLY_SITE_FLAG, which it surfaces directly. This flag identifies supplier sites restricted to Request for Quotation (RFQ) activity only, meaning the site may be invited to quote but is not necessarily approved for the full range of purchasing transactions such as standard purchase orders. Reporting and integration routines that must distinguish quotation-only suppliers from fully transacting suppliers can read this column from the view rather than querying the purchasing base tables directly.

Its multi-organization structure, keyed by ORGANIZATION_ID and OPERATING_UNIT, makes it suitable for operating-unit-scoped reporting and for integration extracts where a supplier site must be resolved to a specific inventory or operating organization context.

Underlying Base Objects

The documented metadata lists the following referenced base objects: FND_GLOBAL (Package), HR_GENERAL (Package), HR_SECURITY (Package), ORG_ORGANIZATION_DEFINITIONS (View), and PO_VENDOR_SITES_ALL (View). The registered view text confirms that MTL_SUPPLIER_SITES_V is defined as a join between PO_VENDOR_SITES_ALL (aliased PO) and ORG_ORGANIZATION_DEFINITIONS (aliased ORG). The three packages are referenced in the wider documented object set and are typically associated with the security and organization context that governs multi-org access to organization-related views.

The join condition is NVL(PO.ORG_ID, -99) = NVL(ORG.OPERATING_UNIT, -99), which links supplier site records to their owning operating unit. Two filters define the row set: PO.PURCHASING_SITE_FLAG = 'Y', restricting output to purchasing-enabled sites, and SYSDATE < NVL(PO.INACTIVE_DATE, SYSDATE + 1), which excludes sites whose inactive date has passed while retaining those with no inactive date. The RFQ_ONLY_SITE_FLAG and other descriptive attributes are projected from PO_VENDOR_SITES_ALL.

Key Columns

Common Use Cases and Queries

Typical uses include supplier site validation in procurement integrations, operating-unit-scoped supplier reporting, and identification of quotation-only suppliers. A representative query filtering on the searched flag follows:

  • SELECT organization_id, vendor_id, vendor_site_id, vendor_site_code, rfq_only_site_flag FROM mtl_supplier_sites_v WHERE rfq_only_site_flag = 'Y' ORDER BY vendor_site_code;
  • SELECT organization_id, vendor_site_code, city, country FROM mtl_supplier_sites_v WHERE operating_unit = :p_org_id;
  • SELECT vendor_id, vendor_site_code, ship_via_lookup_code, invoice_currency_code FROM mtl_supplier_sites_v WHERE vendor_id = :p_vendor_id AND NVL(rfq_only_site_flag,'N') = 'N';

Because the view already excludes inactive and non-purchasing sites, callers need no additional activity filters for standard supplier site lookups.