[Home] [Help]
View: XLE_HISTORY_COLUMNS_VL
View Text
SELECT B.ROWID ROW_ID
,
B.HISTORY_COLUMN_ID
,
B.SOURCE_TABLE
,
B.SOURCE_COLUMN_NAME
,
B.GEOGRAPHY_ID
,
B.LAST_UPDATED_BY
,
B.CREATION_DATE
,
B.LAST_UPDATE_LOGIN
,
B.LAST_UPDATE_DATE
,
B.CREATED_BY
,
T.SOURCE_COLUMN_PROMPT
FROM XLE_HISTORY_COLUMNS_B B
,
XLE_HISTORY_COLUMNS_TL T
WHERE B.HISTORY_COLUMN_ID = T.HISTORY_COLUMN_ID
AND T.LANGUAGE = USERENV('LANG')