Results for “inventory_adjustment_quantity”

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

Overview

CST_STANDARD_COSTS is a cost history table owned by the BOM (Bills of Material) schema in Oracle E-Business Suite. It stores the historical record of standard costs for inventory items across organizations, with each row tied to a specific cost update event recorded in CST_COST_UPDATES. The table is central to standard costing operations because it preserves both the standard cost value applied and the accounting adjustments triggered at the moment a new standard cost is frozen and rolled into the general ledger.

Under the heuristic Data Vault classification mined from its foreign key structure, CST_STANDARD_COSTS is best modeled as a link table. It resolves the many-to-many relationship between cost update events (CST_COST_UPDATES) and inventory items/organizations, capturing the transactional association between a costing run and the items it affects. The two foreign keys to CST_COST_UPDATES — COST_UPDATE_ID and LAST_COST_UPDATE_ID — reinforce this link interpretation while also adding a self-referencing historical thread.

Key Information Stored

The primary key is CST_STANDARD_COSTS_PK, composed of COST_UPDATE_ID, INVENTORY_ITEM_ID, and ORGANIZATION_ID. The unique index CST_STANDARD_COSTS_U1 covers the same three columns, confirming this triple as the business-key candidate that guarantees one standard cost row per update, per item, per organization.

The most significant columns include:

• COST_UPDATE_ID — identifier of the cost update event; the driving foreign key to CST_COST_UPDATES.
• INVENTORY_ITEM_ID — the item whose standard cost is being recorded.
• ORGANIZATION_ID — the inventory organization context.
• STANDARD_COST — the frozen standard cost value applied by the update.
• STANDARD_COST_REVISION_DATE — the effective date of the revised standard cost.
• LAST_COST_UPDATE_ID — references the prior cost update, providing a historical chain.
• INVENTORY_ADJUSTMENT_QUANTITY / INVENTORY_ADJUSTMENT_VALUE — on-hand revaluation quantity and value at the new standard.
• INTRANSIT_ADJUSTMENT_QUANTITY / INTRANSIT_ADJUSTMENT_VALUE — adjustments for intransit inventory.
• WIP_ADJUSTMENT_QUANTITY / WIP_ADJUSTMENT_VALUE — Work in Process revaluation figures.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID — concurrent program audit context of the costing run.
• LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Cost accountants use this table to audit standard cost changes over time and to reconcile revaluation adjustments posted to inventory and WIP accounts. A typical query retrieves the latest standard cost for an item:

• SELECT standard_cost, standard_cost_revision_date FROM cst_standard_costs WHERE inventory_item_id = :item AND organization_id = :org ORDER BY standard_cost_revision_date DESC;
• Joining to CST_COST_UPDATES on COST_UPDATE_ID retrieves the update name, status, and cost type for reporting.
• Summing INVENTORY_ADJUSTMENT_VALUE, INTRANSIT_ADJUSTMENT_VALUE, and WIP_ADJUSTMENT_VALUE by update supports period-end revaluation reporting.
• Comparing LAST_COST_UPDATE_ID across rows reconstructs the historical progression of an item's standard cost.

Related Objects

• CST_COST_UPDATES — joined via COST_UPDATE_ID and LAST_COST_UPDATE_ID; the parent event table.
• MTL_SYSTEM_ITEMS_B — joined via INVENTORY_ITEM_ID for item descriptions.
• ORG_ORGANIZATION_DEFINITIONS — joined via ORGANIZATION_ID for organization names.
• CST_ITEM_COSTS — related cost detail for the same item and organization.
• MTL_MATERIAL_TRANSACTIONS — consumable for reconciling inventory valuation movements.
• FND_CONCURRENT_REQUESTS — joined via REQUEST_ID for program run audit.

Together these objects form the standard costing audit trail within the BOM and Cost Management modules.