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_SR_UWQ_GROUP_V

Object Details

Object Name:	CS_SR_UWQ_GROUP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_SR_UWQ_GROUP_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

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INCIDENT_ID	NUMBER	(15)	Yes	This is a unique internal identifier of the Service Request.
INCIDENT_NUMBER	VARCHAR2	(64)	Yes	This is a unique number that identifies a Service Request. This number is customizable and is transparent to the users.
SERVERITY	VARCHAR2	(90)	Yes	Severity Name from cs_incident_severities_tl table
STATUS	VARCHAR2	(90)	Yes	This field denotes the current status of Service Request. The status denotes if a Service Request is open, closed, resolved etc. .. This is customizable.
SUMMARY	VARCHAR2	(240)	Yes	The summary is a short note about the service request that is captured when the request was created.
PERSON_ORG	VARCHAR2	(360)		This field indicates the caller type for the service request. it can be a Person or organisation.
OWNER_ID	NUMBER	(15)		The Owner ID is a unique number that identifies the owner of the service request. This is internal to the system.
OWNER	VARCHAR2	(60)	Yes	This field indicates the name of the owner of the service request.
SR_TYPE	VARCHAR2	(90)	Yes	This field denotes the type of the service request, as specified in the table CS_INCIDENT_TYPES_B.
ESCALATED	VARCHAR2	(80)		This field specifies the level of escalation of the service request.
COVERAGE_NAME	VARCHAR2	(0)		This Indicates the name of the warranty under which the customer is registered.
COVERAGE_LEVEL	VARCHAR2	(0)		This is just a hard coded value. It has the value 'Level'. This is used for internal purposes.
INCIDENT_SEVERITY_ID	NUMBER	(15)	Yes	The Incident Severity ID is a unique number that identifies the severity of the service request. This is internal to the system.
INCIDENT_STATUS_ID	NUMBER	(15)	Yes	The Incident Status ID is a unique number that identifies the current status of the service request. This is internal to the system.
INCIDENT_TYPE_ID	NUMBER	(15)	Yes	The Incident Type ID is a unique number that identifies the service request type. This is internal to the system.
RESOURCE_TYPE	VARCHAR2	(30)		The resource type is the type of the resource allocated for this service request. This column will have only RS_GROUP as the resource.
RESOURCE_ID	NUMBER			The ID of the Group to which the SR has been assigned.
SEVERITY	VARCHAR2	(90)	Yes	This field denotes the severity of Service Request. A severity can be high, medium or low. This is customizable.
IEU_OBJECT_FUNCTION	VARCHAR2	(30)		The Object function for SR object code.
IEU_OBJECT_PARAMETERS	VARCHAR2	(2000)		The Object parameters for SR object code.
IEU_MEDIA_TYPE_UUID	VARCHAR2	(0)		The media universal unique ID. This column is not used. It is only for backward compatibility.
IEU_PARAM_PK_COL	CHAR	(11)		This field gives the primary key column for SR. "Incident_id".
IEU_PARAM_PK_VALUE	VARCHAR2	(40)		This field gives the value of the primary key column for SR. "Incident_id".
EXPECTED_RESOLUTION_DATE	DATE			The date when the SR is expected to be resolved.
OBLIGATION_DATE	DATE			The respond by date for the SR.
CREATION_DATE	DATE		Yes	The date when the SR was made.
CONTACT_NAME	VARCHAR2	(360)		The name of the primary contact at the customer site.
SORT_ORDER	NUMBER			The sorting order for status.
PRODUCT_NAME	VARCHAR2	(40)		The Product against which the SR has been created.
SR_CREATION_CHANNEL	VARCHAR2	(80)	Yes	The channel through which the SR was created.
MODIFIED_DATE	DATE		Yes	The last modified date.
MODIFIED_BY	VARCHAR2	(100)	Yes	The user name who last modified the record.
OWNER_NAME	VARCHAR2	(360)		Name of the individual owner.
EMAIL_ADDRESS	VARCHAR2	(2000)		The email of the contact.
CONTACT_ADDRESS	VARCHAR2	(1085)		The address of the contact.
CONTACT_COUNTRY	VARCHAR2	(60)		The country of the contact.
PROJECT_NUMBER	VARCHAR2	(120)		The project number.
CUSTOMER_TICKET_NUMBER	VARCHAR2	(50)		The Customer Ticket number.
CURRENT_SERIAL_NUMBER	VARCHAR2	(30)		The current serial number of the product.
PROBLEM_CODE	VARCHAR2	(50)		Problem Code
CUSTOMER_PO_NUMBER	VARCHAR2	(50)		Customer Purchase Order Number
RESOLUTION_CODE	VARCHAR2	(50)		Resolution Code
CONTACT_TYPE	VARCHAR2	(80)		Contact Type
SERIAL_NUMBER	VARCHAR2	(30)		Serial Number
CONTACT_NUMBER	VARCHAR2	(30)		Contact Number
TAG	VARCHAR2	(30)		External Reference Number
INCIDENT_COUNTRY	VARCHAR2	(60)		Incident Country for Service Request
CREATED_BY	VARCHAR2	(100)	Yes	Created By User Id.
LANGUAGE_CODE	VARCHAR2	(4)		Language Code
URGENCY	VARCHAR2	(90)		The urgency of the service request.
COVERAGE_TYPE	VARCHAR2	(80)		The coverage type of the service request.
IMPORTANCE_LEVEL	NUMBER			The importance level of the coverage type.

