1. Tables and Views for Financials
  2. XLE_HISTORY_COLUMNS_VL

XLE_HISTORY_COLUMNS_VL

Details

  • Schema: FUSION

  • Object owner: XLE

  • Object type: VIEW

Columns

Name

ROW_ID

HISTORY_COLUMN_ID

SOURCE_TABLE

SOURCE_COLUMN_NAME

GEOGRAPHY_ID

LAST_UPDATED_BY

CREATION_DATE

LAST_UPDATE_LOGIN

LAST_UPDATE_DATE

CREATED_BY

SOURCE_COLUMN_PROMPT

Query

SQL_Statement

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