FUN_DATA_SLICE_COLLECTION_VL

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
ROW_ID DATA_SLICE_COLLECTION_ID DATA_SLICE_COLLECTION_CODE DATA_SLICE_COLLECTION_NAME DESCRIPTION LANGUAGE SOURCE_LANG ENABLED_FLAG ATTRIBUTE_LIST COLLECTION_ITEM_LOOKUP_TYPE COLLECTION_ITEM_CAT_LKP_TYPE APPLICATION_ID MODULE_ID CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

select b.ROWID ROW_ID, b.DATA_SLICE_COLLECTION_ID, b.DATA_SLICE_COLLECTION_CODE, tl.DATA_SLICE_COLLECTION_NAME, tl.DESCRIPTION, tl.LANGUAGE, tl.SOURCE_LANG, b.ENABLED_FLAG, b.ATTRIBUTE_LIST, b.COLLECTION_ITEM_LOOKUP_TYPE, b.COLLECTION_ITEM_CAT_LKP_TYPE, b.APPLICATION_ID, b.MODULE_ID, b.CREATION_DATE, b.CREATED_BY, b.LAST_UPDATED_BY , b.LAST_UPDATE_DATE , b.LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER from fun_data_slice_collection_b b, fun_data_slice_collection_tl tl where tl.language = userenv('lang') and b.data_slice_collection_id = tl.data_slice_collection_id