Search Results cost_update_description




Overview
Explore in AI Chat

Overview

APPS.CSTFV_ITM_STD_CST_UPD_ELM_HST is a Business Intelligence System (BIS) view in the Oracle E-Business Suite Applications (APPS) schema. It is registered under FND Design Data as BOM.CSTFV_ITM_STD_CST_UPD_ELM_HST and is documented with a status of VALID. The view presents elemental item cost history for every standard cost update, exposing a flattened, denormalized result set that combines cost update headers, elemental cost detail, item master attributes, and organization information.

The view belongs to the Cost Management (CST) product family, with a design data association to BOM. Its role is to provide a read-only, reporting-friendly interface that allows users, discoverer reports, and integration programs to retrieve the standard cost of an inventory item by cost element as of each standard cost update. Because standard cost updates overwrite current item costs in the transaction tables, this history view is significant: it preserves the elemental cost value associated with a specific cost update, identified by COST_UPDATE_ID. The column COST_UPDATE_DESCRIPTION, which corresponds to the user's search term "cost_update_description," carries the descriptive name of the cost update and is one of the primary business-facing attributes exposed by the view.

Underlying Base Objects

The view is defined over six base objects, all referenced through APPS synonyms:

  • CST_COST_UPDATES — the cost update header table; supplies the cost update identity and description, and links to the other cost objects.
  • CST_ELEMENTAL_COSTS — stores elemental item cost values; supplies the standard cost per item and cost element for each cost update.
  • CST_COST_ELEMENTS — the cost element definition table; supplies the cost element name used to label each elemental cost row.
  • MTL_SYSTEM_ITEMS — the item master; supplies the concatenated key flexfield item number (_KF:ITEM_NUMBER:_CO) and item context.
  • MTL_PARAMETERS — the organization parameters table; supplies the organization code and links the item to its inventory organization.
  • HR_ALL_ORGANIZATION_UNITS — the organization units table; supplies the organization name.

Because CST_ELEMENTAL_COSTS is retained by cost update and keyed by item and cost element, the join across these tables produces one row per cost update, item, and cost element combination. The view is not referenced by any other database object, confirming its role as a terminal reporting object rather than a building block for further application logic.

Key Columns

  • COST_UPDATE_ID — identifier of the standard cost update; the primary grouping key for historical comparison.
  • COST_UPDATE_DESCRIPTION (VARCHAR2, 240) — the description of the cost update, answering the user's query term "cost_update_description."
  • ORGANIZATION_ID / ORGANIZATION_CODE / ORGANIZATION_NAME — the inventory organization context for the cost record.
  • INVENTORY_ITEM_ID / _KF:ITEM_NUMBER:_CO — the item identifier and its concatenated key flexfield display value.
  • COST_ELEMENT_ID / COST_ELEMENT_NAME — the cost element and its name (for example, material, material overhead, resource, outside processing, overhead).
  • STANDARD_COST — the elemental standard cost value for the item, organization, cost element, and cost update.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — audit columns inherited from the underlying cost rows.

Common Use Cases and Queries

Typical uses include cost rollup audit and reconciliation, historical standard cost trend reporting, and external integration extracts where a description of the cost update and the elemental breakdown are required.

To trace a single item's elemental standard cost across all cost updates in an organization:

  • SELECT cost_update_id, cost_update_description, organization_code, organization_name, "_KF:ITEM_NUMBER:_CO", cost_element_name, standard_cost FROM apps.cstfv_itm_std_cst_upd_elm_hst WHERE organization_code = :org AND inventory_item_id = :item ORDER BY cost_update_id, cost_element_name;

To list all cost updates and their descriptions:

  • SELECT DISTINCT cost_update_id, cost_update_description FROM apps.cstfv_itm_std_cst_upd_elm_hst ORDER BY cost_update_id;

To compare elemental costs between two updates for variance analysis, the view can be self-joined on inventory_item_id and cost_element_id, filtering on two COST_UPDATE_ID values and subtracting the respective STANDARD_COST values. Because the view performs multi-table joins at runtime, queries should filter on ORGANIZATION_ID, INVENTORY_ITEM_ID, or COST_UPDATE_ID to keep execution efficient in both 12.1.1 and 12.2.2 environments.