Search Results mtl_item_catalog_groups_b

Overview

The MTL_ITEM_CATALOG_GROUPS_B table is a core Inventory (INV) foundation table within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master repository for defining Item Catalog Groups, which are logical collections of descriptive elements used to classify and describe items in a standardized manner. These groups are fundamental to the Item Catalog functionality, enabling structured and searchable item definitions beyond basic categories. The table stores the base, non-translatable attributes of each catalog group, with its corresponding _TL (translation) table handling language-specific names. Its primary role is to provide a centralized reference key (ITEM_CATALOG_GROUP_ID) that links to descriptive elements, categories, aliases, and ultimately, to items themselves in MTL_SYSTEM_ITEMS_B.

Key Information Stored

The table's structure is centered on its primary key, ITEM_CATALOG_GROUP_ID, which uniquely identifies each catalog group. While the provided ETRM metadata does not list all columns, the table's purpose and foreign key relationships imply it contains essential control columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN for auditing. It also likely includes columns for the group's internal NAME, a DESCRIPTION, and flags to control its status and usage (e.g., ENABLED_FLAG). The key data point is the immutable numeric identifier (ITEM_CATALOG_GROUP_ID) that is referenced across the system to associate items with a specific descriptive framework.

Common Use Cases and Queries

This table is primarily accessed for setup, maintenance, and reporting on the item catalog structure. Common scenarios include identifying all defined catalog groups, finding items associated with a specific catalog group, or troubleshooting integration points. A typical query retrieves catalog group details for reporting or validation.

• Listing All Active Item Catalog Groups:
  SELECT ITEM_CATALOG_GROUP_ID, NAME, DESCRIPTION
  FROM MTL_ITEM_CATALOG_GROUPS_B
  WHERE ENABLED_FLAG = 'Y'
  ORDER BY NAME;
• Finding Items for a Specific Catalog Group:
  SELECT MSIB.SEGMENT1 ITEM_CODE, MSIB.DESCRIPTION
  FROM MTL_SYSTEM_ITEMS_B MSIB
  WHERE MSIB.ITEM_CATALOG_GROUP_ID = <GROUP_ID>;
• Resolving Integration References: The foreign key from OKL_DF_CTGY_RMK_TMS_ALL.ICO_ID indicates this table is referenced by the Oracle Lease and Finance Management (OKL) module, linking financial category remarks to an Inventory catalog group.

Related Objects

As evidenced by the foreign keys, MTL_ITEM_CATALOG_GROUPS_B is a central hub in the Item Catalog data model. Key related objects include:

• MTL_ITEM_CATALOG_GROUPS_TL: The translation table holding the user-facing name and description in multiple languages.
• MTL_DESCRIPTIVE_ELEMENTS: Stores the individual attributes (e.g., Color, Wattage) that belong to a catalog group.
• MTL_SYSTEM_ITEMS_B: Items are assigned to a catalog group via this column, enabling descriptive element validation.
• MTL_ICG_CATEGORIES & MTL_ICG_ALIASES: Link catalog groups to inventory categories and alternate names, respectively.
• BOM_STRUCTURE_TYPES_B: Associates a catalog group with a Bill of Material structure type.
• OKL_DF_CTGY_RMK_TMS_ALL: A key cross-module dependency, where the Oracle Financials (OKL) module references the Inventory catalog group (via ICO_ID) for category remark tracking.