eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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:	INV.MTL_PAC_ACTUAL_COST_DETAILS

Primary Key: MTL_PAC_ACTUAL_COST_DETAIL_PK

TRANSACTION_ID
PAC_PERIOD_ID
COST_GROUP_ID
COST_ELEMENT_ID
LEVEL_TYPE

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_PAC_ACTUAL_COST_DETAILS	CST_COST_GROUPS	MTL_PAC_ACTUAL_COST_DETAILS.COST_GROUP_ID
MTL_PAC_ACTUAL_COST_DETAILS	MTL_MATERIAL_TRANSACTIONS	MTL_PAC_ACTUAL_COST_DETAILS.TRANSACTION_ID
MTL_PAC_ACTUAL_COST_DETAILS	CST_PAC_PERIODS	MTL_PAC_ACTUAL_COST_DETAILS.PAC_PERIOD_ID
MTL_PAC_ACTUAL_COST_DETAILS	CST_COST_TYPES	MTL_PAC_ACTUAL_COST_DETAILS.COST_TYPE_ID
MTL_PAC_ACTUAL_COST_DETAILS	CST_COST_ELEMENTS	MTL_PAC_ACTUAL_COST_DETAILS.COST_ELEMENT_ID
MTL_PAC_ACTUAL_COST_DETAILS	CST_PAC_ITEM_COSTS	MTL_PAC_ACTUAL_COST_DETAILS.COST_LAYER_ID