Results for “maintained_unit”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MTL_EAM_ASSET_NUMBERS_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Inventory (INV) product module with functional alignment to Oracle Enterprise Asset Management (EAM). The view presents asset-number records, which in EAM terminology represent maintainable units — serialized instances of an equipment item that can be tracked, maintained, and reported against. Its principal design role is to expose a normalized, join-ready projection of asset instance data so that EAM asset-number entry forms, asset number LOVs, and third-party or custom reporting integrations can query asset information without directly navigating the base CSI and MTL tables. The view is documented with STATUS VALID in both Oracle EBS 12.1.1 and 12.2.2 reference metadata.

Underlying Base Objects

The documented view definition draws from a set of base objects owned by or synonymous with the MTL, CSI, and EAM schemas. The core driver is CSI_ITEM_INSTANCES, aliased CII, which supplies the asset instance identity, serial number, instance number, instance description, subinventory, locator, category, criticality, and check-in status. MTL_SYSTEM_ITEMS (aliased MSI) and MTL_SYSTEM_ITEMS_B_KFV (aliased MSI_PROD) supply item segments, product description, EAM item type, and equipment item linkage. MTL_PARAMETERS (MP) provides the current maintenance organization identifier, while EAM_ORG_MAINT_DEFAULTS (EOMD) contributes accounting class code, area, and owning department. Supporting lookups and descriptive objects include MFG_LOOKUPS (criticality meaning), MTL_CATEGORIES_KFV, MTL_EAM_LOCATIONS, BOM_DEPARTMENTS, MTL_SERIAL_NUMBERS, and CSI_I_ASSETS. In ETRM metadata these are recorded as synonyms referenced by the view.

Key Columns

• INVENTORY_ITEM_ID — the equipment item identifier associated with the asset instance.
• SERIAL_NUMBER / INSTANCE_NUMBER / MAINTAINED_UNIT — the serialized asset identity.
• MAINTENANCE_OBJECT_TYPE — a literal value of 3, indicating that the record represents an EAM asset (maintainable unit), which is the discriminator used when asset numbers are unioned with other maintenance object types.
• MAINTENANCE_OBJECT_ID — derived from CII.INSTANCE_ID, uniquely identifying the maintenance object.
• CURRENT_ORGANIZATION_ID / CURRENT_SUBINVENTORY_CODE / CURRENT_LOCATOR_ID — the asset's current physical and organizational position.
• ASSET_CRITICALITY_CODE and ASSET_CRITICALITY — the coded value and its decoded meaning from MFG_LOOKUPS.
• MAINTAINABLE_FLAG — NVL of the underlying flag to 'Y', indicating whether the unit is maintainable.
• CONCATENATED_SEGMENTS / ASSET_GROUP_DESCRIPTION / CATEGORY_NAME — descriptive item and category information.
• EQP_SERIAL_NUMBER and EQUIPMENT_ITEM_ID — linkage to the associated production equipment item.
• FA_ASSET_ID — reference to the corresponding Oracle Assets fixed asset.
• CONTEXT and ATTRIBUTE1–30 — the EAM descriptive flexfield columns.
• CHECKIN_STATUS and audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

The view is typically used to populate asset number LOVs, to drive asset number inquiry and maintenance work-order source populations, and to feed integration extracts where asset identity must be resolved independently of the EAM application layer. A common pattern is filtering by maintenance organization and maintainable flag:

• Asset number LOV: SELECT SERIAL_NUMBER, ASSET_GROUP_DESCRIPTION, CURRENT_SUBINVENTORY_CODE FROM MTL_EAM_ASSET_NUMBERS_V WHERE CURRENT_ORGANIZATION_ID = :org_id AND MAINTAINABLE_FLAG = 'Y' AND SERIAL_NUMBER LIKE :search% ORDER BY SERIAL_NUMBER;
• Criticality reporting: SELECT CURRENT_ORGANIZATION_ID, ASSET_CRITICALITY, COUNT(*) FROM MTL_EAM_ASSET_NUMBERS_V WHERE MAINTENANCE_OBJECT_TYPE = 3 GROUP BY CURRENT_ORGANIZATION_ID, ASSET_CRITICALITY;
• Maintenance object union: filtering on MAINTENANCE_OBJECT_TYPE = 3 and MAINTENANCE_OBJECT_ID selects only asset records when this view is combined with other EAM maintenance object sources.
• Assets not yet synchronized to Fixed Assets: SELECT SERIAL_NUMBER FROM MTL_EAM_ASSET_NUMBERS_V WHERE FA_ASSET_ID IS NULL AND CURRENT_ORGANIZATION_ID = :org_id;

Because MAINTENANCE_OBJECT_TYPE is a hard-coded literal, no join to a lookup is required to distinguish asset rows; callers rely on this constant when constructing multi-object maintenance queries.