EGO_GT_OBJ_SEARCH_VIEWS_VL

Details

• Schema: FUSION

• Object owner: EGO

• Object type: VIEW

Columns

Name
SEARCH_VIEW_ID STEP_ID NAME LABEL HINT OBJECT_CODE SEARCH_CONFIG CREATED_BY OBJECT_VERSION_NUMBER CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT EGO_GT_OBJ_SEARCH_VIEWS_B.SEARCH_VIEW_ID SEARCH_VIEW_ID, EGO_GT_OBJ_SEARCH_VIEWS_B.STEP_ID STEP_ID, EGO_GT_OBJ_SEARCH_VIEWS_TL.NAME NAME, EGO_GT_OBJ_SEARCH_VIEWS_TL.LABEL LABEL, EGO_GT_OBJ_SEARCH_VIEWS_TL.HINT HINT, EGO_GT_OBJ_SEARCH_VIEWS_B.OBJECT_CODE OBJECT_CODE, EGO_GT_OBJ_SEARCH_VIEWS_B.SEARCH_CONFIG SEARCH_CONFIG, EGO_GT_OBJ_SEARCH_VIEWS_B.CREATED_BY CREATED_BY, EGO_GT_OBJ_SEARCH_VIEWS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EGO_GT_OBJ_SEARCH_VIEWS_B.CREATION_DATE CREATION_DATE, EGO_GT_OBJ_SEARCH_VIEWS_B.LAST_UPDATED_BY LAST_UPDATED_BY, EGO_GT_OBJ_SEARCH_VIEWS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, EGO_GT_OBJ_SEARCH_VIEWS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM EGO_GT_OBJ_SEARCH_VIEWS_B, EGO_GT_OBJ_SEARCH_VIEWS_TL WHERE EGO_GT_OBJ_SEARCH_VIEWS_B.SEARCH_VIEW_ID = EGO_GT_OBJ_SEARCH_VIEWS_TL.SEARCH_VIEW_ID AND EGO_GT_OBJ_SEARCH_VIEWS_TL.LANGUAGE = USERENV('LANG')