Search Results cst_cost_types

Overview

The CST_COST_TYPES table is a fundamental master data table within the Oracle E-Business Suite (EBS) Bills of Material (BOM) and Cost Management modules. It serves as the central repository for defining and storing all cost types used across the manufacturing and costing processes. A cost type is a classification that groups a set of item costs, resource rates, and overhead rates for purposes such as simulation, reporting, and inventory valuation. The table's integrity is enforced by a primary key on COST_TYPE_ID and a unique key on the combination of COST_TYPE and ORGANIZATION_ID, ensuring that cost type names are unique within an inventory organization. Its extensive network of foreign key relationships underscores its critical role as a reference point for transactional and historical costing data throughout the system.

Key Information Stored

The table's core columns define the identity, control, and description of each cost type. The primary identifier is the numeric COST_TYPE_ID. The COST_TYPE column stores the user-defined name (e.g., 'Frozen', 'Average', 'Pending', 'Simulation'). The ORGANIZATION_ID links the cost type to a specific inventory organization, supporting organization-specific costing. Other significant columns include LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, and CREATED_BY for auditing. Descriptive fields like DESCRIPTION provide further detail on the cost type's purpose. Control flags, such as those indicating if the cost type is frozen or used for defaulting, are also typically stored within this structure.

Common Use Cases and Queries

This table is central to cost analysis, reporting, and data integrity checks. Common operational and reporting scenarios include listing all cost types for a specific organization, validating cost type parameters before running cost updates, and tracing cost data across modules. Sample SQL patterns often involve joining to key transactional tables.

• Listing Active Cost Types: SELECT cost_type, description FROM bom.cst_cost_types WHERE organization_id = :org_id ORDER BY cost_type;
• Validating Cost Type Existence for an Item Cost Query: SELECT cic.item_id, cic.cost_type_id, cct.cost_type, cic.material_cost FROM bom.cst_item_costs cic, bom.cst_cost_types cct WHERE cic.cost_type_id = cct.cost_type_id AND cct.cost_type = 'Frozen' AND cic.organization_id = :org_id;
• Identifying Cost Types Used in Transactions: SELECT DISTINCT cct.cost_type FROM bom.cst_cost_types cct, bom.cst_ae_headers cae WHERE cae.cost_type_id = cct.cost_type_id AND cae.acct_period_id = :period_id;

Related Objects

As indicated by the extensive foreign key metadata, CST_COST_TYPES is a pivotal parent table referenced by numerous costing and inventory tables. Key related objects include:

• CST_ITEM_COSTS / CST_ITEM_COST_DETAILS: Store the detailed item cost information for each cost type.
• CST_ACTIVITY_COSTS / CST_RESOURCE_COSTS / CST_DEPARTMENT_OVERHEADS: Hold the rates for activities, resources, and overheads assigned to a cost type.
• CST_AE_HEADERS: References the cost type used in accounting entries generated by cost transactions.
• CST_PAC_PERIODS: Links to cost types used in Periodic Average Costing (PAC).
• CST_COST_TYPE_HISTORY: Tracks changes made to cost type definitions over time.
• MTL_PAC_ACTUAL_COST_DETAILS / MTL_PAC_TXN_COST_DETAILS: Store actual and transactional cost details for PAC cost types.

This network of relationships highlights that CST_COST_TYPES is not merely a list but a control point that governs cost collection, valuation, and reporting across Oracle EBS Cost Management.