FND Design Data [Home] [Help]

Table: MTL_PAC_ACTUAL_COST_DETAILS

Product: INV - Inventory
Description: Stores the elemental cost for a given transaction in a period
Implementation/DBA Data: TableINV.MTL_PAC_ACTUAL_COST_DETAILS
Primary Key: MTL_PAC_ACTUAL_COST_DETAIL_PK
  1. ColumnTRANSACTION_ID
  2. ColumnPAC_PERIOD_ID
  3. ColumnCOST_GROUP_ID
  4. ColumnCOST_ELEMENT_ID
  5. ColumnLEVEL_TYPE
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_PAC_ACTUAL_COST_DETAILS FK Joins to TableCST_COST_GROUPS MTL_PAC_ACTUAL_COST_DETAILS.COST_GROUP_ID
MTL_PAC_ACTUAL_COST_DETAILS FK Joins to TableMTL_MATERIAL_TRANSACTIONS MTL_PAC_ACTUAL_COST_DETAILS.TRANSACTION_ID
MTL_PAC_ACTUAL_COST_DETAILS FK Joins to TableCST_PAC_PERIODS MTL_PAC_ACTUAL_COST_DETAILS.PAC_PERIOD_ID
MTL_PAC_ACTUAL_COST_DETAILS FK Joins to TableCST_COST_TYPES MTL_PAC_ACTUAL_COST_DETAILS.COST_TYPE_ID
MTL_PAC_ACTUAL_COST_DETAILS FK Joins to TableCST_COST_ELEMENTS MTL_PAC_ACTUAL_COST_DETAILS.COST_ELEMENT_ID
MTL_PAC_ACTUAL_COST_DETAILS FK Joins to TableCST_PAC_ITEM_COSTS MTL_PAC_ACTUAL_COST_DETAILS.COST_LAYER_ID