Search Results restrict_subinventories_code




Overview
Explore in AI Chat

Overview

WIP_EAM_REQUIREMENTS_ALL_V is a reporting view owned by the APPS schema in Oracle E-Business Suite (validated for 12.1.1 and 12.2.2). It resides in the WIP – Work in Process product and, in the EAM (Enterprise Asset Management) context, presents every material requirement associated with a work order. Unlike the base transactional table WIP_REQUIREMENT_OPERATIONS, this view joins item master attributes, department information, routing operation data, and lookup meanings into a single denormalized row per requirement, making it suitable for direct reporting, BI Publisher layouts, and integration extracts without the need for multiple joins.

The view is of particular interest to users searching on inventory_asset_flag, because that attribute is projected directly from MTL_SYSTEM_ITEMS_KFV. Consumers therefore see, in one row, the material requirement quantity alongside the asset/non-asset classification of the item being consumed, which drives capitalization logic and asset accounting in EAM work orders.

Underlying Base Objects

The documented base objects for the view are:

The join enforces that the item exists in the item master and has NVL(STOCK_ENABLED_FLAG,'N') = 'Y'.

Key Columns

Common Use Cases and Queries

Typical uses include open-material reports by work order, asset versus non-asset consumption analysis, and feeds into costing or procurement.

  • List all asset-flagged requirements for an organization.
  • Compute outstanding demand per work order.
  • Join to WIP entities for scheduling reports.

Sample SQL:

  • SELECT wip_entity_id, operation_seq_num, concatenated_segments, inventory_asset_flag, required_quantity, quantity_issued, quantity_open FROM apps.wip_eam_requirements_all_v WHERE organization_id = :org_id AND inventory_asset_flag = 'Y' ORDER BY wip_entity_id, operation_seq_num;
  • SELECT wip_entity_id, SUM(quantity_open) open_qty FROM apps.wip_eam_requirements_all_v WHERE organization_id = :org_id GROUP BY wip_entity_id;