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_CATEGORY_ACCOUNTS

Product:	INV - Inventory
Description:	Asset and expense accounts by item category, by subinventory
Implementation/DBA Data:	INV.MTL_CATEGORY_ACCOUNTS

Primary Key: MTL_CATEGORY_ACCOUNTS_PK

ORGANIZATION_ID
CATEGORY_ID
COST_GROUP_ID
SUBINVENTORY_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_CATEGORY_ACCOUNTS	MTL_CATEGORIES_B	MTL_CATEGORY_ACCOUNTS.CATEGORY_ID
MTL_CATEGORY_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_CATEGORY_ACCOUNTS.ENCUMBRANCE_ACCOUNT
MTL_CATEGORY_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_CATEGORY_ACCOUNTS.BRIDGING_ACCOUNT
MTL_CATEGORY_ACCOUNTS	MTL_PARAMETERS	MTL_CATEGORY_ACCOUNTS.ORGANIZATION_ID
MTL_CATEGORY_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_CATEGORY_ACCOUNTS.MATERIAL_ACCOUNT
MTL_CATEGORY_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_CATEGORY_ACCOUNTS.MATERIAL_OVERHEAD_ACCOUNT
MTL_CATEGORY_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_CATEGORY_ACCOUNTS.RESOURCE_ACCOUNT
MTL_CATEGORY_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_CATEGORY_ACCOUNTS.OUTSIDE_PROCESSING_ACCOUNT
MTL_CATEGORY_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_CATEGORY_ACCOUNTS.OVERHEAD_ACCOUNT
MTL_CATEGORY_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_CATEGORY_ACCOUNTS.EXPENSE_ACCOUNT