Search Results wip_eam_cst_header_v




Overview
Explore in AI Chat

Overview

WIP_EAM_CST_HEADER_V is an Oracle EBS Work in Process (WIP) view owned by the APPS schema. It presents cost header information for Enterprise Asset Management (EAM) work orders, consolidating attributes from discrete job records, work order status details, asset instance data, and estimation status lookups into a single reporting interface. The view is defined as a UNION ALL of two query blocks, allowing it to surface both asset-linked work orders and non-asset (rebuild or standalone) work orders within one result set. Because it exposes status, department, estimation, and asset context together, it is well suited to cost estimation reporting, work order dashboards, and downstream integrations that require a normalized EAM cost header row.

Underlying Base Objects

The view is defined over the following documented base objects:

The relationships are enforced through outer joins on WIP_ENTITIES and BOM_DEPARTMENTS, and inner joins on MFG_LOOKUPS, CSI_ITEM_INSTANCES, and EAM_WORK_ORDER_DETAILS_V, ensuring consistent cost header rows for maintained EAM work orders.

Key Columns

Common Use Cases and Queries

The view is typically used to report estimation status across EAM work orders or to feed cost estimation processes. A sample query listing open estimations by department is shown below:

SELECT h.wip_entity_id,
       h.organization_id,
       h.job_status,
       h.estimation_status_meaning,
       h.owning_department,
       h.scheduled_completion_date,
       h.serial_number
FROM   apps.wip_eam_cst_header_v h
WHERE  h.estimation_status IN (1,2,3)
AND    h.organization_id = :org_id
ORDER BY h.scheduled_completion_date;

Typical scenarios include tracking work orders pending estimation, reconciling last estimation dates, reporting asset-linked versus rebuild work orders, and driving dashboards that combine WIP cost headers with asset instance details.