Search Results minimum_order_quantity




Overview
Explore in AI Chat

Overview

The MRP_AP_PO_SUPPLIERS_V view is a Master Scheduling/MRP (MRP) object that consolidates approved supplier list (ASL) sourcing attributes with item master context to expose the planning-relevant supply parameters Oracle MRP and Oracle Purchasing use when generating planned orders. Its name reflects the lineage embodied in its SQL: MRP_AP (the MRP planning engine's staging/preference tables), PO (Purchasing sourcing attributes), and SUPPLIERS (vendor and vendor-site references). Within Oracle EBS 12.1.1 and 12.2.2, the view serves as a reporting and interface surface over the MRP planning snapshot, allowing sourcing rules to be queried alongside the item, organization, vendor, and lead-time attributes that drive replenishment.

The view is not a persistent table; it is a join of MRP snapshot tables filtered through the Purchasing ASL validation routine. According to the ETRM metadata, the view "not implemented in this database" in the source environment, meaning the entry documents the SQL definition rather than a live instantiation. Its primary analytical value is the alias by which the underlying MIN_ORDER_QTY column is surfaced as MINIMUM_ORDER_QUANTITY — the exact term referenced in the user's search.

Underlying Base Objects

The view is defined over four MRP planning snapshot tables, all carrying the _SN suffix that denotes snapshot membership used by the MRP planning process:

  • MRP_AP_ASL_SN (alias PASLVV) — the approved supplier list snapshot; supplies ASL_ID, item, and using-organization context.
  • MRP_AP_ASL_ATTRS_SN (alias PAA) — ASL sourcing attributes; supplies processing lead time, minimum order quantity, fixed lot multiple, delivery calendar, and vendor identifiers.
  • MRP_AP_MRP_PARAS_SN (alias MP) — MRP plan parameters, joined on ORGANIZATION_ID.
  • MRP_AP_SYS_ITEMS_SN (alias MASIS) — system item snapshot keyed on inventory item and organization.

The join is constrained by PASLVV.USING_ORGANIZATION_ID = -1, restricting results to the global/planning-level ASL context, and by a call to PO_ASL_SV.CHECK_ASL_ACTION('2_SOURCING', ...), which validates that the vendor and vendor site are currently eligible for the sourcing action on the given item. Each source table exposes an RN pseudo-column retained in the view as RN1 through RN4, reflecting row-level identifiers used by the planning engine's delta processing.

Key Columns

  • INVENTORY_ITEM_ID — the planned item master identifier.
  • ORGANIZATION_ID — the planning organization.
  • USING_ORGANIZATION_ID — the ASL using organization; fixed to -1 in the join predicate.
  • ASL_ID — the approved supplier list entry linking item, vendor, and site.
  • PROCESSING_LEAD_TIME — supplier processing lead time in days, used in planned order date offsets.
  • MINIMUM_ORDER_QUANTITY — aliased from PAA.MIN_ORDER_QTY; the smallest quantity that may be ordered from the supplier.
  • FIXED_LOT_MULTIPLE — the order quantity increment applied to planned orders.
  • DELIVERY_CALENDAR_CODE — aliased from PAA.DELIVERY_CALENDAR; the receiving calendar governing delivery.
  • VENDOR_ID / VENDOR_SITE_ID — the supplier and supplier site qualified by the ASL check.
  • RN1–RN4 — retained snapshot row identifiers.

Common Use Cases and Queries

Typical uses include auditing sourcing parameters for planning, validating minimum order quantities feeding MRP planned orders, and reconciling ASL vendor assignments against item/organization combinations. A representative query returning supplier planning attributes for a given item is shown below.

  • SELECT organization_id, inventory_item_id, vendor_id, vendor_site_id, minimum_order_quantity, fixed_lot_multiple, processing_lead_time, delivery_calendar_code FROM MRP_AP_PO_SUPPLIERS_V WHERE inventory_item_id = :item_id AND organization_id = :org_id;
  • SELECT inventory_item_id, MIN(minimum_order_quantity) FROM MRP_AP_PO_SUPPLIERS_V GROUP BY inventory_item_id;

Because the view enforces the CHECK_ASL_ACTION filter, results reflect only currently valid sourcing records, making it suitable for exception reports on items lacking an eligible supplier for the sourcing action.