Search Results enable_authorizations_flag




Overview
Explore in AI Chat

Overview

POS_ORD_MODIFIERS_V is an APPS-owned database view within the Oracle E-Business Suite Purchasing (PO) module. Its name reflects its purpose: it consolidates ordering modifiers — the buyer-defined controls that govern how purchase orders and releases are generated against an approved supplier list (ASL) entry. Rather than presenting the raw ASL attribute rows, the view projects a curated, denormalized set of sourcing, scheduling, and quantity-modifier attributes joined to item and supplier context, which makes it convenient for reporting, integration, and validation logic.

The view is defined to return only global-level ASL attributes, since its definition restricts results with PAA.USING_ORGANIZATION_ID = -1. This constant denotes the master (global) organization in the multi-org model. As a result, POS_ORD_MODIFIERS_V exposes the enterprise-wide ordering modifiers rather than organization-specific overrides. Status is VALID, and the object is referenced in ETRM metadata for both 12.1.1 and 12.2.2. The term the user searched, fixed_lot_multiple, corresponds to the FIXED_LOT_MULTIPLE column, which is one of the key ordering modifiers surfaced by this view.

Underlying Base Objects

The documented view text joins three primary sources and their synonyms:

The ETRM metadata additionally lists referenced objects including PO_VENDORS (VIEW), MTL_PLANNERS (SYNONYM), MTL_SYSTEM_ITEMS_KFV (SYNONYM), and HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM), reflecting the broader join context used by the reporting layer. Because the view joins ASL attributes to items and suppliers, it effectively answers the question: "For this global ASL entry, what ordering modifiers apply, and to which item and supplier?"

Key Columns

Common Use Cases and Queries

Typical uses include auditing ordering modifiers across suppliers, validating fixed lot multiples before release generation, and feeding external planning or sourcing systems. A representative query listing items with a non-null fixed lot multiple:

  • SELECT ASL_ID, ITEM_ID, SEGMENT1, DESCRIPTION, VENDOR_ID, FIXED_LOT_MULTIPLE, MIN_ORDER_QTY
  • FROM APPS.POS_ORD_MODIFIERS_V
  • WHERE FIXED_LOT_MULTIPLE IS NOT NULL
  • ORDER BY SEGMENT1;

Another common pattern filters by supplier to review all sourcing and scheduling modifiers for a vendor's approved items. Because the view returns global (USING_ORGANIZATION_ID = -1) attributes, queries should account for organization-specific overrides being outside its scope.