View: CS_SR_EVENT_CODES_VL

Product:	CS - Service
Description:	View for all event defnitions. View is based on cs_sr_event_codes_b and tl.
Implementation/DBA Data:	APPS.CS_SR_EVENT_CODES_VL

View Text

SELECT A.EVENT_CODE
, A.FROM_TO_STATUS
, A.INCIDENT_STATUS
, A.RELATIONSHIP_TYPE
, B.NAME
, B.DESCRIPTION
, B.LANGUAGE
, B.SOURCE_LANG
, A.START_DATE_ACTIVE
, A.END_DATE_ACTIVE
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.WF_BUSINESS_EVENT_ID
, A.SEEDED_FLAG
, A.APPLICATION_ID
, A.OBJECT_VERSION_NUMBER FROM CS_SR_EVENT_CODES_B A
, CS_SR_EVENT_CODES_TL B
WHERE A.EVENT_CODE = B.EVENT_CODE
AND B.LANGUAGE = USERENV('LANG')

Columns