IRC_CX_SITE_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_FLAG LINK_TYPE_CODE LINK_ORDER LINK_NAME SITE_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LINK_URL LINK_TEXT LINK_DESC LINK_ATTRIBUTE1 LINK_ATTRIBUTE2 LINK_ATTRIBUTE3

Query

SQL_Statement

SELECT IRC_CX_SITE_LINKS_B.LINK_ID LINK_ID, IRC_CX_SITE_LINKS_B.OBJECT_STATUS OBJECT_STATUS, IRC_CX_SITE_LINKS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, IRC_CX_SITE_LINKS_B.LINK_NUMBER LINK_NUMBER, IRC_CX_SITE_LINKS_B.PARENT_LINK_NUMBER PARENT_LINK_NUMBER, IRC_CX_SITE_LINKS_B.VISIBLE_ON_MOBILE_FLAG VISIBLE_ON_MOBILE_FLAG, IRC_CX_SITE_LINKS_B.LINK_TYPE_CODE LINK_TYPE_CODE, IRC_CX_SITE_LINKS_B.LINK_ORDER LINK_ORDER, IRC_CX_SITE_LINKS_TL.LINK_NAME LINK_NAME, IRC_CX_SITE_LINKS_B.SITE_NUMBER SITE_NUMBER, IRC_CX_SITE_LINKS_B.CREATED_BY CREATED_BY, IRC_CX_SITE_LINKS_B.CREATION_DATE CREATION_DATE, IRC_CX_SITE_LINKS_B.LAST_UPDATED_BY LAST_UPDATED_BY, IRC_CX_SITE_LINKS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, IRC_CX_SITE_LINKS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, IRC_CX_SITE_LINKS_TL.LINK_URL LINK_URL, IRC_CX_SITE_LINKS_TL.LINK_TEXT LINK_TEXT, IRC_CX_SITE_LINKS_TL.LINK_DESC LINK_DESC, IRC_CX_SITE_LINKS_TL.LINK_ATTRIBUTE1 LINK_ATTRIBUTE1, IRC_CX_SITE_LINKS_TL.LINK_ATTRIBUTE2 LINK_ATTRIBUTE2, IRC_CX_SITE_LINKS_TL.LINK_ATTRIBUTE3 LINK_ATTRIBUTE3 FROM IRC_CX_SITE_LINKS_B, IRC_CX_SITE_LINKS_TL WHERE IRC_CX_SITE_LINKS_B.LINK_ID = IRC_CX_SITE_LINKS_TL.LINK_ID AND IRC_CX_SITE_LINKS_TL.LANGUAGE = USERENV('LANG')