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


VIEW: APPS.CS_SR_UWQ_TEAM_V

Object Details
Object Name: CS_SR_UWQ_TEAM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_UWQ_TEAM_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 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) 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 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 (15)
The Owner ID is a unique number that identifies the owner of the service request. This is internal to the system.
OWNER VARCHAR2 (30) 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_TEAM as the resource.
RESOURCE_ID NUMBER

The ID of the Team 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
CONTACT_NUMBER VARCHAR2 (30)
Contact Number
SERIAL_NUMBER VARCHAR2 (30)
Serial Number
TAG VARCHAR2 (30)
External Reference Number
INCIDENT_COUNTRY VARCHAR2 (60)
Incident Country for the 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
,      CONTACT_NUMBER
,      SERIAL_NUMBER
,      TAG
,      INCIDENT_COUNTRY
,      CREATED_BY
,      LANGUAGE_CODE
,      URGENCY
,      COVERAGE_TYPE
,      IMPORTANCE_LEVEL
FROM APPS.CS_SR_UWQ_TEAM_V;

Dependencies

[top of page]

APPS.CS_SR_UWQ_TEAM_V references the following:

SchemaAPPS
SynonymCSI_ITEM_INSTANCES
SynonymCS_HZ_SR_CONTACT_POINTS
SynonymCS_INCIDENTS_ALL_TL
SynonymCS_INCIDENTS_B_SEC
SynonymCS_INCIDENT_SEVERITIES_TL
SynonymCS_INCIDENT_STATUSES_B
SynonymCS_INCIDENT_STATUSES_TL
SynonymCS_INCIDENT_TYPES_TL
SynonymCS_INCIDENT_URGENCIES_TL
ViewCS_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_LOOKUP_VALUES
SynonymFND_USER
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHZ_PARTIES
SynonymJTF_OBJECTS_B
SynonymJTF_RS_RESOURCE_EXTNS_TL
SynonymJTF_RS_TEAMS_TL
SynonymJTF_TASKS_B
SynonymJTF_TASK_REFERENCES_B
SynonymMTL_SYSTEM_ITEMS_KFV
ViewOKS_COV_TYPES_V
SynonymPER_ALL_PEOPLE_F
ViewPER_ASSIGNMENTS_X

APPS.CS_SR_UWQ_TEAM_V is not referenced by any database object