View: CLN_ITEMMST_ITEM_CAT_SETS_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View of the available item category sets
Implementation/DBA Data:	APPS.CLN_ITEMMST_ITEM_CAT_SETS_V

View Text

SELECT DISTINCT MCST.CATEGORY_SET_ID
, MCST.CATEGORY_SET_NAME
, MIC.ORGANIZATION_ID
FROM MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORY_SET_VALID_CATS MCSVC
, MTL_CATEGORIES_B MCB
, MTL_CATEGORY_SETS_B MCSB
, MTL_CATEGORY_SETS_TL MCST
WHERE MIC.CATEGORY_ID = MCSVC.CATEGORY_ID
AND MIC.CATEGORY_SET_ID = MCSVC.CATEGORY_SET_ID
AND MCSVC.CATEGORY_SET_ID = MCSB.CATEGORY_SET_ID
AND MCSB.CATEGORY_SET_ID = MCST.CATEGORY_SET_ID
AND MCST.LANGUAGE = USERENV('LANG')

Columns