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_LABEL_V

Object Details

Object Name:	CS_SR_UWQ_LABEL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_SR_UWQ_LABEL_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	VARCHAR2	(0)	The incident identifier.
INCIDENT_NUMBER	VARCHAR2	(0)	The Incident number.
SERVERITY	VARCHAR2	(0)	The severity of the Incident.
STATUS	VARCHAR2	(0)	The status of the Incident.
SUMMARY	VARCHAR2	(0)	The summary of the service request.
PERSON_ORG	VARCHAR2	(0)	This field indicates the caller type for the service request. it can be a Person or organisation.
OWNER_ID	VARCHAR2	(0)	The Owner ID is a unique number that identifies the owner of the service request. This is internal to the system.
OWNER	VARCHAR2	(0)	The owner of the service request.
SR_TYPE	VARCHAR2	(0)	This field denotes the type of the service request, as specified in the table CS_INCIDENT_TYPES_B.
ESCALATED	VARCHAR2	(0)	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	VARCHAR2	(0)	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	VARCHAR2	(0)	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	VARCHAR2	(0)	The Incident Type ID is a unique number that identifies the service request type.. This is internal to the system.
RESOURCE_TYPE	VARCHAR2	(0)	The resource type is the type of the resource allocated for this service request.
RESOURCE_ID	VARCHAR2	(0)	The ID of the Group to which the SR has been assigned.
SEVERITY	VARCHAR2	(0)	The severity of the Incident.
IEU_OBJECT_FUNCTION	VARCHAR2	(0)	The Object function for SR object code.
IEU_OBJECT_PARAMETERS	VARCHAR2	(0)	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	VARCHAR2	(0)	This field gives the primary key column for SR. "Incident_id".
IEU_PARAM_PK_VALUE	VARCHAR2	(0)	This field gives the value of the primary key column for SR. "Incident_id".
EXPECTED_RESOLUTION_DATE	VARCHAR2	(0)	The date when the SR is expected to be resolved.
OBLIGATION_DATE	VARCHAR2	(0)	The respond by date for the SR.
CREATION_DATE	VARCHAR2	(0)	The creation date for the SR.
CONTACT_NAME	VARCHAR2	(0)	The name of the primary contact at the customer site.
SORT_ORDER	VARCHAR2	(0)	The sorting order for status.
PRODUCT_NAME	VARCHAR2	(0)	The Product against which the SR has been created.
SR_CREATION_CHANNEL	VARCHAR2	(0)	The channel through which the SR was created.
MODIFIED_DATE	VARCHAR2	(0)	The last modified date.
MODIFIED_BY	VARCHAR2	(0)	The user name who last modified the record.
OWNER_NAME	VARCHAR2	(0)	Name of the individual owner.
EMAIL_ADDRESS	VARCHAR2	(0)	The email of the contact.
CONTACT_ADDRESS	VARCHAR2	(0)	The address of the contact.
CONTACT_COUNTRY	VARCHAR2	(0)	The country of the contact.
PROJECT_NUMBER	VARCHAR2	(0)	The project number.
CUSTOMER_TICKET_NUMBER	VARCHAR2	(0)	The Customer Ticket number.
CURRENT_SERIAL_NUMBER	VARCHAR2	(0)	The current serial number of the product.
CONTACT_NUMBER	VARCHAR2	(0)
INCIDENT_COUNTRY	VARCHAR2	(0)
PROBLEM_CODE	VARCHAR2	(0)
CONTACT_TYPE	VARCHAR2	(0)
LANGUAGE_CODE	VARCHAR2	(0)
CREATED_BY	VARCHAR2	(0)
CUSTOMER_PO_NUMBER	VARCHAR2	(0)
RESOLUTION_CODE	VARCHAR2	(0)
SERIAL_NUMBER	VARCHAR2	(0)
TAG	VARCHAR2	(0)

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
,      CONTACT_NUMBER
,      INCIDENT_COUNTRY
,      PROBLEM_CODE
,      CONTACT_TYPE
,      LANGUAGE_CODE
,      CREATED_BY
,      CUSTOMER_PO_NUMBER
,      RESOLUTION_CODE
,      SERIAL_NUMBER
,      TAG
FROM APPS.CS_SR_UWQ_LABEL_V;

Dependencies

[top of page]

APPS.CS_SR_UWQ_LABEL_V references the following:

PUBLIC: DUAL

APPS.CS_SR_UWQ_LABEL_V is not referenced by any database object