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