FND Design Data [Home] [Help]

Table: MTL_CST_ACTUAL_COST_DETAILS

Product: INV - Inventory
Description: Actual cost information by element and by level
Implementation/DBA Data: TableINV.MTL_CST_ACTUAL_COST_DETAILS
Primary Key: MTL_CST_ACTUAL_COST_DETAILS_PK
  1. ColumnLAYER_ID
  2. ColumnTRANSACTION_ID
  3. ColumnORGANIZATION_ID
  4. ColumnCOST_ELEMENT_ID
  5. ColumnLEVEL_TYPE
  6. ColumnTRANSACTION_ACTION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_CST_ACTUAL_COST_DETAILS FK Joins to TableMTL_MATERIAL_TRANSACTIONS MTL_CST_ACTUAL_COST_DETAILS.TRANSACTION_ID
MTL_CST_ACTUAL_COST_DETAILS FK Joins to TableCST_COST_ELEMENTS MTL_CST_ACTUAL_COST_DETAILS.COST_ELEMENT_ID
MTL_CST_ACTUAL_COST_DETAILS FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_CST_ACTUAL_COST_DETAILS.INVENTORY_ITEM_ID
MTL_CST_ACTUAL_COST_DETAILS.ORGANIZATION_ID