VIEW: APPS.BIV_MAINT_ASSET_CATEGORY_LVL_V

Source

View Text - Preformatted

SELECT to_char(a.CATEGORY_ID) ID, b.DESCRIPTION || ' (' || a.CONCATENATED_SEGMENTS || ')' VALUE 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 = 9 UNION ALL select '-1' id, fnd_message.get_string('BIS','BIS_UNASSIGNED') value from dual

View Text - HTML Formatted

SELECT TO_CHAR(A.CATEGORY_ID) ID
, B.DESCRIPTION || ' (' || A.CONCATENATED_SEGMENTS || ')' VALUE
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 = 9 UNION ALL SELECT '-1' ID
, FND_MESSAGE.GET_STRING('BIS'
, 'BIS_UNASSIGNED') VALUE
FROM DUAL