EGO_GT_GUIDED_TASKS_VL

Details

• Schema: FUSION

• Object owner: EGO

• Object type: VIEW

Columns

Name
GUIDED_TASK_ID NAME DESCRIPTION VISIBILITY OBJECT_CODE STATUS IMAGE GLOBAL_CONTEXT CREATED_BY OBJECT_VERSION_NUMBER CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT EGO_GT_GUIDED_TASKS_B.GUIDED_TASK_ID GUIDED_TASK_ID, EGO_GT_GUIDED_TASKS_TL.NAME NAME, EGO_GT_GUIDED_TASKS_TL.DESCRIPTION DESCRIPTION, EGO_GT_GUIDED_TASKS_B.VISIBILITY VISIBILITY, EGO_GT_GUIDED_TASKS_B.OBJECT_CODE OBJECT_CODE, EGO_GT_GUIDED_TASKS_B.STATUS STATUS, EGO_GT_GUIDED_TASKS_B.IMAGE IMAGE, EGO_GT_GUIDED_TASKS_B.GLOBAL_CONTEXT GLOBAL_CONTEXT, EGO_GT_GUIDED_TASKS_B.CREATED_BY CREATED_BY, EGO_GT_GUIDED_TASKS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EGO_GT_GUIDED_TASKS_B.CREATION_DATE CREATION_DATE, EGO_GT_GUIDED_TASKS_B.LAST_UPDATED_BY LAST_UPDATED_BY, EGO_GT_GUIDED_TASKS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, EGO_GT_GUIDED_TASKS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM EGO_GT_GUIDED_TASKS_B, EGO_GT_GUIDED_TASKS_TL WHERE EGO_GT_GUIDED_TASKS_B.GUIDED_TASK_ID = EGO_GT_GUIDED_TASKS_TL.GUIDED_TASK_ID AND EGO_GT_GUIDED_TASKS_TL.LANGUAGE = USERENV('LANG')