VIEW: APPS.ENI_ITEM_INV_CAT_V

Source

View Text - Preformatted

SELECT a.CATEGORY_ID, b.DESCRIPTION || ' (' || a.CONCATENATED_SEGMENTS || ')' From MTL_CATEGORIES_KFV a, MTL_CATEGORIES_TL b, MTL_DEFAULT_CATEGORY_SETS c, MTL_CATEGORY_SETS d WHERE a.CATEGORY_ID = b.CATEGORY_ID And b.LANGUAGE = userenv('LANG') And a.STRUCTURE_ID = d.STRUCTURE_ID And c.CATEGORY_SET_ID = d.CATEGORY_SET_ID And c.FUNCTIONAL_AREA_ID = 1 union all select to_number(lookup_code), DESCRIPTION|| ' (' || meaning || ')' from fnd_lookup_values where lookup_type = 'ITEM_CATG' and lookup_code = '-1' and language = userenv('LANG') With read only

View Text - HTML Formatted

SELECT A.CATEGORY_ID
, B.DESCRIPTION || ' (' || A.CONCATENATED_SEGMENTS || ')'
FROM MTL_CATEGORIES_KFV A
, MTL_CATEGORIES_TL B
, MTL_DEFAULT_CATEGORY_SETS C
, MTL_CATEGORY_SETS D
WHERE A.CATEGORY_ID = B.CATEGORY_ID
AND B.LANGUAGE = USERENV('LANG')
AND A.STRUCTURE_ID = D.STRUCTURE_ID
AND C.CATEGORY_SET_ID = D.CATEGORY_SET_ID
AND C.FUNCTIONAL_AREA_ID = 1 UNION ALL SELECT TO_NUMBER(LOOKUP_CODE)
, DESCRIPTION|| ' (' || MEANING || ')'
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'ITEM_CATG'
AND LOOKUP_CODE = '-1'
AND LANGUAGE = USERENV('LANG') WITH READ ONLY