DBA Data[Home] [Help]

VIEW: APPS.XTR_SYS_LANGUAGES_VL

Source

View Text - Preformatted

SELECT T.MODULE_NAME, T.CANVAS_TYPE, T.ITEM_NAME, B.ORIGINAL_TEXT, T.TEXT, T.CREATED_BY, T.CREATION_DATE, T.LAST_UPDATED_BY, T.LAST_UPDATE_DATE, T.LAST_UPDATE_LOGIN FROM XTR_SYS_LANGUAGES_TL T, XTR_SYS_LANGUAGES B WHERE B.MODULE_NAME = T.MODULE_NAME AND B.CANVAS_TYPE = T.CANVAS_TYPE AND B.ITEM_NAME = T.ITEM_NAME AND T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT T.MODULE_NAME
, T.CANVAS_TYPE
, T.ITEM_NAME
, B.ORIGINAL_TEXT
, T.TEXT
, T.CREATED_BY
, T.CREATION_DATE
, T.LAST_UPDATED_BY
, T.LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN
FROM XTR_SYS_LANGUAGES_TL T
, XTR_SYS_LANGUAGES B
WHERE B.MODULE_NAME = T.MODULE_NAME
AND B.CANVAS_TYPE = T.CANVAS_TYPE
AND B.ITEM_NAME = T.ITEM_NAME
AND T.LANGUAGE = USERENV('LANG')