Search Results oke_system_items_v




Overview
Explore in AI Chat

Overview

OKE_SYSTEM_ITEMS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is shipped as part of the OKE – Project Contracts product family and is documented as a "View of Inventory Items." The view presents a curated, language-aware projection of Oracle Inventory master item data, exposing item identifiers, descriptive text, transactional enablement flags, and effectivity attributes in a single denormalized structure. Its principal purpose is to give Project Contracts and related OKE functionality — and any custom reporting or integration layer built alongside it — a stable, restricted interface to inventory item definitions without requiring direct joins against the base Inventory tables.

Because the view selects only a defined subset of columns and applies an internal filter, it behaves as a purpose-built access path rather than a general-purpose item query facility. This design shields downstream consumers from schema changes in the underlying Inventory objects and centralizes the join between the base item table and its translation table.

Underlying Base Objects

The view is defined over two documented base objects: MTL_SYSTEM_ITEMS_B_KFV (a key flexfield view over MTL_SYSTEM_ITEMS_B) and MTL_SYSTEM_ITEMS_TL (referenced through a synonym). MTL_SYSTEM_ITEMS_B_KFV supplies the key-flexfield-concatenated item identifier, organization context, and the majority of flag and effectivity columns. MTL_SYSTEM_ITEMS_TL supplies the language-specific item DESCRIPTION.

The two sources are joined on INVENTORY_ITEM_ID and ORGANIZATION_ID. A language predicate restricts the translation row returned to the session language via USERENV('LANG'), ensuring each item appears once with the appropriate localized description. A BOM_ITEM_TYPE = 4 filter restricts the result set to a specific item type classification, so the view does not expose the entire item master — only the subset relevant to the OKE contract context. The definition also repeats INVENTORY_ITEM_ID and ORGANIZATION_ID in the select list.

Key Columns

Common Use Cases and Queries

The most common use case is retrieving shippable, invoiceable item attributes for project contract lines and related reporting, particularly filtering on SHIPPABLE_ITEM_FLAG during fulfillment or billing analysis.

SELECT inventory_item_id,
       organization_id,
       concatenated_segments,
       description,
       primary_uom_code
FROM   apps.oke_system_items_v
WHERE  shippable_item_flag = 'Y'
AND    enabled_flag = 'Y';

Additional scenarios include validating whether items are customer-order enabled, determining effectivity windows for a given organization, and joining the view to contract or order tables on INVENTORY_ITEM_ID and ORGANIZATION_ID. Because the view is already language-filtered, no additional translation join is required by callers.