FUN_ADM_ATTRIBUTES_VL

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
ROW_ID ATTRIBUTE_CODE NAME DESCRIPTION ATTRIBUTE_GROUP_CODE ATTRIBUTE_ID CODE_COMBINATION_ID CREATED_BY CREATION_DATE DATATYPE_CODE FLEXFIELD_APPLICATION_ID ID_FLEX_CODE KEY_FLEXFIELD_FLAG LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LOOKUP_TYPE_CODE OBJECT_VERSION_NUMBER SEGMENT_CODE VALUE_SET_CODE VIEW_APPLICATION_ID

Query

SQL_Statement

SELECT b.ROWID row_id, b.ATTRIBUTE_CODE attribute_code, t.NAME name, t.DESCRIPTION description, b.ATTRIBUTE_GROUP_CODE attribute_group_code, b.ATTRIBUTE_ID attribute_id, b.CODE_COMBINATION_ID code_combination_id, b.CREATED_BY created_by, b.CREATION_DATE creation_date, b.DATATYPE_CODE datatype_code, b.FLEXFIELD_APPLICATION_ID flexfield_application_id, b.ID_FLEX_CODE id_flex_code, b.KEY_FLEXFIELD_FLAG key_flexfield_flag, b.LAST_UPDATED_BY last_updated_by, b.LAST_UPDATE_DATE last_update_date, b.LAST_UPDATE_LOGIN last_update_login, b.LOOKUP_TYPE_CODE lookup_type_code, b.OBJECT_VERSION_NUMBER object_version_number, b.SEGMENT_CODE segment_code, b.VALUE_SET_CODE value_set_code, b.VIEW_APPLICATION_ID view_application_id FROM FUN_ADM_ATTRIBUTES_TL t, FUN_ADM_ATTRIBUTES_B b WHERE b.ATTRIBUTE_CODE = t.ATTRIBUTE_CODE AND t.LANGUAGE = USERENV('LANG')