IRC_CX_PAGES_VL

Details

• Schema: FUSION

• Object owner: IRC

• Object type: VIEW

Columns

Name
PAGE_ID ELEMENT_ID SITE_NUMBER PAGE_CODE PAGE_URL_NAME STATUS_CODE ELEMENT_TYPE PUBLISHED_DATE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE TITLE SEO_DESCRIPTION OG_IMAGE_SRC OG_DESCRIPTION VERSION TYPE TEMPLATE_ID HEADER_ID SEO_KEYWORDS

Query

SQL_Statement

SELECT IRC_CX_PAGES_B.PAGE_ID, IRC_CX_PAGES_B.ELEMENT_ID, IRC_CX_PAGES_B.SITE_NUMBER, IRC_CX_PAGES_B.PAGE_CODE, IRC_CX_PAGES_B.PAGE_URL_NAME, IRC_CX_PAGES_B.STATUS_CODE, IRC_CX_PAGES_B.ELEMENT_TYPE, IRC_CX_PAGES_B.PUBLISHED_DATE, IRC_CX_PAGES_B.OBJECT_VERSION_NUMBER, IRC_CX_PAGES_B.CREATED_BY, IRC_CX_PAGES_B.CREATION_DATE, IRC_CX_PAGES_B.LAST_UPDATED_BY, IRC_CX_PAGES_B.LAST_UPDATE_LOGIN, IRC_CX_PAGES_B.LAST_UPDATE_DATE, IRC_CX_PAGES_TL.TITLE, IRC_CX_PAGES_TL.SEO_DESCRIPTION, IRC_CX_PAGES_TL.OG_IMAGE_SRC, IRC_CX_PAGES_TL.OG_DESCRIPTION, IRC_CX_PAGES_B.VERSION, IRC_CX_PAGES_B.TYPE, IRC_CX_PAGES_B.TEMPLATE_ID, IRC_CX_PAGES_B.HEADER_ID, IRC_CX_PAGES_TL.SEO_KEYWORDS FROM IRC_CX_PAGES_B, IRC_CX_PAGES_TL WHERE IRC_CX_PAGES_B.PAGE_ID = IRC_CX_PAGES_TL.PAGE_ID AND IRC_CX_PAGES_TL.LANGUAGE = USERENV('LANG')