Search Results mtl_eam_item_type




Overview
Explore in AI Chat

Overview

APPS.BOM_BILL_OF_MATERIALS_V is a reporting and integration view that exposes bill of materials (BOM) header records in Oracle E-Business Suite 12.1.1 and 12.2.2. It joins the base BOM header entity to item master attributes, item descriptions, lookup meanings, and structure type configuration, producing a denormalized row set suitable for inquiry screens, concurrent programs, interfaces, and ad hoc SQL. Because the view presents one row per bill of materials header (per assembly item, organization, and alternate designator), it is the standard entry point for retrieving assembly-level BOM metadata without manually joining BOM_BILL_OF_MATERIALS to MTL_SYSTEM_ITEMS and the surrounding lookup tables.

The view is relevant to searches involving mtl_eam_item_type because it explicitly resolves that lookup code to its display meaning through the MFG_LOOKUPS table, aliased as MGL. Users investigating Enterprise Asset Management (EAM) item classification alongside BOM structures will find this view a convenient, single-source projection of both manufacturing and EAM item attributes.

Underlying Base Objects

The view is defined over the following documented objects:

  • BOM_BILL_OF_MATERIALS (VIEW) — the primary BOM header source, providing assembly item, organization, alternate designator, bill sequence, effectivity control, and audit columns.
  • MTL_SYSTEM_ITEMS (SYNONYM) — supplies item master attributes such as UOM, BOM item type, pick components flag, replenish-to-order flag, EAM item type, and engineering item flag.
  • MTL_SYSTEM_ITEMS_TL (SYNONYM) — provides the language-specific item description, filtered by the session language.
  • FND_COMMON_LOOKUPS (VIEW) — resolves ITEM_TYPE lookup codes into a translated meaning.
  • MFG_LOOKUPS (VIEW) — resolves the MTL_EAM_ITEM_TYPE lookup code into a translated meaning.
  • BOM_STRUCTURE_TYPES_B (SYNONYM) — supplies structure type enablement attributes, notably whether unimplemented BOMs are permitted.

The MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_TL joins are performed on inventory item and organization identifiers, and the session language is applied via USERENV('LANG'). Lookup joins are outer joins, so records without a matching lookup meaning remain visible.

Key Columns

Common Use Cases and Queries

Typical uses include listing all BOM headers for a given organization, reporting EAM-classified assemblies, and validating which structures may reference unimplemented engineering changes.

SELECT assembly_item_id, organization_id, alternate_bom_designator,
       description, eam_item_type, eam_item_type_value
FROM   apps.bom_bill_of_materials_v
WHERE  organization_id = 207
AND    bom_item_type = 4;

To inspect only EAM items:

SELECT assembly_item_id, description, eam_item_type_value
FROM   apps.bom_bill_of_materials_v
WHERE  eam_item_type IS NOT NULL
ORDER BY description;

The view is appropriate for read-only reporting and integration extracts; because it derives from base BOM and item tables, direct DML should be performed against the underlying base entities rather than the view itself.