IRC_CX_TC_SIGNUP_VL

Details

• Schema: FUSION

• Object owner: IRC

• Object type: VIEW

Columns

Name
SITE_ID OBJECT_VERSION_NUMBER SHOW_AT_SEARCH_FLAG SHOW_WHEN_NO_RESULTS_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_STATUS TITLE DESCRIPTION BUTTON_LABEL

Query

SQL_Statement

SELECT IRC_CX_TC_SIGNUP_B.SITE_ID, IRC_CX_TC_SIGNUP_B.OBJECT_VERSION_NUMBER, IRC_CX_TC_SIGNUP_B.SHOW_AT_SEARCH_FLAG, IRC_CX_TC_SIGNUP_B.SHOW_WHEN_NO_RESULTS_FLAG, IRC_CX_TC_SIGNUP_B.CREATED_BY, IRC_CX_TC_SIGNUP_B.CREATION_DATE, IRC_CX_TC_SIGNUP_B.LAST_UPDATED_BY, IRC_CX_TC_SIGNUP_B.LAST_UPDATE_DATE, IRC_CX_TC_SIGNUP_B.LAST_UPDATE_LOGIN, IRC_CX_TC_SIGNUP_B.OBJECT_STATUS, IRC_CX_TC_SIGNUP_TL.TITLE, IRC_CX_TC_SIGNUP_TL.DESCRIPTION, IRC_CX_TC_SIGNUP_TL.BUTTON_LABEL FROM IRC_CX_TC_SIGNUP_B, IRC_CX_TC_SIGNUP_TL WHERE IRC_CX_TC_SIGNUP_B.SITE_ID = IRC_CX_TC_SIGNUP_TL.SITE_ID AND IRC_CX_TC_SIGNUP_TL.LANGUAGE = USERENV('LANG')