Results for “msi_prod”

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

Overview

APPS.MTL_EAM_ASSET_NUMBERS_V is a read-only Oracle E-Business Suite view that consolidates asset, maintenance, and inventory attributes for Enterprise Asset Management (EAM) reporting and integration. It exposes maintainable units and equipment instances — identified by serial number, instance number, and instance ID — together with their current stocking location, owning maintenance organization, asset group, category, criticality, accounting class, and department ownership. The view is defined in the APPS schema and is intended for querying rather than transactional use.

In practice, the view serves as a reporting bridge between CSI (instance and asset) data and MTL (item and organization) data. Because it joins the production organization context (via the MTL_SERIAL_NUMBERS and MTL_SYSTEM_ITEMS_B_KFV aliases msn_prod and msi_prod), it is frequently used to reconcile which EAM asset corresponds to a given serialized item in a production organization. The user search term "msi_prod" directly references the MTL_SYSTEM_ITEMS_B_KFV alias used for the equipment item, distinguishing it from the maintenance-side msi alias for the asset group definition.

Underlying Base Objects

The documented ETRM metadata lists the following referenced base objects, all resolved through APPS synonyms except where noted: BOM_DEPARTMENTS, CSI_ITEM_INSTANCES, CSI_I_ASSETS, EAM_ORG_MAINT_DEFAULTS, MFG_LOOKUPS (a view), MTL_CATEGORIES_KFV, MTL_EAM_LOCATIONS, MTL_PARAMETERS, MTL_SERIAL_NUMBERS, MTL_SYSTEM_ITEMS, and MTL_SYSTEM_ITEMS_B_KFV (a view).

• CSI_ITEM_INSTANCES (cii) — the driving table; supplies instance, serial number, subinventory, locator, category, criticality, and descriptive flexfield attributes.
• MTL_PARAMETERS (mp) — provides the current maintenance organization ID.
• MTL_SYSTEM_ITEMS (msi) — supplies concatenated segments, EAM item type, and asset group description via MTL_SYSTEM_ITEMS_B_KFV.
• MTL_CATEGORIES_KFV (mck) — yields the concatenated category name.
• MTL_EAM_LOCATIONS (el) — returns EAM location codes.
• EAM_ORG_MAINT_DEFAULTS (eomd) — supplies WIP accounting class, area, and owning department.
• BOM_DEPARTMENTS (bd) — resolves the owning department code.
• MFG_LOOKUPS (ml) — decodes the asset criticality meaning.
• CSI_I_ASSETS (cia) — links the fixed asset ID.
• MTL_SERIAL_NUMBERS (msn_prod) and MTL_SYSTEM_ITEMS_B_KFV (msi_prod) — provide production organization and equipment item context.

Key Columns

• row_id, inventory_item_id, serial_number — instance row identity and item/serial keys.
• descriptive_text, current_subinventory_code, current_locator_id — instance description and current stocking location.
• network_asset_flag, maintainable_flag, asset_criticality_code, asset_criticality — maintenance eligibility and criticality.
• current_organization_id, prod_organization_id, inv_organization_id — maintenance, production, and last-valid inventory organizations.
• concatenated_segments, eam_item_type, asset_group_description — item and asset group identity.
• category_id, category_name — item category references.
• wip_accounting_class_code, area_id, eam_location, owning_department_id, owning_department — accounting and organizational ownership.
• equipment_item_id, eqp_serial_number, fa_asset_id — equipment and fixed-asset linkage.
• maintenance_object_type, maintenance_object_id, instance_number, checkin_status — maintenance object identity and status.
• context and attribute1–attribute30 — descriptive flexfield content.

Common Use Cases and Queries

Typical uses include EAM asset registers, serialized equipment reconciliation, ownership and location reporting, and integration extracts keyed on instance or serial number.

To list maintainable assets for a serial number:

• SELECT serial_number, descriptive_text, asset_group_description, asset_criticality, owning_department FROM apps.mtl_eam_asset_numbers_v WHERE serial_number = :serial;

To reconcile production equipment items against maintenance organizations:

• SELECT equipment_item_id, eqp_serial_number, prod_organization_id, current_organization_id FROM apps.mtl_eam_asset_numbers_v WHERE maintainable_flag = 'Y';

Because the view joins many base tables, queries should filter on indexed columns such as serial_number, inventory_item_id, or organization IDs to limit the join cost.