DBA Data[Home] [Help]

VIEW: APPS.ICX_POR_DESCRIPTORS_VL

Source

View Text - Preformatted

SELECT t.rowid, t.RT_DESCRIPTOR_ID, t.descriptor_name, t.description, t.RT_CATEGORY_ID, t.TYPE, t.SEQUENCE, t.source_lang, t.language, t.KEY, t.TITLE, t.defaultvalue, t.multi_value_type, t.multi_value_key, t.required, t.refinable, t.searchable, t.CREATED_BY, t.CREATION_DATE, t.LAST_UPDATED_BY, t.last_update_date, t.last_update_login from icx_por_descriptors_tl t WHERE t. language = USERENV('LANG')
View Text - HTML Formatted

SELECT T.ROWID
, T.RT_DESCRIPTOR_ID
, T.DESCRIPTOR_NAME
, T.DESCRIPTION
, T.RT_CATEGORY_ID
, T.TYPE
, T.SEQUENCE
, T.SOURCE_LANG
, T.LANGUAGE
, T.KEY
, T.TITLE
, T.DEFAULTVALUE
, T.MULTI_VALUE_TYPE
, T.MULTI_VALUE_KEY
, T.REQUIRED
, T.REFINABLE
, T.SEARCHABLE
, T.CREATED_BY
, T.CREATION_DATE
, T.LAST_UPDATED_BY
, T.LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN
FROM ICX_POR_DESCRIPTORS_TL T
WHERE T. LANGUAGE = USERENV('LANG')