Search Results mtl_cst_txn_cost_details




Overview
Explore in AI Chat

Overview

The MTL_CST_TXN_COST_DETAILS table is a core transactional data repository within the Oracle E-Business Suite Inventory (INV) module. It serves the critical function of storing the detailed cost breakdown for inventory transactions. As its description states, it holds "The cost of a transaction by element and by level." This granular storage is fundamental to Oracle's cost management architecture, enabling the system to track and report costs not just as a total, but decomposed into specific cost elements (like Material, Overhead, Resource) and cost levels (like This Level, Previous Level). This table is populated during cost processing and is essential for accurate inventory valuation, cost of goods sold (COGS) accounting, and detailed cost analysis.

Key Information Stored

The table's structure is designed to uniquely identify and store cost details for a specific transaction. Its primary key columns are TRANSACTION_ID, ORGANIZATION_ID, COST_ELEMENT_ID, and LEVEL_TYPE, ensuring a unique record for each cost element and level combination per transaction. Key columns include TRANSACTION_ID, which links to MTL_MATERIAL_TRANSACTIONS; COST_ELEMENT_ID, linking to CST_COST_ELEMENTS to identify the type of cost; and LEVEL_TYPE to distinguish between costs incurred at the current assembly level versus those rolled up from lower-level components. The table also holds INVENTORY_ITEM_ID and ORGANIZATION_ID (part of a foreign key to MTL_SYSTEM_ITEMS_B) to identify the item, along with columns to store the actual cost amounts, such as BASE_TRANSACTION_VALUE and ACTUAL_COST.

Common Use Cases and Queries

This table is central to any reporting or analysis requiring detailed cost insight. A primary use case is analyzing the cost composition of completed transactions, such as understanding the material versus overhead cost of a built assembly. It is also crucial for troubleshooting cost variances and reconciling inventory valuations. A typical analytical query joins this table to its related master data tables.

  • Sample Query - Cost Breakdown by Element for a Transaction:
    SELECT cce.COST_ELEMENT, mctcd.LEVEL_TYPE, mctcd.ACTUAL_COST
    FROM INV.MTL_CST_TXN_COST_DETAILS mctcd,
         CST.CST_COST_ELEMENTS cce
    WHERE mctcd.COST_ELEMENT_ID = cce.COST_ELEMENT_ID
    AND mctcd.TRANSACTION_ID = :p_transaction_id
    ORDER BY cce.COST_ELEMENT_ID, mctcd.LEVEL_TYPE;
  • Reporting Use Case: Generating a report showing the detailed cost build-up for all work order completions in a period, aggregated by item and cost element.

Related Objects

MTL_CST_TXN_COST_DETAILS has integral relationships with several key EBS tables, as defined by its foreign keys. The primary parent is MTL_MATERIAL_TRANSACTIONS, the master table for all inventory movements. It references CST_COST_ELEMENTS to obtain the meaning of the cost element ID. Its relationship with MTL_SYSTEM_ITEMS_B (via INVENTORY_ITEM_ID and ORGANIZATION_ID) links the cost detail to the item definition. This table is also a key source for various cost-related views and is heavily referenced by the Cost Management (CST) module's processes for closing and valuation.