CSE_CONDITION_EVENT_CODES_VL

Details

• Schema: FUSION

• Object owner: CSE

• Object type: VIEW

Columns

Name
CONDITION_EVENT_CODE_ID OBJECT_VERSION_NUMBER CONDITION_EVENT_TYPE_CODE CONDITION_EVENT_CODE CONDITION_EVENT_CODE_NAME CONDITION_EVENT_CODE_DESC CATEGORY_CODE SOURCE_REF_ID ACTIVE_END_DATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE

Query

SQL_Statement

SELECT CECB.CONDITION_EVENT_CODE_ID CONDITION_EVENT_CODE_ID, CECB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CECB.CONDITION_EVENT_TYPE_CODE CONDITION_EVENT_TYPE_CODE, CECB.CONDITION_EVENT_CODE CONDITION_EVENT_CODE, CECTL.CONDITION_EVENT_CODE_NAME CONDITION_EVENT_CODE_NAME, CECTL.CONDITION_EVENT_CODE_DESC CONDITION_EVENT_CODE_DESC, CECB.CATEGORY_CODE CATEGORY_CODE, CECB.SOURCE_REF_ID SOURCE_REF_ID, CECB.ACTIVE_END_DATE ACTIVE_END_DATE, CECB.CREATED_BY CREATED_BY, CECB.CREATION_DATE CREATION_DATE, CECB.LAST_UPDATED_BY LAST_UPDATED_BY, CECB.LAST_UPDATE_DATE LAST_UPDATE_DATE, CECB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CECB.REQUEST_ID REQUEST_ID, CECB.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, CECB.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE FROM CSE_CONDITION_EVENT_CODES_B CECB, CSE_CONDITION_EVENT_CODES_TL CECTL WHERE CECTL.CONDITION_EVENT_CODE_ID = CECB.CONDITION_EVENT_CODE_ID AND CECTL.LANGUAGE = USERENV('LANG')