Results for “cstbv_item_std_cost_updt_hist”

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

Overview

CSTBV_ITEM_STD_COST_UPDT_HIST is a read-only Oracle EBS view owned by the APPS schema and classified under the Bills of Material (BOM) product family. Its name and column set indicate that it exposes a history of standard cost updates at the item and organization level. The view is marked "Retrofitted" and "VALID" in the ETRM metadata for 12.2.2, and the same object is shipped in 12.1.1 within the APPS schema. The database definition carries the WITH READ ONLY clause, so consumers cannot perform DML against it.

The view's practical purpose is to provide a reporting- and integration-friendly projection of the underlying cost history table, CST_STANDARD_COSTS, joined to organization and item attributes. Rather than exposing raw cost update rows, it resolves foreign keys so that the organization code and organization name are returned alongside the numeric identifiers, and it exposes the item identifier key flexfield resolved reference via the _KF:ITEM_NUMBER:_CO synthetic column. This makes the view suitable for extract, reporting, and reconciliation processes where descriptive attributes are required without additional joins.

Underlying Base Objects

The view is defined over four objects, all referenced through SYNONYMS in the APPS schema:

• CST_STANDARD_COSTS (alias CSC) — the primary source of cost update history rows, supplying cost update identity, standard cost, revision date, and adjustment quantities and values.
• MTL_SYSTEM_ITEMS (alias MSI) — joined on both INVENTORY_ITEM_ID and ORGANIZATION_ID to validate and constrain the item to the correct item master organization.
• MTL_PARAMETERS (alias MP) — joined on ORGANIZATION_ID to supply the organization code.
• HR_ALL_ORGANIZATION_UNITS (alias HAOU) — joined on ORGANIZATION_ID to supply the organization name.

All four tables are equijoined on ORGANIZATION_ID, with MSI additionally joined on INVENTORY_ITEM_ID. The WHERE clause includes a security predicate ('_SEC:CSC.ORGANIZATION_ID' IS NOT NULL), meaning the view is subject to organization-level access control enforced through the Application Object Library security framework.

Key Columns

• COST_UPDATE_ID — unique identifier of the cost update transaction, marking one history record.
• INVENTORY_ITEM_ID — the item for which the standard cost update applies.
• ORGANIZATION_ID — the costing organization; also the column driving the security predicate.
• LAST_COST_UPDATE_ID — reference to a prior cost update, linking successive revisions.
• STANDARD_COST_REVISION_DATE — effective date of the standard cost revision.
• STANDARD_COST — the standard cost value recorded for the item in that organization.
• Adjustment columns — INVENTORY_ADJUSTMENT_QUANTITY and INVENTORY_ADJUSTMENT_VALUE, INTRANSIT_ADJUSTMENT_QUANTITY and INTRANSIT_ADJUSTMENT_VALUE, and WIP_ADJUSTMENT_QUANTITY and WIP_ADJUSTMENT_VALUE capture the revaluation impact of the cost change on inventory, intransit, and work in process balances respectively.
• ORGANIZATION_CODE / ORGANIZATION_NAME — resolved descriptive attributes from MTL_PARAMETERS and HR_ALL_ORGANIZATION_UNITS.
• _KF:ITEM_NUMBER:_CO — key flexfield resolved item number reference.
• WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY provide audit trail.

Common Use Cases and Queries

Typical usages include standard cost audit reporting, revaluation impact analysis, and period-end cost reconciliation. Because the view resolves organization code and name, it is convenient for extracts that feed external cost analysis or data warehouses.

SELECT organization_code,
       organization_name,
       inventory_item_id,
       standard_cost,
       standard_cost_revision_date,
       inventory_adjustment_value,
       wip_adjustment_value
FROM   apps.cstbv_item_std_cost_updt_hist
WHERE  organization_id = :p_org_id
AND    standard_cost_revision_date >= :p_from_date
ORDER BY standard_cost_revision_date;

To trace the revision chain for a single item in one organization:

SELECT cost_update_id,
       last_cost_update_id,
       standard_cost,
       standard_cost_revision_date
FROM   apps.cstbv_item_std_cost_updt_hist
WHERE  inventory_item_id = :p_item_id
AND    organization_id = :p_org_id
ORDER BY standard_cost_revision_date DESC;

Aggregating total revaluation by organization assists in financial reconciliation of the adjustment values booked when standard costs change.