Search Results mtl_icg_aliases_pk

Overview

The MTL_ICG_ALIASES table is a core data object within the Oracle E-Business Suite Inventory (INV) module, specifically for versions 12.1.1 and 12.2.2. It serves as a repository for recommended item aliases associated with items that belong to an Item Catalog Group. An Item Catalog Group is a classification mechanism used to categorize items for reporting, searching, and grouping purposes. This table's primary role is to store standardized, alternative names or codes (aliases) for items within a specific catalog group, facilitating consistent item identification and lookup across different business units or legacy systems that may use varying nomenclature for the same item.

Key Information Stored

The table's structure is defined by its primary key, which uniquely identifies each alias record. The most critical columns are:

• ITEM_CATALOG_GROUP_ID: A foreign key column linking the alias to its parent Item Catalog Group, defined in the MTL_ITEM_CATALOG_GROUPS_B table. This establishes the group context for the alias.
• ALIAS_NAME: Stores the actual recommended alias text or code for an item within the specified catalog group. This, combined with ITEM_CATALOG_GROUP_ID, forms the table's primary key (MTL_ICG_ALIASES_PK).

While the provided metadata does not list all columns, typical implementations would also include standard Oracle EBS audit columns (e.g., CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) and potentially a column to link the alias to a specific inventory item, though the description emphasizes its role for "items in an item catalog group" generically.

Common Use Cases and Queries

This table is central to processes requiring item identification via alternative names within a controlled group context. A common use case is generating reports or building interfaces that must translate legacy item codes from an acquired company into the standard item identifiers used in Oracle EBS. For example, a query to find all recommended aliases for items within a specific catalog group would join to the catalog group table:

• SELECT ica.ALIAS_NAME, mig.NAME CATALOG_GROUP_NAME FROM INV.MTL_ICG_ALIASES ica, INV.MTL_ITEM_CATALOG_GROUPS_B mig WHERE ica.ITEM_CATALOG_GROUP_ID = mig.ITEM_CATALOG_GROUP_ID AND mig.NAME = '&CATALOG_GROUP';

Another key use is data validation during item import or creation, where the system can check if a provided item code matches a predefined alias within its assigned catalog group to ensure consistency.

Related Objects

The MTL_ICG_ALIASES table has a direct and essential relationship with the MTL_ITEM_CATALOG_GROUPS_B table, as enforced by its foreign key constraint. This links each alias record to a master catalog group definition. While not listed in the provided metadata, this table is also conceptually related to the core item master table (MTL_SYSTEM_ITEMS_B), as the aliases ultimately reference items categorized within these groups. The table may be referenced by various Inventory and potentially Order Management APIs or views that handle item catalog group and alias functionality for data loading or validation purposes.