VIEW: APPS.CS_INCIDENT_TYPES_RG_V_SEC

Source

View Text - Preformatted

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

View Text - HTML Formatted

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