View: CLN_PROCAT_ITEMCATEGORY_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View of the available currencies the price list can be converted into
Implementation/DBA Data:	APPS.CLN_PROCAT_ITEMCATEGORY_V

View Text

SELECT MIC.INVENTORY_ITEM_ID
, MIC.ORGANIZATION_ID
, MIC.CATEGORY_ID
, MC.CATEGORY_CONCAT_SEGS CATEGORY_NAME
, MCT.DESCRIPTION CATEGORY_DESCRIPTION
FROM MTL_DEFAULT_CATEGORY_SETS MDC
, MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORIES_V MC
, MTL_CATEGORY_SETS_B MCSB
, MTL_CATEGORIES_TL MCT
WHERE MDC.FUNCTIONAL_AREA_ID = 7
AND MIC.CATEGORY_SET_ID = MDC.CATEGORY_SET_ID
AND MIC.CATEGORY_SET_ID = MCSB.CATEGORY_SET_ID
AND MIC.CATEGORY_ID = MC.CATEGORY_ID
AND MC.STRUCTURE_ID = MCSB.STRUCTURE_ID
AND MIC.CATEGORY_ID = MCT.CATEGORY_ID
AND MCT.LANGUAGE = USERENV('LANG')

Columns