Results for “cst_eam_activity_estimates_v”

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

Overview

The CST_EAM_ACTIVITY_ESTIMATES_V view is an APPS-owned database object that resides in the Bills of Material (BOM) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. Its stated purpose is to retrieve estimated activity cost for Enterprise Asset Management (EAM) maintenance activities. The view consolidates granular cost records maintained at the activity estimate level and pivots the individual EAM cost elements into discrete, report-friendly columns for equipment, labor, and material. This transformation makes it possible for maintenance planners, cost analysts, and reporting tools to consume activity-level estimates without performing the element-level aggregation themselves.

The view plays a supporting role in EAM work definition and maintenance cost roll-up reporting. Because it abstracts the underlying cost element encoding into named columns and joins the results to the manufacturing lookup that defines valid maintenance cost categories, it provides a stable and self-describing data source for custom reports, Oracle Discoverer workbooks, and integration extracts.

Underlying Base Objects

According to the documented ETRM metadata, CST_EAM_ACTIVITY_ESTIMATES_V is defined over two referenced base objects:

• CST_EAM_ACTIVITY_ESTIMATES (exposed as a SYNONYM) — the principal base table holding the raw activity estimate records, including the maintenance cost category, the activity estimate record identifier, the record type, the EAM cost element, and the numeric cost value.
• MFG_LOOKUPS (a VIEW) — the manufacturing lookup source used to resolve lookup codes into descriptive meanings. The view restricts this join to the lookup type BOM_EAM_COST_CATEGORY.

The view internally filters the base table to records where RECORD_TYPE = 'S' and then splits the cost by EAM_COST_ELEMENT, mapping element 1 to Equipment, element 2 to Labor, and element 3 to Material. These three element-specific result sets are combined with UNION, then grouped by MAINT_COST_CATEGORY and ACTIVITY_ESTIMATE_RECORD_ID to produce summed totals. A NVL safeguard ensures that null aggregates are returned as zero, and an outer join on the lookup table allows cost categories that exist in the lookup but have no estimate records to still appear with zero values.

Key Columns

• MAINT_COST_CATEGORY — the maintenance cost category code, drawn from the LOOKUP_CODE of the lookup type BOM_EAM_COST_CATEGORY. This is the column most directly associated with the search term "maint_cost_category".
• ACTIVITY_ESTIMATE_RECORD_ID — the identifier of the activity estimate record to which the aggregated costs belong; this is the primary grouping key alongside the cost category.
• MEANING — the descriptive meaning of the maintenance cost category, resolved from the lookup table for display purposes.
• EQUIPMENT — the summed estimated equipment cost, defaulting to zero when no value exists.
• LABOR — the summed estimated labor cost, defaulting to zero when no value exists.
• MATERIAL — the summed estimated material cost, defaulting to zero when no value exists.
• TOTAL — the sum of the equipment, labor, and material components, defaulting to zero. This represents the total estimated activity cost for the given category and activity estimate record.

Common Use Cases and Queries

Typical usage centers on reviewing estimated maintenance cost broken down by cost category and by activity estimate record. A basic query returning all estimates for a set of activity estimate records is:

• SELECT maint_cost_category, meaning, equipment, labor, material, total FROM apps.cst_eam_activity_estimates_v WHERE activity_estimate_record_id = :record_id;

Analysts commonly aggregate totals by cost category to view the estimated cost distribution across the maintenance organization:

• SELECT maint_cost_category, meaning, SUM(equipment) equipment, SUM(labor) labor, SUM(material) material, SUM(total) total FROM apps.cst_eam_activity_estimates_v GROUP BY maint_cost_category, meaning ORDER BY maint_cost_category;

Because the view outer-joins to MFG_LOOKUPS, categories with no posted estimates still surface, which is useful when validating that every defined maintenance cost category has been costed. The view therefore serves both as a transactional reporting source and as a completeness check for EAM activity cost estimation.