EGO_GT_STEPS_VL

Details

• Schema: FUSION

• Object owner: EGO

• Object type: VIEW

Columns

Name
STEP_ID NAME DESCRIPTION STEP_NUMBER GUIDED_TASK_ID STEP_TYPE_CODE OBJECT_CODE STEP_SEARCH_VIEW_IDS CREATED_BY OBJECT_VERSION_NUMBER CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT EGO_GT_STEPS_B.STEP_ID STEP_ID, EGO_GT_STEPS_TL.NAME NAME, EGO_GT_STEPS_TL.DESCRIPTION DESCRIPTION, EGO_GT_STEPS_B.STEP_NUMBER STEP_NUMBER, EGO_GT_STEPS_B.GUIDED_TASK_ID GUIDED_TASK_ID, EGO_GT_STEPS_B.STEP_TYPE_CODE STEP_TYPE_CODE, EGO_GT_STEPS_B.OBJECT_CODE OBJECT_CODE, EGO_GT_STEPS_B.STEP_SEARCH_VIEW_IDS STEP_SEARCH_VIEW_IDS, EGO_GT_STEPS_B.CREATED_BY CREATED_BY, EGO_GT_STEPS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EGO_GT_STEPS_B.CREATION_DATE CREATION_DATE, EGO_GT_STEPS_B.LAST_UPDATED_BY LAST_UPDATED_BY, EGO_GT_STEPS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, EGO_GT_STEPS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM EGO_GT_STEPS_B, EGO_GT_STEPS_TL WHERE EGO_GT_STEPS_B.STEP_ID = EGO_GT_STEPS_TL.STEP_ID AND EGO_GT_STEPS_TL.LANGUAGE = USERENV('LANG')