Search Results vendor_item

Overview

APPS.POS_PO_SUPPLIER_ITEMS_V is a public Oracle E-Business Suite view owned by the APPS schema and registered under FND Design Data as PO.POS_PO_SUPPLIER_ITEMS_V. Its documented purpose is to display items from the Approved Supplier List (ASL), joining sourcing and supplier information with inventory item definitions. Because it is a public view, Oracle classifies it as potentially useful for custom reporting and other data requirements; it is not an internal-only or private object. The view is marked VALID in the ETRM 12.2.2 repository, which is significant because it exposes a stable, published column contract that developers can rely upon without querying the underlying Purchasing and Inventory tables directly.

The view is the natural access point when the requirement is to return the vendor-item relationship: the combination of an internal inventory item, a supplier, a supplier site, and the supplier's own item number. This makes it relevant to both reporting and integration scenarios, including supplier catalog extracts, ASL validation extracts, and any customization that needs to reconcile a buyer-facing item number with the vendor's corresponding part number.

Underlying Base Objects

The view is defined over a set of APPS synonyms and views. The documented dependencies are:

• PO_APPROVED_SUPPLIER_LIST — the Approved Supplier List, the core sourcing record linking items to suppliers and supplier sites.
• PO_ASL_ATTRIBUTES — attribute-level details attached to ASL entries, including the vendor item field.
• PO_ASL_STATUS_RULES — status rules governing approval/active state of ASL records.
• PO_VENDORS and PO_VENDOR_SITES_ALL — supplier header and supplier site information.
• MTL_SYSTEM_ITEMS_VL — the inventory item master view supplying item number and description.
• MTL_PARAMETERS — inventory organization parameters, used to resolve organization context.
• HR_ALL_ORGANIZATION_UNITS_TL and PER_ALL_PEOPLE_F — organization and person (buyer) name resolution.
• FND_GLOBAL — the standard EBS package used to derive session context such as the current user and organization.

The joins therefore combine Purchasing sourcing data, Inventory item master data, and HR organization/person data.

Key Columns

• ITEM_NUM, ITEM_DESCRIPTION, UNIT_OF_MEASURE, ITEM_ID — the internal inventory item and its identifier.
• VENDOR_ITEM — the supplier's own item number from the ASL attribute record; the column most directly associated with a "vendor item" search.
• VENDOR_NAME, VENDOR_NUMBER, VENDOR_ID — supplier identification.
• VENDOR_SITE_CODE, VENDOR_SITE_ID — purchasing site for the supplier.
• BUYER_ID, BUYER_NAME — the assigned buyer.
• INVENTORY_ORGANIZATION_ID, ORG_NAME, ORGANIZATION_CODE — the inventory organization in which the item/ASL relationship applies.
• SUPPLIER_URL, ITEM_URL — URLs associated with the supplier or item.
• CONSIGNED_FROM_SUPPLIER_FLAG, ENABLE_VMI_FLAG — sourcing flags indicating consignment and Vendor Managed Inventory enablement.

Common Use Cases and Queries

Typical uses include ASL reporting, supplier catalog and punchout extracts, and lookups that map an internal item to a vendor part number. The following query lists vendor items for a given supplier:

SELECT item_num, item_description, uom.* FROM (SELECT item_num, item_description, unit_of_measure, vendor_item, vendor_name, vendor_site_code, organization_code FROM apps.pos_po_supplier_items_v WHERE vendor_id = :p_vendor_id AND organization_code = :p_org) uom;

A more direct form, matching the documented query text, is:

SELECT item_num, item_description, unit_of_measure, item_id, buyer_id, buyer_name, vendor_name, vendor_number, vendor_id, vendor_site_code, vendor_site_id, supplier_url, item_url, inventory_organization_id, org_name, organization_code, vendor_item, consigned_from_supplier_flag, enable_vmi_flag FROM apps.pos_po_supplier_items_v;

Report authors commonly filter on VENDOR_ITEM to locate the internal item corresponding to a vendor's part number, or on ENABLE_VMI_FLAG and CONSIGNED_FROM_SUPPLIER_FLAG to identify VMI- or consignment-enabled sourcing relationships. Because the view joins HR and FND_GLOBAL context, results may be sensitive to the session's organization and security setup, so filtering by INVENTORY_ORGANIZATION_ID or ORGANIZATION_CODE is recommended in custom reports.