Search Results default_shipping_org




Overview
Explore in AI Chat

Overview

APPS.OE_AK_INVENTORY_ITEMS_V is an Oracle E-Business Suite (EBS) dictionary view that exposes inventory item attributes drawn from the MTL_SYSTEM_ITEMS table. Its name reflects an Oracle Order Management "AK" (Application Kit / extensibility) construct that supplies inventory item master data to Order Management forms, flexfields, and integrations. The view is owned by the APPS schema and is available in both 12.1.1 and 12.2.2. It is not a stored table; it is a query-based view and therefore returns no data of its own — it always reflects the current contents of MTL_SYSTEM_ITEMS.

The view is significant because it applies a filter that restricts rows to the item master organization. It joins the master-organization row of an item to every other organization that holds the same INVENTORY_ITEM_ID. This makes it a convenient source for cross-organization item attributes that are defined only once at the master level but need to be reported or validated at the organization level.

Underlying Base Objects

The documented base objects are MTL_SYSTEM_ITEMS (SYNONYM) and OE_SYS_PARAMETERS (PACKAGE). The view is defined over two aliases of MTL_SYSTEM_ITEMS — alias A and alias B. Alias A is filtered to the item master organization using OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'), while alias B represents organization-level item rows. The two aliases are joined on INVENTORY_ITEM_ID, so each output row links a master-level item definition to an organization-specific item record.

Because OE_SYS_PARAMETERS is a package-backed entity, the value returned by VALUE('MASTER_ORGANIZATION_ID') is resolved at runtime. This means the filter is dynamic with respect to profile and site configuration, and the view's result set depends on that parameter being correctly populated. MTL_SYSTEM_ITEMS is one of the largest transactional and master data tables in EBS, and this view selects a narrow column list from it.

Key Columns

Common Use Cases and Queries

The view is typically used to retrieve order-relevant item defaults across organizations without querying MTL_SYSTEM_ITEMS directly with the master-organization filter. Common scenarios include validating shipping organization defaults, checking shipment and return tolerances, and confirming service item setup.

To locate items by their default shipping organization:

  • SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, DEFAULT_SHIPPING_ORG FROM APPS.OE_AK_INVENTORY_ITEMS_V WHERE DEFAULT_SHIPPING_ORG IS NOT NULL;
  • SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, OVER_SHIPMENT_TOLERANCE, UNDER_SHIPMENT_TOLERANCE FROM APPS.OE_AK_INVENTORY_ITEMS_V WHERE INVENTORY_ITEM_ID = :item_id;
  • SELECT DISTINCT DEFAULT_SHIPPING_ORG FROM APPS.OE_AK_INVENTORY_ITEMS_V ORDER BY 1;

Because OE_SYS_PARAMETERS resolves the master organization at runtime, administrators should confirm the MASTER_ORGANIZATION_ID parameter is set before relying on the view for reporting. Performance is governed by the indexing on MTL_SYSTEM_ITEMS for INVENTORY_ITEM_ID and ORGANIZATION_ID.