VIEW: APPS.JTF_RS_ITEM_CATEGORIES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')