Query Text

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


SELECT INCIDENT_ID
,      INCIDENT_NUMBER
,      SERVERITY
,      STATUS
,      SUMMARY
,      PERSON_ORG
,      OWNER_ID
,      OWNER
,      SR_TYPE
,      ESCALATED
,      COVERAGE_NAME
,      COVERAGE_LEVEL
,      INCIDENT_SEVERITY_ID
,      INCIDENT_STATUS_ID
,      INCIDENT_TYPE_ID
,      RESOURCE_TYPE
,      RESOURCE_ID
,      SEVERITY
,      IEU_OBJECT_FUNCTION
,      IEU_OBJECT_PARAMETERS
,      IEU_MEDIA_TYPE_UUID
,      IEU_PARAM_PK_COL
,      IEU_PARAM_PK_VALUE
,      EXPECTED_RESOLUTION_DATE
,      OBLIGATION_DATE
,      CREATION_DATE
,      CONTACT_NAME
,      SORT_ORDER
,      PRODUCT_NAME
,      SR_CREATION_CHANNEL
,      MODIFIED_DATE
,      MODIFIED_BY
,      OWNER_NAME
,      EMAIL_ADDRESS
,      CONTACT_ADDRESS
,      CONTACT_COUNTRY
,      PROJECT_NUMBER
,      CUSTOMER_TICKET_NUMBER
,      CURRENT_SERIAL_NUMBER
,      PROBLEM_CODE
,      CUSTOMER_PO_NUMBER
,      RESOLUTION_CODE
,      CONTACT_TYPE
,      SERIAL_NUMBER
,      CONTACT_NUMBER
,      TAG
,      INCIDENT_COUNTRY
,      CREATED_BY
,      LANGUAGE_CODE
,      URGENCY
,      COVERAGE_TYPE
,      IMPORTANCE_LEVEL
FROM APPS.CS_SR_UWQ_GROUP_V;

Dependencies

[top of page]

APPS.CS_SR_UWQ_GROUP_V references the following:

APPS: CSI_ITEM_INSTANCES; CS_HZ_SR_CONTACT_POINTS; CS_INCIDENTS_ALL_TL; CS_INCIDENTS_B_SEC; CS_INCIDENT_SEVERITIES_TL; CS_INCIDENT_STATUSES_B; CS_INCIDENT_STATUSES_TL; CS_INCIDENT_TYPES_TL; CS_INCIDENT_URGENCIES_TL; CS_LOOKUPS; FND_GLOBAL - show dependent code; FND_LOOKUP_VALUES; FND_USER; HR_LOCATIONS_ALL; HZ_PARTIES; JTF_OBJECTS_B; JTF_RS_GROUPS_TL; JTF_RS_RESOURCE_EXTNS_TL; JTF_TASKS_B; JTF_TASK_REFERENCES_B; MTL_SYSTEM_ITEMS_KFV; OKS_COV_TYPES_B; OKS_COV_TYPES_TL; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F

APPS.CS_SR_UWQ_GROUP_V is not referenced by any database object