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_COST_SUBELEMENTS

Product:	INV - Inventory
Description:	Stores the material overhead sub-elements that are charged for a given transaction in a particular period.
Implementation/DBA Data:	INV.MTL_PAC_COST_SUBELEMENTS

Primary Key: MTL_PAC_COST_SUBELEMENTS_PK

TRANSACTION_ID
PAC_PERIOD_ID
COST_GROUP_ID
COST_ELEMENT_ID
LEVEL_TYPE
RESOURCE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_PAC_COST_SUBELEMENTS	CST_COST_GROUPS	MTL_PAC_COST_SUBELEMENTS.COST_GROUP_ID
MTL_PAC_COST_SUBELEMENTS	MTL_MATERIAL_TRANSACTIONS	MTL_PAC_COST_SUBELEMENTS.TRANSACTION_ID
MTL_PAC_COST_SUBELEMENTS	CST_PAC_PERIODS	MTL_PAC_COST_SUBELEMENTS.PAC_PERIOD_ID
MTL_PAC_COST_SUBELEMENTS	CST_COST_TYPES	MTL_PAC_COST_SUBELEMENTS.COST_TYPE_ID
MTL_PAC_COST_SUBELEMENTS	CST_COST_ELEMENTS	MTL_PAC_COST_SUBELEMENTS.COST_ELEMENT_ID
MTL_PAC_COST_SUBELEMENTS	BOM_RESOURCES	MTL_PAC_COST_SUBELEMENTS.RESOURCE_ID