Search Results operation_dept_code




Overview
Explore in AI Chat

Overview

EAM_DIRECT_ITEMS_V is a read-only dictionary view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Enterprise Asset Management (EAM) product family and exposes the direct-item detail lines associated with work order cost estimates. As documented in ETRM, the view "shows the details of direct items from cst_eam_wo_estimate_details table." In practical terms, it presents requisitioned and purchase-ordered direct material and service lines captured against a work order estimate, decorated with department, item, and procurement reference information.

The view plays a reporting and integration role rather than a transactional one. Because it flattens EAM estimate detail rows into a denormalized, human-readable form—resolving department code, requisition number, and purchase order number—it is well suited to cost-analysis reports, work order estimate inquiries, and downstream extracts. Status is VALID in the documented environment, confirming the view compiles cleanly against its base objects.

Underlying Base Objects

The view is defined over the following documented base objects, all referenced through APPS synonyms:

The join between the estimate details and BOM_DEPARTMENTS is an inner join, so only lines whose owning department resolves within the same organization are returned. The WHERE clause restricts output to lines that are either requisitioned (with an uncancelled or null req line cancel flag) or purchase-ordered (with an uncancelled or null PO line cancel flag), excluding cancelled procurement lines.

Key Columns

Common Use Cases and Queries

Typical scenarios include reconciling direct material cost against a work order estimate, listing requisitioned or ordered items by operation department, and feeding cost data into custom reports or extracts.

To retrieve all direct items for a specific work order:

  • SELECT wip_entity_id, organization_id, operation_dept_code, operations_seq_num, item_description, item_cost, required_quantity, requisition_number, po_number, total_direct_cost FROM apps.eam_direct_items_v WHERE wip_entity_id = :wip_entity_id ORDER BY operations_seq_num;

To summarize total direct cost by department code for an organization:

  • SELECT operation_dept_code, SUM(total_direct_cost) total_cost FROM apps.eam_direct_items_v WHERE organization_id = :org_id GROUP BY operation_dept_code;

To list only purchased (non-requisition) items:

  • SELECT wip_entity_id, po_number, item_description, required_quantity FROM apps.eam_direct_items_v WHERE po_number IS NOT NULL;

Because the view performs correlated subqueries per row, queries against large work order populations can be expensive; filtering by WIP_ENTITY_ID or ORGANIZATION_ID is recommended. Note that the view exposes only non-cancelled procurement lines and inner-joins to BOM_DEPARTMENTS, so lines with unresolved departments are excluded.