Search Results cstfv_itm_std_cst_upd_elm_hst




Overview
Explore in AI Chat

Overview

The view CSTFV_ITM_STD_CST_UPD_ELM_HST is a read-only database view owned by the APPS schema in Oracle E-Business Suite. It is associated with the BOM (Bills of Material) product family and functions as a cost management reporting object that exposes historical and current standard cost update information at the elemental level. The "HST" suffix in the object name indicates historical intent, and the view is documented in ETRM as "Retrofitted," meaning it was reconstructed or re-registered to conform to a supported object definition within the EBS data model. Its definition carries the WITH READ ONLY clause, which explicitly prevents DML operations and confirms that the view exists purely for query and reporting purposes. In EBS 12.1.1 and 12.2.2, such views are typically consumed by Oracle Forms-based inquiry screens, concurrent reporting programs, and integration extracts that need to resolve item standard costs alongside organizational and descriptive context in a single flat result set.

Underlying Base Objects

The view is defined over six documented base objects, resolved through APPS synonyms: CST_ELEMENTAL_COSTS (aliased CEC), CST_COST_UPDATES (aliased CCU), CST_COST_ELEMENTS (aliased CCE), MTL_SYSTEM_ITEMS (aliased MSI), MTL_PARAMETERS (aliased MP), and HR_ALL_ORGANIZATION_UNITS (aliased HAOU). CST_ELEMENTAL_COSTS is the driving table, holding the standard cost value and the item/organization descriptor. Joins to MTL_SYSTEM_ITEMS, MTL_PARAMETERS, and HR_ALL_ORGANIZATION_UNITS are all inner joins keyed on ORGANIZATION_ID (and INVENTORY_ITEM_ID for the item master), guaranteeing valid item and organization context. The join to CST_COST_UPDATES is an outer join ((+) syntax), allowing cost element rows to appear even when no corresponding cost update header exists. The join to CST_COST_ELEMENTS maps COST_ELEMENT_ID to its named element, enabling readable cost element labels.

Key Columns

The view exposes a composite key and descriptive set of columns:

Common Use Cases and Queries

Typical uses include reconciling standard costs by cost element across organizations, auditing historical cost update activity, and feeding downstream cost reporting. Because the view is read-only, it is safe for ad-hoc inquiry. A representative query retrieves standard costs for a given item across organizations:

SELECT inventory_item_id,
       organization_code,
       cost_element_name,
       standard_cost,
       cost_update_description
FROM   apps.cstfv_itm_std_cst_upd_elm_hst
WHERE  "_KF:ITEM_NUMBER:_CO" = :item_number
ORDER  BY organization_code, cost_element_name;

Analysts also aggregate total standard cost per item and organization, or filter by COST_UPDATE_ID to trace a specific cost rollup. The reserved keyword _SEC:CEC.ORGANIZATION_ID predicate embedded in the definition enforces organization-level security, ensuring users see only data for organizations they are authorized to access.