IRC_REC_EVENTS_VL

Details

• Schema: FUSION

• Object owner: IRC

• Object type: VIEW

Columns

Name

EVENT_ID APPLIED_METRICS_DAYS HIRED_METRICS_DAYS OBJECT_STATUS EVENT_NUMBER BUSINESS_UNIT_ID EVENT_CREATION_MODE EVENT_NAME EVENT_OWNER_ID EVENT_CATEGORY_CODE EVENT_DESCRIPTION OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN PHASE_CODE APPLY_FLOW_ID EVENT_DESC_HTML EVENT_SHORT_DESC EVENT_LAST_REG_DATE EVENT_VISIBILITY_CODE PUBLISH_STATUS_CODE PUBLISH_START_DATE PUBLISH_END_DATE PUBLISH_TIMEZONE_CODE EVENT_PURPOSE EVENT_START_DATE EVENT_END_DATE HRT_POOL_ID EVENT_TIMEZONE_CODE MAX_REG_COUNT ENABLE_INTERVIEW_FLAG MANUAL_REGN_CONFIRM_FLAG POOL_MEM_PROC_TEMPLATE_ID

Query

SQL_Statement

SELECT B.EVENT_ID, B.APPLIED_METRICS_DAYS, B.HIRED_METRICS_DAYS, B.OBJECT_STATUS, B.EVENT_NUMBER, B.BUSINESS_UNIT_ID, B.EVENT_CREATION_MODE, TL.EVENT_NAME, B.EVENT_OWNER_ID, B.EVENT_CATEGORY_CODE, TL.EVENT_DESCRIPTION, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.PHASE_CODE, B.APPLY_FLOW_ID, TL.EVENT_DESC_HTML, TL.EVENT_SHORT_DESC, B.EVENT_LAST_REG_DATE, B.EVENT_VISIBILITY_CODE, B.PUBLISH_STATUS_CODE, B.PUBLISH_START_DATE, B.PUBLISH_END_DATE, B.PUBLISH_TIMEZONE_CODE, TL.EVENT_PURPOSE, B.EVENT_START_DATE, B.EVENT_END_DATE, B.HRT_POOL_ID, B.EVENT_TIMEZONE_CODE, B.MAX_REG_COUNT, B.ENABLE_INTERVIEW_FLAG, B.MANUAL_REGN_CONFIRM_FLAG, B.POOL_MEM_PROC_TEMPLATE_ID FROM IRC_REC_EVENTS_B B, IRC_REC_EVENTS_TL TL WHERE B.EVENT_ID = TL.EVENT_ID AND TL.LANGUAGE = USERENV('LANG')