View: CS_SR_ACTION_CODES_VL

Product:	CS - Service
Description:	View for all action defnitions. The view is based off cs_sr_action_codes_b and tl.
Implementation/DBA Data:	APPS.CS_SR_ACTION_CODES_VL

View Text

SELECT B.ACTION_CODE
, B.NOTIFICATION_TEMPLATE_NAME
, B.NEW_STATUS
, B.RELATIONSHIP_TYPE
, B.NEW_RESOLUTION_CODE
, T.NAME
, T.DESCRIPTION
, T.LANGUAGE
, T.SOURCE_LANG
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.SEEDED_FLAG
, B.APPLICATION_ID
, B.OBJECT_VERSION_NUMBER FROM CS_SR_ACTION_CODES_B B
, CS_SR_ACTION_CODES_TL T
WHERE B.ACTION_CODE = T.ACTION_CODE AND T.LANGUAGE = USERENV('LANG')

Columns