Results for “mtl_item_catalog_groups_b_kfv”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The MTL_ITEM_CATALOG_GROUPS_B_KFV view is an Oracle EBS Inventory (INV) key flexfield view owned by the APPS schema. It is classified as a "dummy" Key Flexfield (KFV) view, meaning it does not expose an actual concatenated flexfield segment string in the manner of a conventional KFV view. Instead, it presents the columns of the Item Catalog Groups base entity, together with a set of generic SEGMENT1 through SEGMENT20 columns and two derived trailing columns populated with RTRIM(RPAD(' ', 4000)). This view exposes the descriptive and attribute-flexfield columns for item catalog groups, which in Oracle EBS are treated as a key flexfield structure for item categorization purposes.

Item Catalog Groups classify inventory items into named categories (for example, hardware, raw materials, or finished goods). Each catalog group carries configuration for automatic item number and description generation, governance fields, DFF attributes, and audit metadata. The _KFV view surfaces these fields for reporting and integration consumers without requiring direct access to the base table. The ETRM record confirms owner APPS, status VALID, and lists the referenced base object as the synonym MTL_ITEM_CATALOG_GROUPS_B. The presence of the INCREMENT_BY column reflects the view's role in exposing automatic item-number generation settings.

Underlying Base Objects

The only documented referenced object is the synonym MTL_ITEM_CATALOG_GROUPS_B, which resolves to the underlying base table of the same name in the APPLSYS/INV schema. The view is defined with a direct SELECT against MTL_ITEM_CATALOG_GROUPS_B and includes an explicit ROWID alias (ROW_ID), giving consumers a means to identify individual rows. All business columns are passed through from the base table without transformation, with the exception of the trailing columns whose expressions render as blank padded values.

Because the base object is a synonym, downstream queries resolve to the same data regardless of schema qualification, provided the synonym is valid in the consuming session's schema. No joins, aggregations, or DISTINCT clauses appear in the documented view text, so the view is a straightforward projection of the base table.

Key Columns

• ROW_ID — the base table ROWID, exposed as an aliased column for row identification.
• ITEM_CATALOG_GROUP_ID — primary identifier of the catalog group.
• INACTIVE_DATE — date on which the catalog group becomes inactive.
• PARENT_CATALOG_GROUP_ID — reference to a parent catalog group, supporting hierarchical categorization.
• ITEM_NUM_GEN_METHOD, PREFIX, STARTING_NUMBER, INCREMENT_BY, SUFFIX, CURRENT_NUMBER — parameters governing automatic item-number generation, including the increment applied between successive numbers.
• ITEM_DESC_GEN_METHOD, DESCRIPTION — description-generation method and the group description.
• NEW_ITEM_REQUEST_REQD, NEW_ITEM_REQ_CHANGE_TYPE_ID — controls whether a new-item request is required.
• ITEM_NUM_ACTION_ID, ITEM_DESC_ACTION_ID, ITEM_NUM_SEQ_NAME — workflow/sequence references for numbering and description actions.
• SEGMENT1–SEGMENT20 — generic segment columns exposed for the key flexfield structure.
• SUMMARY_FLAG, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE — status and effective-dating controls.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield context and attribute values.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — standard audit and concurrent program bookkeeping columns.

Common Use Cases and Queries

The view is typically queried to report catalog group configuration, to integrate item setup data with external systems, and to inspect numbering rules where INCREMENT_BY governs the sequence step. Typical access is read-only.

Retrieve active catalog groups with their numbering configuration:

• SELECT ITEM_CATALOG_GROUP_ID, DESCRIPTION, ITEM_NUM_GEN_METHOD, PREFIX, STARTING_NUMBER, INCREMENT_BY, SUFFIX FROM APPS.MTL_ITEM_CATALOG_GROUPS_B_KFV WHERE ENABLED_FLAG = 'Y';

Identify groups applying a non-default increment:

• SELECT ITEM_CATALOG_GROUP_ID, DESCRIPTION, INCREMENT_BY FROM APPS.MTL_ITEM_CATALOG_GROUPS_B_KFV WHERE INCREMENT_BY > 1;

Inspect flexfield and DFF attributes for a specific group:

• SELECT ITEM_CATALOG_GROUP_ID, SEGMENT1, SEGMENT2, ATTRIBUTE_CATEGORY, ATTRIBUTE1 FROM APPS.MTL_ITEM_CATALOG_GROUPS_B_KFV WHERE ITEM_CATALOG_GROUP_ID = :group_id;

Because the view is a thin projection of MTL_ITEM_CATALOG_GROUPS_B, no performance penalty relative to the base table is expected beyond normal view resolution.