Search Results quantity_open

Overview

EAM_CFR_MATERIALS_V is a reporting and integration view owned by the APPS schema within the Enterprise Asset Management (EAM) module of Oracle E-Business Suite. As documented in the ETRM metadata for releases 12.1.1 and 12.2.2, the view presents information on materials associated with work orders, joining work order requirement operations to item definitions, departments, and lookup values. It consolidates the material demand picture for a work order operation — what item is required, in what quantity, by what date, from which subinventory or locator, and how much has been issued, allocated, or remains open.

The view text explicitly exposes MSIK.PRIMARY_UOM_CODE aliased as ITEM_PRIMARY_UOM_CODE, which is why the view surfaces in searches for "item_primary_uom_code." Because the unit of measure is carried alongside required, issued, allocated, and open quantities, the view is well suited for demand-versus-supply reporting, work order material shortage analysis, and downstream integration extracts where quantities must be expressed in the item's primary UOM.

Underlying Base Objects

The documented base objects referenced by the view are:

• WIP_REQUIREMENT_OPERATIONS (synonym) — the driving table, aliased WRO, supplying work order material requirement rows: inventory item, organization, WIP entity, operation sequence, department, supply type, date required, required quantity, quantity issued, supply subinventory and locator, and descriptive flexfield attributes.
• MTL_SYSTEM_ITEMS_KFV (synonym) — the key flexfield item view, aliased MSIK, supplying concatenated segments, item description, primary UOM code, inventory asset flag, and the location, locator, and subinventory control flags. It is joined on both inventory item ID and organization ID.
• BOM_DEPARTMENTS (synonym) — aliased BD, providing the department code through an outer join on department ID.
• MFG_LOOKUPS (view) — referenced twice as ML1 and ML2 to resolve lookup codes into display meanings for WIP supply type and the MRP net flag.
• EAM_MATERIAL_ALLOCQTY_PKG (package) — invoked in the select list to compute allocated quantity for the work order, operation sequence, organization, and inventory item, and reused within the open quantity calculation.

The join filters to items where the stock enabled flag is null or 'Y', so non-stockable items are generally excluded from the material picture.

Key Columns

• INVENTORY_ITEM_ID, CONCATENATED_SEGMENTS, ITEM_DESCRIPTION — item identity.
• ITEM_PRIMARY_UOM_CODE — the item's primary unit of measure.
• ORGANIZATION_ID, WIP_ENTITY_ID, OPERATION_SEQ_NUM, DEPARTMENT_ID, DEPARTMENT_CODE — work order and routing context.
• WIP_SUPPLY_TYPE and WIP_SUPPLY_DISP — supply type code and its decoded meaning.
• DATE_REQUIRED, REQUIRED_QUANTITY, QUANTITY_ISSUED, QUANTITY_OPEN, QUANTITY_ALLOCATED, RELEASED_QUANTITY — demand and fulfillment metrics. Open quantity is computed as required quantity less NVL(issued, 0) less allocated quantity.
• QUANTITY_PER_ASSEMBLY, SUPPLY_SUBINVENTORY, SUPPLY_LOCATOR_ID — per-assembly usage and default supply location.
• MRP_NET_FLAG, MRP_NET_DISP, MPS_REQUIRED_QUANTITY, MPS_DATE_REQUIRED — planning attributes.
• AUTO_REQUEST_MATERIAL, COMPONENT_SEQUENCE_ID, and ATTRIBUTE1–15 — supply automation, component linkage, and descriptive flexfield content.

Common Use Cases and Queries

Typical usage includes open material reporting, shortage identification, and feeding external systems with work order material data in the item's primary UOM.

• List open materials for a work order in primary UOM:

  SELECT wip_entity_id, operation_seq_num, concatenated_segments,
         item_primary_uom_code, required_quantity, quantity_issued,
         quantity_allocated, quantity_open, date_required
  FROM   apps.eam_cfr_materials_v
  WHERE  wip_entity_id = :wip_entity_id
  ORDER BY operation_seq_num;

• Identify shortages by comparing open quantity to available stock, or aggregate demand by item and organization for planning.
• Report material demand by department or by required date, joining DEPARTMENT_CODE and WIP_SUPPLY_DISP for readable output.
• Extract allocated versus issued quantities for reconciliation against WIP transactions.

Because quantity_open and quantity_allocated depend on EAM_MATERIAL_ALLOCQTY_PKG, queries benefit from filtering by organization or work order to limit row volumes.