FUN_WF_ATTRIBUTES_VL

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
ROW_ID ATTRIBUTE_ID WF_OBJECT_ID ATTRIBUTE_CODE ATTRIBUTE_DISPLAY_NAME ATTRIBUTE_TYPE_CODE LOOKUP_QUERY DIMENSION CURRENCY_CONV_ALLOWED_FLAG OPTIONAL_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SEED_DATA_SOURCE

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.ATTRIBUTE_ID, B.WF_OBJECT_ID, B.ATTRIBUTE_CODE, TL.ATTRIBUTE_DISPLAY_NAME, B.ATTRIBUTE_TYPE_CODE, B.LOOKUP_QUERY, B.DIMENSION, B.CURRENCY_CONV_ALLOWED_FLAG, B.OPTIONAL_FLAG, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.SEED_DATA_SOURCE FROM FUN_WF_ATTRIBUTES_TL TL, FUN_WF_ATTRIBUTES_B B WHERE TL.ATTRIBUTE_ID = B.ATTRIBUTE_ID AND TL.LANGUAGE = userenv('LANG')