Search Results mtl_eam_asset_attr_groups




Overview
Explore in AI Chat

Overview

The MTL_EAM_ASSET_ATTR_GROUPS table is a core data structure within the Oracle E-Business Suite (EBS) Inventory (INV) module, specifically supporting Enterprise Asset Management (EAM) functionality. Its primary role is to manage the association between inventory assets and descriptive flexfield (DFF) attribute groups. This table acts as a junction, defining which context-sensitive sets of user-defined attributes are applicable to specific asset items within a given organization. By storing these associations, it enables the dynamic configuration and capture of detailed, asset-specific information beyond standard item master fields, which is essential for comprehensive asset tracking and maintenance within EAM operations.

Key Information Stored

The table's structure is designed to establish and enforce these critical associations. While the full column list is not detailed in the provided metadata, the foreign key relationships and primary key reveal its core components. The primary key is the ASSOCIATION_ID, a unique identifier for each asset-to-attribute-group link. The ORGANIZATION_ID and INVENTORY_ITEM_ID columns together identify the specific asset (item) within an inventory organization, linking to MTL_SYSTEM_ITEMS_B. The columns APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME, and DESCRIPTIVE_FLEX_CONTEXT_CODE identify the exact descriptive flexfield context (attribute group) assigned to the asset, linking to FND_DESCR_FLEX_CONTEXTS. This structure ensures that an asset can be configured with multiple, context-specific sets of custom attributes.

Common Use Cases and Queries

This table is central to scenarios requiring reports or integrations based on asset-specific attributes. A common use case is generating a list of all assets configured with a particular attribute group for maintenance or audit purposes. Another is validating asset configuration during data migration or interface development. A typical query would join this table to the item master and descriptive flexfield contexts to retrieve a comprehensible dataset.

  • Sample Query: Retrieving assets with their assigned attribute groups for a specific organization.
    SELECT msib.segment1 item_code,
          msib.description,
          meaag.descriptive_flex_context_code attr_group_code
    FROM mtl_eam_asset_attr_groups meaag,
         mtl_system_items_b msib
    WHERE meaag.inventory_item_id = msib.inventory_item_id
      AND meaag.organization_id = msib.organization_id
      AND meaag.organization_id = :p_org_id
    ORDER BY msib.segment1;

Related Objects

The table maintains strict referential integrity through its foreign key relationships, as documented in the ETRM metadata. It is a child table to several fundamental EBS entities.

  • MTL_PARAMETERS: Via ORGANIZATION_ID. Validates that the organization in the association is a defined inventory organization.
  • MTL_SYSTEM_ITEMS_B: Via INVENTORY_ITEM_ID and ORGANIZATION_ID. This is the critical link to the asset item master record, ensuring the association is for a valid item-organization combination.
  • FND_DESCR_FLEX_CONTEXTS: Via APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME, and DESCRIPTIVE_FLEX_CONTEXT_CODE. This link ensures the assigned attribute group is a valid, registered descriptive flexfield context within the application.

Objects that likely reference MTL_EAM_ASSET_ATTR_GROUPS would include forms and APIs for managing asset attributes, such as the Asset Attribute Groups form, and any views that present asset information alongside their configurable attributes.