DOO_ACTIVITIES_EFF_VL

Details

• Schema: FUSION

• Object owner: DOO

• Object type: VIEW

Columns

Name

EFF_LINE_ID OBJECT_VERSION_NUMBER ACTIVITY_ID TASK_INSTANCE_ID CONTEXT_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SOURCE_LANG LANGUAGE PROGRAM_NAME PROGRAM_APP_NAME ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR20

Query

SQL_Statement

SELECT EFF_LINE_ID EFF_LINE_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACTIVITY_ID ACTIVITY_ID, TASK_INSTANCE_ID TASK_INSTANCE_ID, CONTEXT_CODE CONTEXT_CODE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SOURCE_LANG SOURCE_LANG, LANGUAGE LANGUAGE, PROGRAM_NAME PROGRAM_NAME, PROGRAM_APP_NAME PROGRAM_APP_NAME, ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6, ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7, ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8, ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9, ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10, ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11, ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12, ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13, ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14, ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15, ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16, ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17, ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18, ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19, ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20 FROM DOO_ACTIVITIES_EFF_TL WHERE LANGUAGE = USERENV('LANG')