FUN_DATA_SLICES_VL

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: VIEW

Columns

Name

ROW_ID

DATA_SLICE_ID

DATA_SLICE_CODE

DATA_SLICE_NAME

DESCRIPTION

LANGUAGE

SOURCE_LANG

DATA_SOURCE_OBJECT_TYPE

DATA_SOURCE_OBJECT_ID

ENABLED_FLAG

ATTRIBUTE_LIST

DERIVED_ATTRIBUTE_LIST

FILTER_CRITERIA

EXTRACT_QUERY

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

OBJECT_VERSION_NUMBER

Query

SQL_Statement

select

b.ROWID ROW_ID,

b.DATA_SLICE_ID,

b.DATA_SLICE_CODE,

tl.DATA_SLICE_NAME,

tl.DESCRIPTION,

tl.LANGUAGE,

tl.SOURCE_LANG,

b.DATA_SOURCE_OBJECT_TYPE,

b.DATA_SOURCE_OBJECT_ID,

b.ENABLED_FLAG,

b.ATTRIBUTE_LIST,

b.DERIVED_ATTRIBUTE_LIST,

b.FILTER_CRITERIA,

b.EXTRACT_QUERY,

b.CREATION_DATE,

b.CREATED_BY,

b.LAST_UPDATE_DATE,

b.LAST_UPDATE_LOGIN,

b.LAST_UPDATED_BY,

b.OBJECT_VERSION_NUMBER

from fun_data_slices_b b,

fun_data_slices_tl tl

where tl.language = userenv('lang')

and b.data_slice_id = tl.data_slice_id