Search Results cst_item_costs_pk

Overview

CST_ITEM_COSTS is the item cost summary table within the Oracle E-Business Suite Cost Management (CST) and Bills of Material (BOM) schema. It stores the frozen, current cost of every inventory item at a given organization and cost type, aggregating the material, material overhead, resource, outside processing, and overhead components that together form an item's cost. The table sits at the intersection of the item master and the costing engine: it is populated by the cost rollup, cost update, and cost adjustment processes, and it serves as the authoritative single-row-per-item reference for on-hand valuation, margin analysis, and standard versus actual cost comparison.

When modeled through a Data Vault lens, the FK structure suggests a satellite-leaning classification. The natural business key of the table — the combination of inventory item, organization, and cost type — is stable and non-transactional, while the cost amounts themselves are descriptive attributes that change on each cost update. This makes CST_ITEM_COSTS a candidate satellite attached to an item/organization hub, with COST_UPDATE_ID and ROLLUP_ID acting as link references to the costing runs that produced each version of the record.

Key Information Stored

The surrogate identifier documented for this table is CST_ITEM_COSTS_PK, defined over INVENTORY_ITEM_ID, COST_TYPE_ID, and ORGANIZATION_ID. A second unique index, CST_ITEM_COSTS_U1, covers INVENTORY_ITEM_ID, ORGANIZATION_ID, and COST_TYPE_ID and represents the business-key candidate: the same logical grain expressed without the surrogate ordering. The most significant columns include:

• INVENTORY_ITEM_ID, ORGANIZATION_ID, COST_TYPE_ID — the composite key identifying which item is costed, in which inventory organization, under which cost type (standard, average, FIFO, LIFO, or a user-defined type).
• ITEM_COST — the total unit cost of the item, the value most commonly reported and compared.
• MATERIAL_COST, MATERIAL_OVERHEAD_COST, RESOURCE_COST, OUTSIDE_PROCESSING_COST, OVERHEAD_COST — the five elemental cost components that sum into the item cost.
• PL_MATERIAL, PL_MATERIAL_OVERHEAD, PL_RESOURCE, PL_OUTSIDE_PROCESSING, PL_OVERHEAD — the prior-level cost breakdown used for cost rollup comparison.
• TL_MATERIAL, TL_MATERIAL_OVERHEAD, TL_RESOURCE, TL_OUTSIDE_PROCESSING, TL_OVERHEAD — the this-level cost breakdown for the same five elements.
• PL_ITEM_COST, TL_ITEM_COST — prior-level and this-level item cost totals used by the rollup engine.
• UNBURDENED_COST, BURDEN_COST — the cost before and after overhead burden is applied.
• COST_UPDATE_ID — references the cost update that last touched the row; ROLLUP_ID and ASSIGNMENT_SET_ID tie the record to specific rollup and assignment set runs.
• INVENTORY_ASSET_FLAG, LOT_SIZE, BASED_ON_ROLLUP_FLAG, SHRINKAGE_RATE, DEFAULTED_FLAG — control attributes governing valuation behavior, rollup sourcing, and shrinkage.
• Standard WHO columns (LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, REQUEST_ID, PROGRAM_ID) support audit and concurrent program traceability, alongside fifteen generic ATTRIBUTE columns.

Common Use Cases and Queries

The table is most frequently queried to retrieve the current cost of an item for inventory valuation, transfer price calculation, and margin reporting. A typical pattern joins to the item master and cost types to resolve descriptions:

• Retrieve unit cost for a specific item and organization: SELECT item_cost FROM cst_item_costs WHERE inventory_item_id = :item_id AND organization_id = :org_id AND cost_type_id = :cost_type_id;
• Compare standard versus average cost for the same item by joining across COST_TYPE_ID values.
• Report the cost element breakdown (material, resource, overhead) across an organization for absorption analysis.
• Identify stale or defaulted costs using DEFAULTED_FLAG and LAST_UPDATE_DATE for cost accuracy reviews.
• Reconcile CST_ITEM_COST_DETAILS against the summary to validate rollup completeness.

Related Objects

The documented foreign keys and dependent relationships tie CST_ITEM_COSTS to the following principal objects:

• CST_COST_TYPES — joined on COST_TYPE_ID; defines the costing method applied to each row.
• MTL_SYSTEM_ITEMS_B — joined on INVENTORY_ITEM_ID and ORGANIZATION_ID; supplies item and organization context.
• CST_COST_UPDATES — joined on COST_UPDATE_ID; identifies the cost update run that produced the record.
• CST_ITEM_COST_DETAILS — references CST_ITEM_COSTS through INVENTORY_ITEM_ID, COST_TYPE_ID, and ORGANIZATION_ID; provides the detailed component-level explosion behind the summary.
• CST_COST_ROLLUPS / rollup identifiers — referenced via ROLLUP_ID for rollup traceability.

These relationships place CST_ITEM_COSTS as the central summary point between item definitions, cost structures, and the detailed cost element tables that feed valuation and reporting across the Cost Management module.