IRC_EMP_EVENTS

Details

Schema: FUSION
Object owner: IRC
Object type: VIEW

Columns

Name
EMP_EVENT_ID EVENT_NUMBER START_DATE END_DATE LAST_REGISTER_DATE TIMEZONE_CODE STATUS_CODE STATUS_UPDATED_DATE VISIBILITY_CODE CREATION_CODE EVENT_LAST_MODIFIED_DATE OBJECT_STATUS OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN BANNER_IMAGE_URL NAME DESCRIPTION

Name

EMP_EVENT_ID

EVENT_NUMBER

START_DATE

END_DATE

LAST_REGISTER_DATE

TIMEZONE_CODE

STATUS_CODE

STATUS_UPDATED_DATE

VISIBILITY_CODE

CREATION_CODE

EVENT_LAST_MODIFIED_DATE

OBJECT_STATUS

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

BANNER_IMAGE_URL

NAME

DESCRIPTION

Query

SQL_Statement
SELECT B.EMP_EVENT_ID, B.EVENT_NUMBER, B.START_DATE , B.END_DATE, B.LAST_REGISTER_DATE, B.TIMEZONE_CODE, B.STATUS_CODE, B.STATUS_UPDATED_DATE, B.VISIBILITY_CODE, B.CREATION_CODE, B.EVENT_LAST_MODIFIED_DATE, B.OBJECT_STATUS, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.BANNER_IMAGE_URL, TL.NAME, TL.DESCRIPTION FROM IRC_EMP_EVENTS_B B, IRC_EMP_EVENTS_TL TL WHERE B.EMP_EVENT_ID = TL.EMP_EVENT_ID AND TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.EMP_EVENT_ID,

B.EVENT_NUMBER,

B.START_DATE ,

B.END_DATE,

B.LAST_REGISTER_DATE,

B.TIMEZONE_CODE,

B.STATUS_CODE,

B.STATUS_UPDATED_DATE,

B.VISIBILITY_CODE,

B.CREATION_CODE,

B.EVENT_LAST_MODIFIED_DATE,

B.OBJECT_STATUS,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.BANNER_IMAGE_URL,

TL.NAME,

TL.DESCRIPTION

FROM

IRC_EMP_EVENTS_B B,

IRC_EMP_EVENTS_TL TL

WHERE

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