PSC_COM_CC_EVENTS_VL

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name
EVENT_ID EVENT_TYPE FILTER_EXPRESSIONS RUN_EXPRESSION SCHEDULED_REQUEST_ID SCHEDULED_START SCHEDULED_END ENABLED_FLAG RESOURCE_ID EVENT_CODE EVENT_NAME EVENT_DESCRIPTION LANGUAGE SOURCE_LANG SEED_DATA_LOCK DELETED_FLAG MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER AGENCY_ID EM_ENABLED EVENT_RUN_TYPE

Query

SQL_Statement

SELECT b.EVENT_ID EVENT_ID, b.EVENT_TYPE EVENT_TYPE, b.FILTER_EXPRESSIONS FILTER_EXPRESSIONS, b.RUN_EXPRESSION RUN_EXPRESSION, b.SCHEDULED_REQUEST_ID SCHEDULED_REQUEST_ID, b.SCHEDULED_START SCHEDULED_START, b.SCHEDULED_END SCHEDULED_END, b.ENABLED_FLAG ENABLED_FLAG, b.RESOURCE_ID RESOURCE_ID, b.EVENT_CODE EVENT_CODE, tl.EVENT_NAME EVENT_NAME, tl.EVENT_DESCRIPTION EVENT_DESCRIPTION, tl.LANGUAGE LANGUAGE, tl.SOURCE_LANG SOURCE_LANG, b.SEED_DATA_LOCK SEED_DATA_LOCK, b.DELETED_FLAG DELETED_FLAG, b.MODULE_ID MODULE_ID, 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.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, b.AGENCY_ID AGENCY_ID, b.EM_ENABLED EM_ENABLED, b.EVENT_RUN_TYPE FROM PSC_COM_CC_EVENTS_B b, PSC_COM_CC_EVENTS_TL tl WHERE b.EVENT_ID = tl.EVENT_ID AND tl.LANGUAGE = USERENV('LANG')