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_FISCAL_CAT_ACCOUNTS

Product:	INV - Inventory
Description:	Category account definitions for legal entity
Implementation/DBA Data:	INV.MTL_FISCAL_CAT_ACCOUNTS

Primary Key: MTL_FISCAL_CAT_ACCOUNTS_PK

LEGAL_ENTITY_ID
COST_TYPE_ID
COST_GROUP_ID
CATEGORY_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_FISCAL_CAT_ACCOUNTS	HR_ALL_ORGANIZATION_UNITS	MTL_FISCAL_CAT_ACCOUNTS.LEGAL_ENTITY_ID
MTL_FISCAL_CAT_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_FISCAL_CAT_ACCOUNTS.EXPENSE_ACCOUNT
MTL_FISCAL_CAT_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_FISCAL_CAT_ACCOUNTS.BRIDGING_ACCOUNT
MTL_FISCAL_CAT_ACCOUNTS	CST_COST_TYPES	MTL_FISCAL_CAT_ACCOUNTS.COST_TYPE_ID
MTL_FISCAL_CAT_ACCOUNTS	CST_COST_GROUPS	MTL_FISCAL_CAT_ACCOUNTS.COST_GROUP_ID
MTL_FISCAL_CAT_ACCOUNTS	MTL_CATEGORIES_B	MTL_FISCAL_CAT_ACCOUNTS.CATEGORY_ID
MTL_FISCAL_CAT_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_FISCAL_CAT_ACCOUNTS.MATERIAL_ACCOUNT
MTL_FISCAL_CAT_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_FISCAL_CAT_ACCOUNTS.MATERIAL_OVERHEAD_ACCOUNT
MTL_FISCAL_CAT_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_FISCAL_CAT_ACCOUNTS.RESOURCE_ACCOUNT
MTL_FISCAL_CAT_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_FISCAL_CAT_ACCOUNTS.OVERHEAD_ACCOUNT
MTL_FISCAL_CAT_ACCOUNTS	GL_CODE_COMBINATIONS	MTL_FISCAL_CAT_ACCOUNTS.OUTSIDE_PROCESSING_ACCOUNT