Search Results mtl_attr_appl_dependencies




Overview
Explore in AI Chat

Overview

The MTL_ATTR_APPL_DEPENDENCIES table is a core data dictionary object within the Oracle E-Business Suite Inventory (INV) module. Its primary function is to define and enforce dependencies between specific item attributes and the Oracle applications that utilize them. This table acts as a control mechanism, ensuring that item attribute definitions are only available and applicable within the context of the licensed or implemented products where they have functional relevance. In EBS 12.1.1 and 12.2.2, this object is fundamental for maintaining the integrity and modularity of the item master data model across a complex, integrated suite of applications.

Key Information Stored

The table stores a straightforward mapping between an application and an item attribute. The primary key is a composite of the APPLICATION_ID and ATTRIBUTE_NAME columns. The APPLICATION_ID column stores a foreign key reference to FND_APPLICATION, identifying a specific Oracle EBS product or module. The ATTRIBUTE_NAME column stores a foreign key reference to MTL_ITEM_ATTRIBUTES, identifying a specific item attribute defined within the system. Each record signifies that the specified attribute is meaningful and can be used when the specified application is active. This structure prevents the display or validation of irrelevant attributes for a given product setup.

Common Use Cases and Queries

A primary use case is determining the list of item attributes that are enabled for a specific module, such as Oracle Purchasing or Oracle Engineering, to configure user interfaces or validate data entry. Conversely, it is used to identify which applications are dependent on a particular item attribute, which is critical for impact analysis before modifying or disabling an attribute. Common queries include listing all applications tied to a specific attribute or finding all attributes enabled for a given application ID.

  • Sample Query: To find all item attributes applicable to Oracle Purchasing (APPLICATION_ID = 201):
    SELECT maad.attribute_name, mia.description FROM mtl_attr_appl_dependencies maad JOIN mtl_item_attributes mia ON maad.attribute_name = mia.attribute_name WHERE maad.application_id = 201;
  • Reporting Use Case: Generating a cross-reference report for functional consultants showing the relationship matrix between all implemented modules and the item attributes they control.

Related Objects

The table maintains documented foreign key relationships with two key data dictionary tables, as per the provided metadata.

  • MTL_ITEM_ATTRIBUTES: The ATTRIBUTE_NAME column in MTL_ATTR_APPL_DEPENDENCIES references MTL_ITEM_ATTRIBUTES.ATTRIBUTE_NAME. This ensures that any attribute registered in the dependencies table is a valid, predefined item attribute.
  • FND_APPLICATION: The APPLICATION_ID column in MTL_ATTR_APPL_DEPENDENCIES references FND_APPLICATION.APPLICATION_ID. This ensures that the dependency is linked to a registered Oracle EBS application.

These relationships are essential for maintaining referential integrity. The table is primarily referenced by the Oracle Applications core code that renders item definition forms and validates attribute usage, rather than by other user-facing tables.