Search Results mtl_eam_asset_activities




Overview
Explore in AI Chat

Overview

MTL_EAM_ASSET_ACTIVITIES is an Inventory (INV) module table within Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the association between maintenance activities and the assets, rebuildable items, or other maintenance objects they belong to. It is a core EAM (Enterprise Asset Management) object, recording which preventive maintenance or activity definitions apply to a specific item, serial number, and maintenance object type within an organization. Each row represents one activity association, carrying scheduling, service-history, priority, and classification data that drives EAM work order generation and PM scheduling.

From a Data Vault modeling perspective, the mined foreign-key structure suggests this table behaves as a hub, since the primary key ACTIVITY_ASSOCIATION_ID is referenced as a foreign key by several downstream EAM tables (forecasted work orders, PM activities, PM schedulings, and suppression relations). This classification is a heuristic and should be treated as a modeling suggestion rather than an authoritative designation.

Key Information Stored

The table contains 58 documented columns. The most significant are summarized below, distinguishing the surrogate primary key from business-key candidates.

Common Use Cases and Queries

Typical scenarios include listing all PM activities associated with a given asset, reporting service schedules per organization, and tracing which items are covered by a specific activity definition. A common query joins the association to the item master:

  • Asset activity listing: SELECT a.ACTIVITY_ASSOCIATION_ID, a.INVENTORY_ITEM_ID, a.SERIAL_NUMBER, a.PRIORITY_CODE FROM MTL_EAM_ASSET_ACTIVITIES a WHERE a.ORGANIZATION_ID = :org_id AND a.END_DATE_ACTIVE IS NULL.
  • Join to item master: join MTL_SYSTEM_ITEMS_B b ON a.INVENTORY_ITEM_ID = b.INVENTORY_ITEM_ID AND a.ORGANIZATION_ID = b.ORGANIZATION_ID to resolve item descriptions.
  • PM scheduling report: filter on LAST_PM_SUGGESTED_START_DATE and LAST_SCHEDULED_START_DATE to surface upcoming or overdue maintenance.
  • Serialized asset history: join to MTL_SERIAL_NUMBERS on SERIAL_NUMBER and INVENTORY_ITEM_ID to report service history for a specific unit.
  • Template identification: filter TMPL_FLAG and SOURCE_TMPL_ID to distinguish template-driven associations from directly created ones.

Related Objects

The following objects depend on or reference MTL_EAM_ASSET_ACTIVITIES through documented foreign keys: