IRC_CX_SITE_THEME_LINKS_VL

Details

• Schema: FUSION

• Object owner: IRC

• Object type: VIEW

Columns

Name
LINK_ID OBJECT_STATUS OBJECT_VERSION_NUMBER LINK_NUMBER PARENT_LINK_NUMBER VISIBLE_ON_MOBILE LINK_TYPE LINK_ORDER LINK_NAME THEME_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LINK_URL LINK_TEXT

Query

SQL_Statement

SELECT IRC_CX_SITE_THEME_LINKS_B.LINK_ID LINK_ID, IRC_CX_SITE_THEME_LINKS_B.OBJECT_STATUS, IRC_CX_SITE_THEME_LINKS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, IRC_CX_SITE_THEME_LINKS_B.LINK_NUMBER LINK_NUMBER, IRC_CX_SITE_THEME_LINKS_B.PARENT_LINK_NUMBER PARENT_LINK_NUMBER, IRC_CX_SITE_THEME_LINKS_B.VISIBLE_ON_MOBILE VISIBLE_ON_MOBILE, IRC_CX_SITE_THEME_LINKS_B.LINK_TYPE LINK_TYPE, IRC_CX_SITE_THEME_LINKS_B.LINK_ORDER LINK_ORDER, IRC_CX_SITE_THEME_LINKS_TL.LINK_NAME LINK_NAME, IRC_CX_SITE_THEME_LINKS_B.THEME_ID THEME_ID, IRC_CX_SITE_THEME_LINKS_B.CREATED_BY CREATED_BY, IRC_CX_SITE_THEME_LINKS_B.CREATION_DATE CREATION_DATE, IRC_CX_SITE_THEME_LINKS_B.LAST_UPDATED_BY LAST_UPDATED_BY, IRC_CX_SITE_THEME_LINKS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, IRC_CX_SITE_THEME_LINKS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, IRC_CX_SITE_THEME_LINKS_TL.LINK_URL LINK_URL, IRC_CX_SITE_THEME_LINKS_TL.LINK_TEXT LINK_TEXT FROM IRC_CX_SITE_THEME_LINKS_B, IRC_CX_SITE_THEME_LINKS_TL WHERE IRC_CX_SITE_THEME_LINKS_B.LINK_ID = IRC_CX_SITE_THEME_LINKS_TL.LINK_ID AND IRC_CX_SITE_THEME_LINKS_TL.LANGUAGE = USERENV('LANG')