View: CS_INCIDENT_TYPES_RG_V_SEC

Product:	CS - Service
Description:	Returns service request types for an LOV on main service request form.
Implementation/DBA Data:	APPS.CS_INCIDENT_TYPES_RG_V_SEC

View Text

SELECT TYPE.INCIDENT_TYPE_ID
, TYPE.NAME
, TYPE.INCIDENT_SUBTYPE
, TYPE.DESCRIPTION
, TYPE.PARENT_INCIDENT_TYPE_ID
, TYPE.START_DATE_ACTIVE
, TYPE.END_DATE_ACTIVE
, TYPE.WORKFLOW
, TYPE.WEIGHT
, TYPE.TASK_WORKFLOW
, CS_WORKFLOW_PKG.GET_WORKFLOW_DISP_NAME('CSTASK'
, TYPE.TASK_WORKFLOW) TASK_WORKFLOW_DISPLAY_NAME
, CS_WORKFLOW_PKG.GET_WORKFLOW_DISP_NAME(DECODE(TYPE.INCIDENT_SUBTYPE
, 'ACT'
, 'SRACTION'
, 'SERVEREQ')
, TYPE.WORKFLOW) DISPLAY_NAME
, TYPE.WEB_WORKFLOW
, CS_WORKFLOW_PKG.GET_WORKFLOW_DISP_NAME('SERVEREQ'
, TYPE.WEB_WORKFLOW ) WEB_DISPLAY_NAME
, CS_SR_UTIL_PKG.GET_RELATED_STATUSES_CNT(TYPE.INCIDENT_TYPE_ID) RELATED_STATUSES_CNT
, TYPE.STATUS_GROUP_ID
, TYPE.MAINTENANCE_FLAG
, TYPE.CMRO_FLAG
FROM CS_INCIDENT_TYPES_VL_SEC TYPE

Columns