View: CS_SR_STATUS_GROUPS_VL

Product:	CS - Service
Description:	This view contains information about the Service request Status rules. Based on the CS_STATUS_GROUPS_B and CS_STATUS_GROUPS_TL tables.
Implementation/DBA Data:	APPS.CS_SR_STATUS_GROUPS_VL

View Text

SELECT A.ROWID ROW_ID
, A.STATUS_GROUP_ID
, A.DEFAULT_INCIDENT_STATUS_ID
, B.GROUP_NAME
, B.DESCRIPTION
, A.TRANSITION_IND
, A.START_DATE
, A.END_DATE
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.SECURITY_GROUP_ID
, B.LANGUAGE
, A.ORIG_SYSTEM_REFERENCE_ID
, A.OBJECT_VERSION_NUMBER
, B.SOURCE_LANG
FROM CS_SR_STATUS_GROUPS_B A
, CS_SR_STATUS_GROUPS_TL B
WHERE A.STATUS_GROUP_ID = B.STATUS_GROUP_ID
AND B.LANGUAGE = USERENV ('LANG')

Columns