View: JTF_RS_ITEM_CATEGORIES_V

Product:	JTF - CRM Foundation
Description:	Stores all valid item categories for which resource skills can be assigned.
Implementation/DBA Data:	APPS.JTF_RS_ITEM_CATEGORIES_V

View Text

SELECT C.CATEGORY_ID
, C.CONCATENATED_SEGMENTS CATEGORY_NAME
, T.DESCRIPTION
, C.ENABLED_FLAG
, C.START_DATE_ACTIVE
, C.END_DATE_ACTIVE
, C.DISABLE_DATE
FROM MTL_CATEGORIES_KFV C
, MTL_CATEGORIES_TL T
WHERE T.CATEGORY_ID(+) = C.CATEGORY_ID
AND T.LANGUAGE(+) = USERENV('LANG')

Columns