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_V

Object Details

Object Name:	CS_SR_UWQ_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_SR_UWQ_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	Comments
INCIDENT_ID	NUMBER	(15)	This is a unique internal identifier of the Service Request.
INCIDENT_NUMBER	VARCHAR2	(64)	This is a unique number that identifies a Service Request. This number is customizable and is transparent to the users.
SERVERITY	VARCHAR2	(90)	This field denotes the severity of Service Request. But there is a spelling mistake in the cloumn name. Hence using this column is not recommended.
STATUS	VARCHAR2	(90)	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)	The summary is a short note about the service reques,t 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		The Owner ID is a unique number that identifies the owner of the service request. This is internal to the system.
OWNER	VARCHAR2	(360)	This field indicates the name of the owner of the service request.
SR_TYPE	VARCHAR2	(90)	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)	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)	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)	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. Types can be an employee, team or group.
RESOURCE_ID	NUMBER		The Resource ID is a unique number that identifies the resource to whomf the service request is assigned. This is internal to the system.
SEVERITY	VARCHAR2	(90)	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		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 order of the status flow.
PRODUCT_NAME	VARCHAR2	(40)	The Product against which the SR has been created.
SR_CREATION_CHANNEL	VARCHAR2	(80)	The channel through which the SR was created.
MODIFIED_DATE	DATE		The last modified date.
MODIFIED_BY	VARCHAR2	(100)	The user name who last modified the record.
OWNER_NAME	VARCHAR2	(0)	Name of the group owner. In this view this will be null.
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
CONTACT_NUMBER	VARCHAR2	(30)	Contact Number
SERIAL_NUMBER	VARCHAR2	(30)	Serial Number
TAG	VARCHAR2	(30)	External Reference
INCIDENT_COUNTRY	VARCHAR2	(60)	Incident Country
CREATED_BY	VARCHAR2	(100)	Created By User Id
LANGUAGE_CODE	VARCHAR2	(4)	Language Code

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
,      CONTACT_NUMBER
,      SERIAL_NUMBER
,      TAG
,      INCIDENT_COUNTRY
,      CREATED_BY
,      LANGUAGE_CODE
FROM APPS.CS_SR_UWQ_V;

Dependencies

[top of page]

APPS.CS_SR_UWQ_V references the following:

APPS: CSI_ITEM_INSTANCES; CS_HZ_SR_CONTACT_POINTS; CS_INCIDENTS_ALL_B; CS_INCIDENTS_ALL_TL; CS_INCIDENT_SEVERITIES_TL; CS_INCIDENT_STATUSES_B; CS_INCIDENT_STATUSES_TL; CS_INCIDENT_TYPES_TL; CS_LOOKUPS; FND_GLOBAL - show dependent code; FND_LOOKUP_VALUES; FND_USER; HZ_PARTIES; JTF_OBJECTS_B; JTF_RS_GROUPS_TL; JTF_RS_RESOURCE_EXTNS_TL; JTF_RS_TEAMS_TL; JTF_TASKS_B; JTF_TASK_REFERENCES_B; MTL_SYSTEM_ITEMS_KFV; PER_ADDRESSES; PER_ALL_PEOPLE_F

APPS.CS_SR_UWQ_V is not referenced by any database object