XLA_SOURCES_VL

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name

ROW_ID APPLICATION_ID SOURCE_TYPE_CODE SOURCE_CODE NAME DESCRIPTION ENABLED_FLAG DATATYPE_CODE PLSQL_FUNCTION_NAME FLEX_VALUE_SET_ID VISIBLE_FLAG SUM_FLAG TRANSLATED_FLAG VIEW_APPLICATION_ID LOOKUP_TYPE KEY_FLEXFIELD_FLAG SEGMENT_CODE FLEXFIELD_APPLICATION_ID ID_FLEX_CODE SOURCE_COLUMN_NAME SOURCE_TABLE_NAME SOURCE_ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SPLIT_TRANSACTION_FLAG SUMMARIZATION_FLAG

Query

SQL_Statement

SELECT b.ROWID row_id, b.APPLICATION_ID application_id, b.SOURCE_TYPE_CODE source_type_code, b.SOURCE_CODE source_code, t.NAME name, t.DESCRIPTION description, b.ENABLED_FLAG enabled_flag, b.DATATYPE_CODE datatype_code, b.PLSQL_FUNCTION_NAME plsql_function_name, b.FLEX_VALUE_SET_ID flex_value_set_id, b.VISIBLE_FLAG visible_flag, b.SUM_FLAG sum_flag, b.TRANSLATED_FLAG translated_flag, b.VIEW_APPLICATION_ID view_application_id, b.LOOKUP_TYPE lookup_type, b.KEY_FLEXFIELD_FLAG key_flexfield_flag, b.SEGMENT_CODE segment_code, b.FLEXFIELD_APPLICATION_ID flexfield_application_id, b.ID_FLEX_CODE id_flex_code, b.SOURCE_COLUMN_NAME source_column_name, b.SOURCE_TABLE_NAME source_table_name, b.SOURCE_ID source_id, b.CREATION_DATE creation_date, b.CREATED_BY created_by, b.LAST_UPDATE_DATE last_update_date, b.LAST_UPDATED_BY last_updated_by, b.LAST_UPDATE_LOGIN last_update_login, b.OBJECT_VERSION_NUMBER object_version_number, b.SPLIT_TRANSACTION_FLAG split_transaction_flag, b.SUMMARIZATION_FLAG summarization_flag FROM XLA_SOURCES_TL t, XLA_SOURCES_B b WHERE b.APPLICATION_ID = t.APPLICATION_ID AND b.SOURCE_CODE = t.SOURCE_CODE AND b.SOURCE_TYPE_CODE = t.SOURCE_TYPE_CODE AND t.LANGUAGE = USERENV('LANG')