[Home] [Help]
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
Name |
EVENT_CODE |
FROM_TO_STATUS |
INCIDENT_STATUS |
RELATIONSHIP_TYPE |
NAME |
DESCRIPTION |
LANGUAGE |
SOURCE_LANG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
WF_BUSINESS_EVENT_ID |
SEEDED_FLAG |
APPLICATION_ID |
OBJECT_VERSION_NUMBER |