View: EDW_ITEMS_CATEGORY_FKV

Product:	ENG - Engineering
Description:	This view holds the item category assignment information
Implementation/DBA Data:	APPS.EDW_ITEMS_CATEGORY_FKV

View Text

SELECT MIC.INVENTORY_ITEM_ID
, MIC.ORGANIZATION_ID
, SETS.CONTROL_LEVEL
, SETS.CATEGORY_SET_NAME
, MIC.CATEGORY_ID
FROM MTL_CATEGORIES CAT
, MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORY_SETS SETS
WHERE CAT.CATEGORY_ID = MIC.CATEGORY_ID
AND MIC.CATEGORY_SET_ID = SETS.CATEGORY_SET_ID

Columns