EGO_GT_INSTANCES_VL

Details

• Schema: FUSION

• Object owner: EGO

• Object type: VIEW

Columns

Name
INSTANCE_ID GUIDED_TASK_ID NAME DESCRIPTION REQUEST_ID STATUS METADATA TASK_CONFIG_METADATA CREATED_BY OBJECT_VERSION_NUMBER CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT EGO_GT_INSTANCES_B.INSTANCE_ID INSTANCE_ID, EGO_GT_INSTANCES_B.GUIDED_TASK_ID GUIDED_TASK_ID, EGO_GT_INSTANCES_TL.NAME NAME, EGO_GT_INSTANCES_TL.DESCRIPTION DESCRIPTION, EGO_GT_INSTANCES_B.REQUEST_ID REQUEST_ID, EGO_GT_INSTANCES_B.STATUS STATUS, EGO_GT_INSTANCES_B.METADATA METADATA, EGO_GT_INSTANCES_B.TASK_CONFIG_METADATA TASK_CONFIG_METADATA, EGO_GT_INSTANCES_B.CREATED_BY CREATED_BY, EGO_GT_INSTANCES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EGO_GT_INSTANCES_B.CREATION_DATE CREATION_DATE, EGO_GT_INSTANCES_B.LAST_UPDATED_BY LAST_UPDATED_BY, EGO_GT_INSTANCES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, EGO_GT_INSTANCES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM EGO_GT_INSTANCES_B, EGO_GT_INSTANCES_TL WHERE EGO_GT_INSTANCES_B.INSTANCE_ID = EGO_GT_INSTANCES_TL.INSTANCE_ID AND EGO_GT_INSTANCES_TL.LANGUAGE = USERENV('LANG')