Results for “estimated_cost”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The AHL_VWP_ROLLUP_COSTS_V view is a reporting and integration object owned by the APPS schema in Oracle E-Business Suite, delivered as part of the AHL – Complex Maintenance Repair and Overhaul product family. It exposes consolidated cost rollup information sourced from the Enterprise Asset Management costing layer. Its primary purpose is to present aggregated actual and estimated cost figures for maintenance and overhaul work without forcing downstream consumers to resolve the individual material, labor, and equipment cost components themselves. The view status is VALID in both 12.1.1 and 12.2.2, and it appears in the APPS object inventory documented through ETRM.

The view is particularly relevant to users searching for actual_lab_cost. Although that column is not exposed directly by the view, it is consumed internally within the view definition to compute the derived ACTUAL_COST value. This makes the view the correct integration point for applications that need total actual cost rather than the granular labor component.

Underlying Base Objects

The view is defined over a single base object: CST_EAM_ROLLUP_COSTS, referenced through a synonym in the APPS schema. The documented ETRM metadata lists this as the only referenced base object. CST_EAM_ROLLUP_COSTS belongs to the Cost Management (CST) product and stores the rolled-up cost components for EAM work orders, including material, labor, and equipment amounts, separated into actual and estimated categories.

The view performs no joins. It is a projection-plus-arithmetic view: it selects identifying columns from the base table and derives two new aggregate cost columns through NVL-protected addition. Because it does not restrict rows by organization, period, or status, it returns the full cost rollup record set of the underlying table, and any filtering must be applied by the calling query.

Key Columns

• OBJECT_ID – Identifier of the costed object, typically corresponding to the work order or maintenance object whose costs were rolled up. Available directly from the base table.
• GROUP_ID – Grouping identifier used to associate rollup cost records that belong to the same logical set of work.
• PROGRAM_APPLICATION_ID – Application identifier of the concurrent program that created the rollup record. Useful for tracing which process populated the row.
• ACTUAL_COST – Derived column computed as NVL(ACTUAL_MAT_COST,0) + NVL(ACTUAL_LAB_COST,0) + NVL(ACTUAL_EQP_COST,0). Despite the underlying name ACTUAL_LAB_COST sought by the user, the view surfaces only this total. Null components are treated as zero.
• ESTIMATED_COST – Derived column computed as NVL(ESTIMATED_MAT_COST,0) + NVL(ESTIMATED_LAB_COST,0) + NVL(ESTIMATED_EQP_COST,0), representing the total estimated cost across material, labor, and equipment.

Common Use Cases and Queries

The view supports cost reporting for overhaul and maintenance work orders, variance analysis between estimated and actual totals, and integration feeds into external systems or custom dashboards. A representative query to obtain total costs for a specific object follows:

SELECT object_id, group_id, actual_cost, estimated_cost
FROM   apps.ahl_vwp_rollup_costs_v
WHERE  object_id = :p_object_id;

To compare estimated against actual at the group level:

SELECT group_id,
       SUM(actual_cost)    AS total_actual,
       SUM(estimated_cost) AS total_estimated,
       SUM(actual_cost) - SUM(estimated_cost) AS variance
FROM   apps.ahl_vwp_rollup_costs_v
GROUP  BY group_id;

Because ACTUAL_LAB_COST is not projected by the view, users who require the labor component in isolation must query CST_EAM_ROLLUP_COSTS directly or create a custom view extending this one.