Search Results okx_system_items_v




Overview
Explore in AI Chat

Overview

OKX_SYSTEM_ITEMS_V is an APPS-owned database view that exposes inventory item definitions to the Oracle E-Business Suite contracts integration layer (OKX). It provides a denormalized, reporting-friendly projection of item master attributes that Oracle Order Management, Oracle Service Contracts, and related OKX processes require when validating, pricing, and processing contract lines that reference inventory items. Because the view returns a single row per organization/item combination and carries flattened key flexfield segments alongside operational flags, it serves as a stable integration surface that shields downstream logic from the underlying multi-table structure of the item master. The view is documented as VALID and is intended primarily for read access — typically through custom reports, extracts, and contract integration lookups.

Underlying Base Objects

Per the ETRM 12.2.2 metadata, OKX_SYSTEM_ITEMS_V is defined over two referenced base objects:

The view joins these objects on inventory item and organization, producing the aliased ID1 and ID2 columns used for internal joins. No DML is expected through this view; it is read-only.

Key Columns

The view exposes identifiers, descriptions, key flexfield segments, and a broad set of item control flags. Notable columns include:

Common Use Cases and Queries

Typical scenarios include validating shippable items for a contract, extracting serviceable products, and reporting item attributes by organization. A representative query filtered on the searched column follows:

  • Shippable item lookup: SELECT inventory_item_id, organization_id, name, shippable_item_flag FROM okx_system_items_v WHERE shippable_item_flag = 'Y';
  • Serviceable products: filter on serviceable_product_flag = 'Y' for contract entitlement configuration.
  • Billing extract: select invoiceable_item_flag, list_price_per_unit, and segment columns for pricing reports.
  • Status reconciliation: compare STATUS with INVENTORY_ITEM_STATUS_CODE to detect disabled items.

Because the view is owned by APPS, all statements should be qualified with the APPS schema or executed under an EBS application responsibility with appropriate read privileges.