eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CS_INCIDENT_TYPES_RG_V

Object Details

Object Name:	CS_INCIDENT_TYPES_RG_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_INCIDENT_TYPES_RG_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INCIDENT_TYPE_ID	NUMBER	(15)	Yes	Type unique identifier
NAME	VARCHAR2	(90)	Yes	Type name
INCIDENT_SUBTYPE	VARCHAR2	(30)	Yes	For 11i, it will always be 'INC'. Identifies that the type is a service request
DESCRIPTION	VARCHAR2	(720)		Type description
PARENT_INCIDENT_TYPE_ID	NUMBER	(15)		Not Used
START_DATE_ACTIVE	DATE			Date this type becomes active, if limited
END_DATE_ACTIVE	DATE			Date this type becomes inactive, if limited
WORKFLOW	VARCHAR2	(30)		Name of the workflow process associated with this type
WEIGHT	NUMBER			Not Used
TASK_WORKFLOW	VARCHAR2	(30)		Not Used
TASK_WORKFLOW_DISPLAY_NAME	VARCHAR2	(4000)		Not Used
DISPLAY_NAME	VARCHAR2	(4000)		Process Display Name of Workflow associated with this type
WEB_WORKFLOW	VARCHAR2	(30)		Not Used
WEB_DISPLAY_NAME	VARCHAR2	(4000)		Not Used
RELATED_STATUSES_CNT	NUMBER			A Total number of statuses related to this type
STATUS_GROUP_ID	NUMBER			Status group identifier.
MAINTENANCE_FLAG	VARCHAR2	(3)		Flag indicates if the service request type is of EAM type.
CMRO_FLAG	VARCHAR2	(3)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INCIDENT_TYPE_ID
,      NAME
,      INCIDENT_SUBTYPE
,      DESCRIPTION
,      PARENT_INCIDENT_TYPE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      WORKFLOW
,      WEIGHT
,      TASK_WORKFLOW
,      TASK_WORKFLOW_DISPLAY_NAME
,      DISPLAY_NAME
,      WEB_WORKFLOW
,      WEB_DISPLAY_NAME
,      RELATED_STATUSES_CNT
,      STATUS_GROUP_ID
,      MAINTENANCE_FLAG
,      CMRO_FLAG
FROM APPS.CS_INCIDENT_TYPES_RG_V;

Dependencies

[top of page]

APPS.CS_INCIDENT_TYPES_RG_V references the following:

APPS: CS_INCIDENT_TYPES_VL; CS_SR_UTIL_PKG - show dependent code; CS_WORKFLOW_PKG - show dependent code

APPS.CS_INCIDENT_TYPES_RG_V is not referenced by any database object