IRC_CX_SITE_BRANDS_VL

Details

• Schema: FUSION

• Object owner: IRC

• Object type: VIEW

Columns

Name
BRANDING_ID OBJECT_STATUS OBJECT_VERSION_NUMBER THEME_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CUSTOM_JS DEFAULT_JS CUSTOM_CSS DEFAULT_CSS FRONT_IMAGE_URL LOGO_IMAGE_URL MOBILE_FRONT_IMAGE_URL MOBILE_LOGO_IMAGE_URL NAVIGATION_HEADER_HTML NAVIGATION_FOOTER_HTML

Query

SQL_Statement

SELECT IRC_CX_SITE_BRANDS_B.BRANDING_ID, IRC_CX_SITE_BRANDS_B.OBJECT_STATUS, IRC_CX_SITE_BRANDS_B.OBJECT_VERSION_NUMBER, IRC_CX_SITE_BRANDS_B.THEME_ID, IRC_CX_SITE_BRANDS_B.CREATED_BY, IRC_CX_SITE_BRANDS_B.CREATION_DATE, IRC_CX_SITE_BRANDS_B.LAST_UPDATED_BY, IRC_CX_SITE_BRANDS_B.LAST_UPDATE_DATE, IRC_CX_SITE_BRANDS_B.LAST_UPDATE_LOGIN, IRC_CX_SITE_BRANDS_B.CUSTOM_JS, IRC_CX_SITE_BRANDS_B.DEFAULT_JS, IRC_CX_SITE_BRANDS_TL.CUSTOM_CSS, IRC_CX_SITE_BRANDS_TL.DEFAULT_CSS, IRC_CX_SITE_BRANDS_TL.FRONT_IMAGE_URL, IRC_CX_SITE_BRANDS_TL.LOGO_IMAGE_URL, IRC_CX_SITE_BRANDS_TL.MOBILE_FRONT_IMAGE_URL, IRC_CX_SITE_BRANDS_TL.MOBILE_LOGO_IMAGE_URL, IRC_CX_SITE_BRANDS_TL.NAVIGATION_HEADER_HTML, IRC_CX_SITE_BRANDS_TL.NAVIGATION_FOOTER_HTML FROM IRC_CX_SITE_BRANDS_B, IRC_CX_SITE_BRANDS_TL WHERE IRC_CX_SITE_BRANDS_B.BRANDING_ID = IRC_CX_SITE_BRANDS_TL.BRANDING_ID AND IRC_CX_SITE_BRANDS_TL.LANGUAGE = USERENV('LANG')