[Home] [Help]
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
Name |
CATEGORY_ID |
CATEGORY_NAME |
DESCRIPTION |
ENABLED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
DISABLE_DATE |