Search Results invbv_item_catalog_groups

Overview

INVBV_ITEM_CATALOG_GROUPS is a read-only Oracle EBS view owned by the APPS schema within the Inventory (INV) product. It presents item catalog group definitions used by the Inventory module to organize items into hierarchical catalog structures. The view is designated as "Retrofitted," indicating it was re-engineered to support a later framework — in this case, Oracle's Key Flexfield (KFF) descriptive flexfield infrastructure, as evidenced by the embedded token '_KF:INV:MICG:IT' in the first selected column. In Oracle EBS 12.1.1 and 12.2.2, this view serves as a reporting and integration layer over the base catalog group table, allowing concurrent programs, discoverer reports, and custom interfaces to retrieve catalog group attributes without directly accessing the underlying transactional table. Because it is defined WITH READ ONLY, it is intended strictly for query and extraction purposes and cannot be used for DML operations. The view plays a supporting role in item cataloging, assisting organizations that categorize stock items for picking, browsing, or web storefront display through Oracle iStore or similar catalog-driven modules.

Underlying Base Objects

The view is defined over a single documented base object: MTL_ITEM_CATALOG_GROUPS, which is referenced through a SYNONYM in the APPS schema. MTL_ITEM_CATALOG_GROUPS is the master table that stores the definition of each item catalog group, including the group identifier, name, description, and audit columns. INVBV_ITEM_CATALOG_GROUPS projects a controlled subset of those columns, providing a stable, read-only interface that shields consumers from direct table access and from any structural changes to the base object. The view text aliases the base table as IT and applies no filtering or joins, meaning every row in MTL_ITEM_CATALOG_GROUPS is exposed one-to-one. The absence of joins keeps the view lightweight and predictable, making it suitable for high-volume reporting. The documented referenced base object confirms a direct, unmodified relationship between the view and the catalog group table.

Key Columns

• "_KF:CATALOG_GROUP_NAME" — The catalog group name exposed as a key flexfield segment, driven by the INV:MICG:IT flexfield definition. This column carries the user-facing name of the catalog group.
• ITEM_CATALOG_GROUP_ID — The unique surrogate identifier for the catalog group; the primary key of the underlying table and the join key for related item-catalog assignment tables.
• DESCRIPTION — Free-text description of the catalog group.
• END_EFFECTIVE_DATE (INACTIVE_DATE) — The date on which the catalog group becomes inactive; supports date-effective querying.
• LAST_UPDATE_DATE and LAST_UPDATED_BY — Standard EBS audit columns recording the most recent modification timestamp and the user who performed it.
• CREATION_DATE and CREATED_BY — Audit columns recording when and by whom the catalog group record was originally created.

Common Use Cases and Queries

Typical scenarios include listing all active catalog groups, joining catalog groups to cataloged items, and validating flexfield-based group names. The following query retrieves active catalog groups ordered by name:

SELECT ITEM_CATALOG_GROUP_ID, "_KF:CATALOG_GROUP_NAME" AS GROUP_NAME, DESCRIPTION
FROM APPS.INVBV_ITEM_CATALOG_GROUPS
WHERE (END_EFFECTIVE_DATE IS NULL OR END_EFFECTIVE_DATE > SYSDATE)
ORDER BY "_KF:CATALOG_GROUP_NAME";

A second common pattern joins the view to item-catalog assignment data to report which items belong to each group:

SELECT g."_KF:CATALOG_GROUP_NAME" AS GROUP_NAME, ic.INVENTORY_ITEM_ID
FROM APPS.INVBV_ITEM_CATALOG_GROUPS g,
    APPS.MTL_ITEM_CATEGORIES ic
WHERE g.ITEM_CATALOG_GROUP_ID = ic.CATEGORY_SET_ID;

Because the view is read-only, all usage is confined to querying and extraction. Auditors frequently invoke it to confirm catalog group creation and update history via the CREATED_BY and LAST_UPDATED_BY columns.