IRC_CX_SITES

Details

Schema: FUSION
Object owner: IRC
Object type: VIEW

Columns

Name
SITE_ID OBJECT_STATUS OBJECT_VERSION_NUMBER SITE_CODE SITE_NUMBER ACTIVE_THEME_ID DEFAULT_LANG SITE_NAME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SEQUENCE_NUMBER STATUS_CODE EMAIL_TEMPLATE_ID SITE_TYPE EVENTS_ENABLED_FLAG OG_IMAGE_SRC SITE_URL_NAME SEO_ORGANIZATION_NAME SEO_ORGANIZATION_SAME_AS SEO_ORGANIZATION_LOGO SEO_DESCRIPTION SEO_KEYWORDS

Name

SITE_ID

OBJECT_STATUS

OBJECT_VERSION_NUMBER

SITE_CODE

SITE_NUMBER

ACTIVE_THEME_ID

DEFAULT_LANG

SITE_NAME

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SEQUENCE_NUMBER

STATUS_CODE

EMAIL_TEMPLATE_ID

SITE_TYPE

EVENTS_ENABLED_FLAG

OG_IMAGE_SRC

SITE_URL_NAME

SEO_ORGANIZATION_NAME

SEO_ORGANIZATION_SAME_AS

SEO_ORGANIZATION_LOGO

SEO_DESCRIPTION

SEO_KEYWORDS

Query

SQL_Statement
SELECT B.SITE_ID SITE_ID, B.OBJECT_STATUS, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.SITE_CODE SITE_CODE, B.SITE_NUMBER SITE_NUMBER, B.ACTIVE_THEME_ID ACTIVE_THEME_ID, B.DEFAULT_LANG, TL.SITE_NAME SITE_NAME, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.SEQUENCE_NUMBER, B.STATUS_CODE, B.EMAIL_TEMPLATE_ID, B.SITE_TYPE, B.EVENTS_ENABLED_FLAG, TL.OG_IMAGE_SRC, B.SITE_URL_NAME, TL.SEO_ORGANIZATION_NAME SEO_ORGANIZATION_NAME, TL.SEO_ORGANIZATION_SAME_AS SEO_ORGANIZATION_SAME_AS, TL.SEO_ORGANIZATION_LOGO SEO_ORGANIZATION_LOGO, TL.SEO_DESCRIPTION SEO_DESCRIPTION, TL.SEO_KEYWORDS SEO_KEYWORDS FROM IRC_CX_SITES_B B, IRC_CX_SITES_TL TL WHERE B.SITE_ID = TL.SITE_ID AND TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.SITE_ID SITE_ID,

B.OBJECT_STATUS,

B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

B.SITE_CODE SITE_CODE,

B.SITE_NUMBER SITE_NUMBER,

B.ACTIVE_THEME_ID ACTIVE_THEME_ID,

B.DEFAULT_LANG,

TL.SITE_NAME SITE_NAME,

B.CREATED_BY CREATED_BY,

B.CREATION_DATE CREATION_DATE,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

B.SEQUENCE_NUMBER,

B.STATUS_CODE,

B.EMAIL_TEMPLATE_ID,

B.SITE_TYPE,

B.EVENTS_ENABLED_FLAG,

TL.OG_IMAGE_SRC,

B.SITE_URL_NAME,

TL.SEO_ORGANIZATION_NAME SEO_ORGANIZATION_NAME,

TL.SEO_ORGANIZATION_SAME_AS SEO_ORGANIZATION_SAME_AS,

TL.SEO_ORGANIZATION_LOGO SEO_ORGANIZATION_LOGO,

TL.SEO_DESCRIPTION SEO_DESCRIPTION,

TL.SEO_KEYWORDS SEO_KEYWORDS

FROM

IRC_CX_SITES_B B,

IRC_CX_SITES_TL TL

WHERE

B.SITE_ID = TL.SITE_ID AND TL.LANGUAGE = USERENV('LANG')