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_ITEM_CATEGORIES

Product:	INV - Inventory
Description:	Define item assignments to categories
Implementation/DBA Data:	INV.MTL_ITEM_CATEGORIES

Primary Key: MTL_ITEM_CATEGORIES_PK

INVENTORY_ITEM_ID
ORGANIZATION_ID
CATEGORY_SET_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_ITEM_CATEGORIES	MTL_SYSTEM_ITEMS_B	MTL_ITEM_CATEGORIES.INVENTORY_ITEM_ID MTL_ITEM_CATEGORIES.ORGANIZATION_ID
MTL_ITEM_CATEGORIES	MTL_CATEGORY_SET_VALID_CATS	MTL_ITEM_CATEGORIES.CATEGORY_SET_ID MTL_ITEM_CATEGORIES.CATEGORY_ID
MTL_ITEM_CATEGORIES	MTL_PARAMETERS	MTL_ITEM_CATEGORIES.ORGANIZATION_ID
AMS_ACT_PRODUCTS	MTL_ITEM_CATEGORIES	AMS_ACT_PRODUCTS.INVENTORY_ITEM_ID AMS_ACT_PRODUCTS.ORGANIZATION_ID AMS_ACT_PRODUCTS.CATEGORY_SET_ID
MRP_SR_ASSIGNMENTS	MTL_ITEM_CATEGORIES	MRP_SR_ASSIGNMENTS.INVENTORY_ITEM_ID MRP_SR_ASSIGNMENTS.ORGANIZATION_ID MRP_SR_ASSIGNMENTS.CATEGORY_SET_ID
OKL_FE_EO_TERM_OBJECTS	MTL_ITEM_CATEGORIES	OKL_FE_EO_TERM_OBJECTS.INVENTORY_ITEM_ID OKL_FE_EO_TERM_OBJECTS.ORGANIZATION_ID OKL_FE_EO_TERM_OBJECTS.CATEGORY_SET_ID
OKL_FE_ITEM_RESIDUAL_ALL	MTL_ITEM_CATEGORIES	OKL_FE_ITEM_RESIDUAL_ALL.INVENTORY_ITEM_ID OKL_FE_ITEM_RESIDUAL_ALL.ORGANIZATION_ID OKL_FE_ITEM_RESIDUAL_ALL.CATEGORY_SET_ID
OKL_FE_RESI_CAT_OBJECTS	MTL_ITEM_CATEGORIES	OKL_FE_RESI_CAT_OBJECTS.INVENTORY_ITEM_ID OKL_FE_RESI_CAT_OBJECTS.ORGANIZATION_ID OKL_FE_RESI_CAT_OBJECTS.CATEGORY_SET_ID