Search Results eam_materials_v




Overview
Explore in AI Chat

Overview

APPS.EAM_MATERIALS_V is a seeded, VALID database view in the Oracle E-Business Suite Enterprise Asset Management (EAM) module. Its documented purpose is to show the details of materials associated with an EAM work order — specifically, the non-direct inventory items that a work order estimates or requires at a given operation. The view joins work order estimate detail lines to item master and department definitions, producing a denormalized, report-ready result set suitable for BI Publisher reports, Oracle Discoverer workbooks, OBIEE/OTBI extracts, and custom concurrent programs.

The view is read-only by definition; it exposes no DML surface and is intended purely for query and reporting. Because it resides in the APPS schema and draws on the Item Key Flexfield view, it also inherits organization-specific flexfield security and value set validation applied to MTL_SYSTEM_ITEMS_KFV.

Underlying Base Objects

The ETRM 12.2.2 metadata documents three referenced base objects, all exposed through synonyms in the APPS schema:

  • CST_EAM_WO_ESTIMATE_DETAILS — the driving table holding the estimated material detail rows for a work order, including the department that owns the requirement and the operation sequence.
  • MTL_SYSTEM_ITEMS_KFV — the key flexfield view over the item master, supplying the concatenated item segment string and stock-enabled indicator.
  • BOM_DEPARTMENTS — the department definition table, providing the department code used to label the owning department on each row.

The join predicates are documented as EED.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID and EED.ORGANIZATION_ID = MSIK.ORGANIZATION_ID for the item join, and EED.ORGANIZATION_ID = BD.ORGANIZATION_ID with BD.DEPARTMENT_ID = EED.OWNING_DEPT_ID for the department join. Two filters are applied: NVL(EED.DIRECT_ITEM,'N') <> 'Y' (excludes direct items) and MSIK.STOCK_ENABLED_FLAG = 'Y' (includes only stock-enabled items).

Key Columns

  • WIP_ENTITY_ID — identifier of the EAM work order (WIP entity) the material line belongs to.
  • ORGANIZATION_ID — the inventory organization in which the work order and item reside.
  • OPERATIONS_DEPT_ID — the department associated with the operation where the material is required. This is the column matched by the user's search term "operations_dept_id".
  • OPERATIONS_SEQ_NUM — the sequence number of the operation on the work order routing.
  • DEPARTMENT_CODE / OPERATION_DEPT_CODE — the decoded department code from BOM_DEPARTMENTS.
  • CONCATENATED_SEGMENTS — the concatenated item flexfield string identifying the material.
  • REQUIRED_QUANTITY — the quantity of material required by the work order estimate.
  • ITEM_COST — the unit cost of the material.
  • TOTAL_ITEM_COST — computed as NVL(ITEM_COST,0) * NVL(REQUIRED_QUANTITY,0), giving the extended material cost.

Common Use Cases and Queries

Typical uses include material shortage and reservation analysis, work order cost rollup reporting, and department-level material consumption summaries. The following query lists estimated materials for a work order by operation department:

  • SELECT wip_entity_id, operations_seq_num, operations_dept_id, operation_dept_code, concatenated_segments, required_quantity, total_item_cost FROM apps.eam_materials_v WHERE wip_entity_id = :wip_entity_id ORDER BY operations_seq_num;
  • SELECT operations_dept_id, operation_dept_code, SUM(total_item_cost) FROM apps.eam_materials_v WHERE organization_id = :org_id GROUP BY operations_dept_id, operation_dept_code;

Because the view excludes direct items and non-stock-enabled items, it should not be used for a complete bill of material listing; it is purpose-built for the stocked, indirect material content of EAM work orders.