IRC_CX_WIDGETS_VL

Details

• Schema: FUSION

• Object owner: IRC

• Object type: VIEW

Columns

Name
WIDGET_ID THEME_ID WIDGET_TYPE_CODE WIDGET_TEXT WIDGET_ENABLED_FLAG OBJECT_STATUS OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LANGUAGE SOURCE_LANG WIDGET_NAME WIDGET_ICON_URL

Query

SQL_Statement

SELECT B.WIDGET_ID WIDGET_ID, B.THEME_ID THEME_ID, B.WIDGET_TYPE_CODE WIDGET_TYPE_CODE, B.WIDGET_TEXT WIDGET_TEXT, B.WIDGET_ENABLED_FLAG WIDGET_ENABLED_FLAG, B.OBJECT_STATUS OBJECT_STATUS, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TL.LANGUAGE LANGUAGE, TL.SOURCE_LANG SOURCE_LANG, TL.WIDGET_NAME WIDGET_NAME, TL.WIDGET_ICON_URL WIDGET_ICON_URL FROM IRC_CX_WIDGETS_B B, IRC_CX_WIDGETS_TL TL WHERE B.WIDGET_ID = TL.WIDGET_ID AND TL.LANGUAGE = USERENV('LANG')