[Home] [Help]
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
Name |
ACTION_CODE |
NOTIFICATION_TEMPLATE_NAME |
NEW_STATUS |
RELATIONSHIP_TYPE |
NEW_RESOLUTION_CODE |
NAME |
DESCRIPTION |
LANGUAGE |
SOURCE_LANG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
SEEDED_FLAG |
APPLICATION_ID |
OBJECT_VERSION_NUMBER |