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: ViewCS.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 Mandatory 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:

SchemaAPPS
SynonymCSI_ITEM_INSTANCES
SynonymCS_HZ_SR_CONTACT_POINTS
SynonymCS_INCIDENTS_ALL_B
SynonymCS_INCIDENTS_ALL_TL
SynonymCS_INCIDENT_SEVERITIES_TL
SynonymCS_INCIDENT_STATUSES_B
SynonymCS_INCIDENT_STATUSES_TL
SynonymCS_INCIDENT_TYPES_TL
ViewCS_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_LOOKUP_VALUES
SynonymFND_USER
SynonymHZ_PARTIES
SynonymJTF_OBJECTS_B
SynonymJTF_RS_GROUPS_TL
SynonymJTF_RS_RESOURCE_EXTNS_TL
SynonymJTF_RS_TEAMS_TL
SynonymJTF_TASKS_B
SynonymJTF_TASK_REFERENCES_B
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymPER_ADDRESSES
SynonymPER_ALL_PEOPLE_F

APPS.CS_SR_UWQ_V is not referenced by any database object