VIEW: APPS.CLN_INV_CATEGORY_V

Source

View Text - Preformatted

SELECT DISTINCT MIC.ORGANIZATION_ID , MIC.CATEGORY_ID , MCT.DESCRIPTION , MC.CONCATENATED_SEGMENTS FROM MTL_ITEM_CATEGORIES MIC , MTL_CATEGORIES_B_KFV MC , MTL_CATEGORIES_TL MCT WHERE MCT.CATEGORY_ID = MC.CATEGORY_ID AND MIC.CATEGORY_ID = MC.CATEGORY_ID AND MCT.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT DISTINCT MIC.ORGANIZATION_ID
, MIC.CATEGORY_ID
, MCT.DESCRIPTION
, MC.CONCATENATED_SEGMENTS
FROM MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORIES_B_KFV MC
, MTL_CATEGORIES_TL MCT
WHERE MCT.CATEGORY_ID = MC.CATEGORY_ID
AND MIC.CATEGORY_ID = MC.CATEGORY_ID
AND MCT.LANGUAGE = USERENV('LANG')