Search Results invoiceable_item_flag




Overview
Explore in AI Chat

Overview

MTL_SYSTEM_ITEMS_B_KFV is a key flexfield (KFF) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the INV — Inventory product family and exposes the System Items key flexfield, the structure that uniquely identifies every inventory item within an organization. In Oracle EBS, key flexfield combinations are stored in normalized segment columns, but application forms, concurrent programs, and reports require a single concatenated, user-facing identifier. This view bridges that gap by presenting the item flexfield definition alongside its descriptive and control attributes.

The view is the standard access point for reporting and integrations that need to read or validate inventory item information by concatenated flexfield value rather than by raw segment columns. The user search term "default_grade" is not a native column of this view; it is typically a user-defined descriptive flexfield (DFF) attribute or a custom KFF segment mapped through the System Items flexfield, and it would be surfaced here as one of the SEGMENT1–SEGMENT20 columns (or via the related descriptive flexfield view) depending on how the flexfield was configured.

Underlying Base Objects

ETRM documents a single referenced base object: MTL_SYSTEM_ITEMS_B, resolved through a SYNONYM. MTL_SYSTEM_ITEMS_B is the base table that stores item master definitions at the organization level. The _KFV naming convention indicates the view projects the flexfield structure of that table. Because the view is defined over the physical table rather than a snapshot, it reflects current item data and is regenerated as the flexfield configuration is maintained. In 12.2.2, the same ownership (APPS) and base-object relationship applies, making the view portable across both releases for read-only purposes.

Key Columns

Common Use Cases and Queries

Typical uses include item master validation in interfaces, flexfield-based lookups in custom reports, and grade or classification reporting where the grade is mapped to a KFF segment. The following query returns enabled items and any grade-style segment value:

SELECT organization_id,
       inventory_item_id,
       segment1,
       segment2,
       segment3,
       description,
       enabled_flag
FROM   apps.mtl_system_items_b_kfv
WHERE  organization_id = :org_id
AND    enabled_flag = 'Y';

To resolve an item by concatenated flexfield value:

SELECT inventory_item_id,
       description,
       segment1
FROM   apps.mtl_system_items_b_kfv
WHERE  segment1 = :default_grade;

Because the view retains every base-table column, it is best used as a reporting and integration layer rather than an update target. Joins back to MTL_SYSTEM_ITEMS_B on INVENTORY_ITEM_ID and ORGANIZATION_ID remain essential when segment-level or DFF-level detail is required.