View: CSS_DEF_REPORTING_CATS_VL

View Text

SELECT A.CATEGORY_ID
, B.CONCATENATED_SEGMENTS CATEGORY_NUMBER
, C.DESCRIPTION CATEGORY_DESCRIPTION
FROM MTL_CATEGORY_SET_VALID_CATS A
, MTL_CATEGORIES_B_KFV B
, MTL_CATEGORIES_TL C
WHERE A.CATEGORY_SET_ID = (SELECT CSS_DEF_MTL_API.GET_PROD_REPORTING_CAT_SET_ID
FROM DUAL)
AND A.CATEGORY_ID = B.CATEGORY_ID
AND A.CATEGORY_ID = C.CATEGORY_ID
AND C.LANGUAGE = USERENV('LANG')

Columns