Search Results invoiceable_item_flag




Overview
Explore in AI Chat

Overview

APPS.OKE_SYSTEM_ITEMS_V is a supplementary database view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its FND Design Data reference is OKE.OKE_SYSTEM_ITEMS_V, and its status is VALID. As documented in the ETRM metadata, the view is classified as a "supplementary view used to simplify forms coding," with the explicit Oracle warning that it is not recommended for direct querying or data alteration because its definition may change dramatically in subsequent minor or major releases. Despite this caveat, the view is widely encountered in Oracle Projects and Oracle Order Management contexts because it exposes a consolidated, denormalized projection of item master attributes, including the INVOICEABLE_ITEM_FLAG column that many reporting and integration scenarios depend upon.

Underlying Base Objects

According to the dependency documentation, OKE_SYSTEM_ITEMS_V is defined over two referenced objects in the APPS schema:

  • MTL_SYSTEM_ITEMS_B_KFV — a key flexfield view over the MTL_SYSTEM_ITEMS_B item master base table, which concatenates the item key flexfield segments into a single displayed item identifier.
  • MTL_SYSTEM_ITEMS_TL — a synonym exposing the translated (multi-language) descriptions of items, supporting the DESCRIPTION column returned by the view.

The view therefore blends core item master attributes (organization-level flags, UOM, status, dates, identifiers) with descriptive and flexfield-derived columns. Because it references a KFV view and a TL synonym rather than the physical base tables, the exact column derivations are subject to the underlying object definitions and can change across releases.

Key Columns

The view exposes the following documented columns, each carrying specific business meaning:

  • ID1, ID2 (NUMBER): Inventory item unique identifier and inventory organization unique identifier. These duplicate INVENTORY_ITEM_ID and ORGANIZATION_ID.
  • NAME (VARCHAR2 40): Item number.
  • DESCRIPTION (VARCHAR2 240): Description of the item, sourced via the translated table.
  • CUSTOMER_ORDER_ENABLED_FLAG, PURCHASING_ENABLED_FLAG: Flags indicating whether the item is enabled for customer orders or purchasing respectively.
  • SHIPPABLE_ITEM_FLAG: Shippable item indicator.
  • INVOICEABLE_ITEM_FLAG: Invoiceable item indicator — the column most commonly targeted by users searching for this view, controlling whether an item may be invoiced.
  • EFFECTIVITY_CONTROL (NUMBER): Effective control of the item, either date-based or model/unit-based.
  • ITEM_TYPE (VARCHAR2 30), B_STATUS, STATUS: Item type and item status values.
  • START_DATE_ACTIVE, END_DATE_ACTIVE (DATE): Activation and inactivation dates for the item.
  • PRIMARY_UOM_CODE: Primary unit of measure.
  • INVENTORY_ITEM_ID, ORGANIZATION_ID (NUMBER): Inventory item and organization unique identifiers.
  • INVENTORY_ITEM_FLAG: Flag indicating whether the record represents an inventory item.

Common Use Cases and Queries

Because the view carries the INVOICEABLE_ITEM_FLAG, it is frequently queried in Oracle Projects billing setups, invoice generation validations, and Order Management integration extracts. A typical reporting query follows the documented query text:

  • SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, NAME, DESCRIPTION, INVOICEABLE_ITEM_FLAG, SHIPPABLE_ITEM_FLAG, STATUS FROM APPS.OKE_SYSTEM_ITEMS_V WHERE INVOICEABLE_ITEM_FLAG = 'Y' AND ORGANIZATION_ID = :org_id;
  • Join the view to project or order tables on INVENTORY_ITEM_ID and ORGANIZATION_ID to validate that transacted items are billable before invoicing.

Practitioners should note the documented warning: Oracle advises against querying this view directly, since it exists to simplify forms coding and may be redefined without notice. For persistent reporting or integration, querying the underlying MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_TL objects directly, or using the supported public APIs, is the recommended approach.