Search Results ship_model_complete_flag




Overview
Explore in AI Chat

Overview

OE_AK_INVENTORY_ITEMS_V is a read-only view owned by the APPS schema and classified under the ONT (Order Management) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It is an Oracle ETRM (E-Business Suite Technical Reference Manual) documented object with status VALID. The view presents a denormalized, reporting-oriented projection of inventory item attributes that are relevant to order capture, order fulfillment, and order management processing. Because the view resolves the master organization context internally, it allows downstream reports, concurrent programs, and integrations to retrieve order-management-relevant item attributes without manually joining item master tables or resolving the master organization identifier.

Underlying Base Objects

The view is defined over two referenced base objects as documented in the 12.2.2 ETRM metadata: MTL_SYSTEM_ITEMS (exposed through a synonym) and the OE_SYS_PARAMETERS package. In the view text, MTL_SYSTEM_ITEMS is aliased twice — once as A and once as B — and the two aliases are joined on INVENTORY_ITEM_ID. Alias A supplies the master-level (organization-independent) item attributes, while alias B supplies organization-level attributes such as DEFAULT_SO_SOURCE_TYPE and CHARGE_PERIODICITY_CODE. The join is constrained so that A.ORGANIZATION_ID equals the master organization identifier returned by OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'). Consequently, the view returns one row per inventory item, fixed to the master organization, with the second alias providing organization-specific defaults for the same item.

Key Columns

The view exposes twenty columns. The most significant include:

Common Use Cases and Queries

OE_AK_INVENTORY_ITEMS_V is typically used in reports and integrations that require item-level order management defaults without repeating the master organization lookup. Common scenarios include extracting default shipping organization assignments, auditing shipment and return tolerances, and validating invoicing or accounting rule defaults.

A representative query retrieving the default shipping organization for an item is:

  • SELECT inventory_item_id, organization_id, default_shipping_org FROM apps.oe_ak_inventory_items_v WHERE inventory_item_id = :p_item_id;

To review tolerance settings for order management validation:

  • SELECT inventory_item_id, over_shipment_tolerance, under_shipment_tolerance, over_return_tolerance, under_return_tolerance FROM apps.oe_ak_inventory_items_v;

Because the underlying filter hard-codes the master organization through OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'), the view cannot be used to retrieve attributes for arbitrary organizations; it is intended specifically for master-level item lookups used by Order Management functionality. Note that the ETRM column listing shows PAYMENT_TERM_ID and SOURCE_TYPE_CODE, while the view text uses PAYMENT_TERMS_ID and DEFAULT_SO_SOURCE_TYPE respectively; consumers should reference the view definition or ALL_TAB_COLUMNS to confirm exact column names for their patch level.