DBA Data[Home] [Help]

VIEW: APPS.ICX_POR_CATEGORIES_VL

Source

View Text - Preformatted

SELECT t.ROWID, t.RT_CATEGORY_ID, t.source_lang, t.language, t.category_name, t.description, t.title, t.type, t.key, t.created_by, t.creation_date, t.last_updated_by, t.last_update_date, t.last_update_login from icx_cat_categories_tl t WHERE t.language = USERENV('LANG')
View Text - HTML Formatted

SELECT T.ROWID
, T.RT_CATEGORY_ID
, T.SOURCE_LANG
, T.LANGUAGE
, T.CATEGORY_NAME
, T.DESCRIPTION
, T.TITLE
, T.TYPE
, T.KEY
, T.CREATED_BY
, T.CREATION_DATE
, T.LAST_UPDATED_BY
, T.LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN
FROM ICX_CAT_CATEGORIES_TL T
WHERE T.LANGUAGE = USERENV('LANG')