Search Results wip_eam_direct_items




Overview
Explore in AI Chat

Overview

WIP_EAM_DIRECT_ITEMS is a Work in Process (WIP) transactional table that stores description-based direct items associated with enterprise asset management (EAM) work orders. In Oracle EBS 12.1.1 and 12.2.2, direct items represent materials, services, or non-inventory purchases that are charged directly to a work order without being defined as inventory items in the item master. This table captures the purchasing and requisition attributes needed to procure those items against a specific work order operation.

The table resides in the WIP schema and is documented with 47 columns in the ETRM 12.2.2 physical schema. Only one foreign key is documented — DEPARTMENT_ID references BOM_DEPARTMENTS — which is why the heuristic Data Vault classification derived from the FK structure is standalone. As a modeling suggestion, this classification reflects the sparse relationship footprint rather than functional dependence; in practice the table behaves as a transactional satellite of the work order entity, keyed by DIRECT_ITEM_SEQUENCE_ID and carrying descriptive and procurement attributes.

Key Information Stored

The surrogate primary key is DIRECT_ITEM_SEQUENCE_ID, which is also the sole documented unique index (WIP_EAM_DIRECT_ITEMS_U1) and therefore the primary business-key candidate. The remaining columns fall into several groups.

Common Use Cases and Queries

The most frequent reporting scenarios involve retrieving all direct items for a work order, checking procurement status, and joining to vendor or department reference data.

  • List direct items for a work order: SELECT DIRECT_ITEM_SEQUENCE_ID, DESCRIPTION, REQUIRED_QUANTITY, UNIT_PRICE, AMOUNT FROM WIP_EAM_DIRECT_ITEMS WHERE WIP_ENTITY_ID = :entity_id ORDER BY OPERATION_SEQ_NUM;
  • Identify items requiring automatic requisition: WHERE AUTO_REQUEST_MATERIAL = 'Y' AND NEED_BY_DATE < SYSDATE + 7
  • Department rollup: join DEPARTMENT_ID to BOM_DEPARTMENTS to report spend by department.
  • Vendor aggregation: group by SUGGESTED_VENDOR_ID to summarize suggested spend.
  • Open commitments: sum AMOUNT by WIP_ENTITY_ID for work-order cost review.

Related Objects