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

VIEW: APPS.CS_INCIDENTS_V

Object Details
Object Name: CS_INCIDENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_INCIDENTS_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
ROW_ID ROWID (10)
Rowid from the base table
INCIDENT_ID NUMBER (15) Yes Service request identifier
ORG_ID NUMBER

Operating unit identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column - with the user id from FND_USER
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column - with the user id from FND_USER
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
INCIDENT_NUMBER VARCHAR2 (64) Yes Service request number
INCIDENT_NUMBER_N VARCHAR2 (64) Yes Service request number stored a number
INCIDENT_STATUS_ID NUMBER (15) Yes Identifier for service request status
INCIDENT_TYPE_ID NUMBER (15) Yes Identifier for service request type
INCIDENT_URGENCY_ID NUMBER (15)
Identifier for service request urgency
INCIDENT_SEVERITY_ID NUMBER (15) Yes Identifier for service request severity
SUMMARY VARCHAR2 (240) Yes Service request summary
INCIDENT_OWNER_ID NUMBER (15)
Identifier for the owner of the service request
RESOURCE_TYPE VARCHAR2 (30)
Identifier for the owner type of the service request. The owner type could be an Employee, a Group or a Team.
RESOURCE_SUBTYPE_ID NUMBER

Not used.
INVENTORY_ITEM_ID NUMBER (15)
Item identifier
SHIP_TO_SITE_USE_ID NUMBER (15)
Identifier for ship- to site use
SHIP_TO_CONTACT_ID NUMBER (15)
Ship-to contact identifier
BILL_TO_SITE_USE_ID NUMBER (15)
Identifier for bill-to site use
BILL_TO_CONTACT_ID NUMBER (15)
Bill-to contact identifier
INSTALL_SITE_USE_ID NUMBER (15)
Identifier for installed site use
PROBLEM_CODE VARCHAR2 (50)
Problem code
EXPECTED_RESOLUTION_DATE DATE

Expected date for the problem resolution
ACTUAL_RESOLUTION_DATE DATE

Actual date of resolution
INCIDENT_DATE DATE

Service request date
CUSTOMER_PRODUCT_ID NUMBER (15)
Customer product identifier
INCIDENT_ATTRIBUTE_1 VARCHAR2 (150)
Descriptive flexfield segment column.
INCIDENT_ATTRIBUTE_2 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_3 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_4 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_5 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_6 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_7 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_8 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_9 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_10 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_11 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_12 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_13 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_14 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_ATTRIBUTE_15 VARCHAR2 (150)
Descriptive flexfield segment column
INCIDENT_CONTEXT VARCHAR2 (30)
Descriptive flexfield structure defining column
RECORD_IS_VALID_FLAG VARCHAR2 (1)
Flag to denote if the service request is verified or not
RESOLUTION_CODE VARCHAR2 (50)
Problem resolution quick code
INTERFACED_TO_DEPOT_FLAG VARCHAR2 (1)
Flag to denote service request is linked to repairs
INCIDENT_TYPE VARCHAR2 (90) Yes Incident Type name
SEVERITY VARCHAR2 (90) Yes Severity Name
STATUS_CODE VARCHAR2 (90) Yes Status name
URGENCY VARCHAR2 (90)
Urgency Name
CREATED_BY_NAME VARCHAR2 (100) Yes Name of the identity who created the Service Request
PRODUCT_REVISION VARCHAR2 (15)
Revision of the product
FILED_BY_EMPLOYEE_FLAG VARCHAR2 (1)
Indicates whether the request was made by an employee
CUSTOMER_ID NUMBER (15)
Customer identifier
ACCOUNT_ID NUMBER

Account Identifier
EMPLOYEE_ID NUMBER (15)
Identifier for the employee if the service request is made by an employee
EMPLOYEE_NAME VARCHAR2 (240)
Name of the Employee
EMPLOYEE_NUMBER VARCHAR2 (30)
A number to uniquely identify the employee.
CURRENT_SERIAL_NUMBER VARCHAR2 (30)
Serial Number for an Installed Base product
CURRENT_SERIAL_NUMBER_NV VARCHAR2 (30)
Serial Number for a product that is not in Installed Base
SYSTEM_ID NUMBER

Not used
SYSTEM_NAME VARCHAR2 (50)
System Name
CP_INSTALL_SITE_USE_ID NUMBER

Identifier for installed site use
REFERENCE_NUMBER VARCHAR2 (30)
Unique reference for a customer product
CUSTOMER_PRODUCT_STATUS_ID NUMBER

Status identifier of a customer product
CUSTOMER_PRODUCT_STATUS VARCHAR2 (50)
Customer Product Status name
PRODUCT_SUPPORT_CUSTOMER_ID NUMBER

Not Used
PURCHASE_ORDER_NUM VARCHAR2 (50)
The purchase order number for a product.
ORIGINAL_ORDER_NUMBER NUMBER

Original Sales Order Number
INCIDENT_ALLOWED_FLAG VARCHAR2 (1)
Incident Allowed Flag
PROBLEM_CODE_MEANING VARCHAR2 (80)
Meaning of the Problem Code
PROBLEM_CODE_DESCRIPTION VARCHAR2 (240)
Description for the Problem Code
RESOLUTION_CODE_MEANING VARCHAR2 (80)
Meaning of the Resolution Code
RESOLUTION_CODE_DESCRIPTION VARCHAR2 (240)
Description for the Resolution Code
WORKFLOW_PROCESS_ID NUMBER

Sequence number used for this action's last workflow process
LAST_INCIDENT_UPDATE_DATE_V DATE

Date when the Service Request was last updated.
RELATED_STATUSES_CNT_V NUMBER

Count of the Related Statuses for a given Incident Type.
DATE_CLOSED DATE

Date when the Service Request closed.
LOGGED_BY_NAME VARCHAR2 (100) Yes Name by whom the Service Request by logged.
CLOSED_FLAG VARCHAR2 (1)
Flag to denote whether the service request is closed or not.
PUBLISH_FLAG VARCHAR2 (1)
Flag to denote whether the service request is published or not.
QA_COLLECTION_ID NUMBER

Foreign key to Quality results table
CONTRACT_SERVICE_ID NUMBER

Service line unique identifier
KB_SOLUTION_ID VARCHAR2 (240)
External knowledge base solution identifier.
TIME_ZONE_ID NUMBER (15)
This field stores the time zone id of the time zone specified in the service request form
CUSTOMER_PO_NUMBER VARCHAR2 (50)
Customer's Purchase Order number.
CUSTOMER_TICKET_NUMBER VARCHAR2 (50)
Customer's internal helpdesk tracking number.
OBLIGATION_DATE DATE

Obligation Date
SITE_ID NUMBER

Identifier for Support Site.
CUSTOMER_SITE_ID NUMBER

Identifier for Customer Site.
SR_CREATION_CHANNEL VARCHAR2 (50)
Source of channel through which a Service Request is created. The channel of creation.
PLATFORM_VERSION_ID NUMBER

Identifier for Platform Version.
CUSTOMER_NUMBER VARCHAR2 (30)
Customer Number
CALLER_TYPE VARCHAR2 (30) Yes Type of the Calling Party. It could be an Organization, Person, Employee.
CP_COMPONENT_ID NUMBER

Identifier for Installed Base Component.
CP_COMPONENT_VERSION_ID NUMBER

Identifier for Installed Base Component Revision.
CP_SUBCOMPONENT_ID NUMBER

Identifier for Installed Base Subcomponent.
CP_SUBCOMPONENT_VERSION_ID NUMBER

Identifier for Installed Base Subcomponent Revision.
CP_REVISION_ID NUMBER

Identifier for Installed Base Product Revision.
INV_ITEM_REVISION VARCHAR2 (240)
Identifier for the Item Revision for a product not in Installed Base.
INV_COMPONENT_ID NUMBER

Identifier for the Component for a product not in Installed Base.
INV_COMPONENT_VERSION VARCHAR2 (90)
Identifier for the Component Revision for a product not in Installed Base.
INV_SUBCOMPONENT_ID NUMBER

Identifier for the Subcomponent for a product not in Installed Base.
INV_SUBCOMPONENT_VERSION VARCHAR2 (90)
Identifier for the Subcomponent Revision for a product not in Installed Base.
INV_ORGANIZATION_ID NUMBER

This field stores the inventory organization id based on the profile AS_PRODUCT_ORGANIZATION_ID.
PLATFORM_ID NUMBER

Identifier for Platform.
LANGUAGE_ID NUMBER

Identifier for the Product's Language.
TERRITORY_ID NUMBER

Identifier for the Territory of the Service Request.
TIME_DIFFERENCE NUMBER

GMT offset of the contact person's time.
PRODUCT_NAME VARCHAR2 (40)
Name of the product
PRODUCT_DESCRIPTION VARCHAR2 (240)
Description for the product
OWNER VARCHAR2 (360)
Service Request Owner's name
COMPANY_NAME VARCHAR2 (360)
Customer Name for whom the Service Request is created
PERSON_FIRST_NAME VARCHAR2 (150)
Contact person's first name
PERSON_LAST_NAME VARCHAR2 (150)
Contact person's last name
CONTACT_NAME VARCHAR2 (301)
Contact person's full name
COUNTRY_CODE VARCHAR2 (10)
Country code of the contact's phone
AREA_CODE VARCHAR2 (10)
Area code of the contact's phone
PHONE_NUMBER VARCHAR2 (40)
Number of the contact's phone
PHONE VARCHAR2 (62)
Contact's phone number
EXT VARCHAR2 (20)
Contact's phone extension
EMAIL VARCHAR2 (2000)
Contact's email address
PHONE_TYPE VARCHAR2 (30)
Communication type for the Contact. e.g. Phone/Fax/Cell
TIME_ZONE_NAME VARCHAR2 (50)
This field stores the time zone name of the time zone specified in the service request form
CONTACT_PARTY_ID NUMBER

Contact Identifier
CONTACT_POINT_ID NUMBER

Unique identifier of this contact point
ACCOUNT VARCHAR2 (30)
Account Number
CALLER_TYPE_NAME VARCHAR2 (80)
Name of Caller Type
CALLER_TYPE_DESCRIPTION VARCHAR2 (240)
Description of Caller Type
OBJECT_VERSION_NUMBER NUMBER (9)
Version Number of Object from CS_INCIDENTS_ALL_B.
PERSON_TITLE VARCHAR2 (30)
Person Title
CONTACT_TYPE VARCHAR2 (30)
Contact Type
CONTRACT_NUMBER VARCHAR2 (120)
Contract Number associated with a Service Request
CONTRACT_ID NUMBER

Header Id of the Contract Line associated with a Service Request
PROJECT_NUMBER VARCHAR2 (120)
Project Number associated with a Service Request
ERROR_CODE VARCHAR2 (250)
Error Code
Query Text

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


SELECT ROW_ID
,      INCIDENT_ID
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INCIDENT_NUMBER
,      INCIDENT_NUMBER_N
,      INCIDENT_STATUS_ID
,      INCIDENT_TYPE_ID
,      INCIDENT_URGENCY_ID
,      INCIDENT_SEVERITY_ID
,      SUMMARY
,      INCIDENT_OWNER_ID
,      RESOURCE_TYPE
,      RESOURCE_SUBTYPE_ID
,      INVENTORY_ITEM_ID
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_CONTACT_ID
,      BILL_TO_SITE_USE_ID
,      BILL_TO_CONTACT_ID
,      INSTALL_SITE_USE_ID
,      PROBLEM_CODE
,      EXPECTED_RESOLUTION_DATE
,      ACTUAL_RESOLUTION_DATE
,      INCIDENT_DATE
,      CUSTOMER_PRODUCT_ID
,      INCIDENT_ATTRIBUTE_1
,      INCIDENT_ATTRIBUTE_2
,      INCIDENT_ATTRIBUTE_3
,      INCIDENT_ATTRIBUTE_4
,      INCIDENT_ATTRIBUTE_5
,      INCIDENT_ATTRIBUTE_6
,      INCIDENT_ATTRIBUTE_7
,      INCIDENT_ATTRIBUTE_8
,      INCIDENT_ATTRIBUTE_9
,      INCIDENT_ATTRIBUTE_10
,      INCIDENT_ATTRIBUTE_11
,      INCIDENT_ATTRIBUTE_12
,      INCIDENT_ATTRIBUTE_13
,      INCIDENT_ATTRIBUTE_14
,      INCIDENT_ATTRIBUTE_15
,      INCIDENT_CONTEXT
,      RECORD_IS_VALID_FLAG
,      RESOLUTION_CODE
,      INTERFACED_TO_DEPOT_FLAG
,      INCIDENT_TYPE
,      SEVERITY
,      STATUS_CODE
,      URGENCY
,      CREATED_BY_NAME
,      PRODUCT_REVISION
,      FILED_BY_EMPLOYEE_FLAG
,      CUSTOMER_ID
,      ACCOUNT_ID
,      EMPLOYEE_ID
,      EMPLOYEE_NAME
,      EMPLOYEE_NUMBER
,      CURRENT_SERIAL_NUMBER
,      CURRENT_SERIAL_NUMBER_NV
,      SYSTEM_ID
,      SYSTEM_NAME
,      CP_INSTALL_SITE_USE_ID
,      REFERENCE_NUMBER
,      CUSTOMER_PRODUCT_STATUS_ID
,      CUSTOMER_PRODUCT_STATUS
,      PRODUCT_SUPPORT_CUSTOMER_ID
,      PURCHASE_ORDER_NUM
,      ORIGINAL_ORDER_NUMBER
,      INCIDENT_ALLOWED_FLAG
,      PROBLEM_CODE_MEANING
,      PROBLEM_CODE_DESCRIPTION
,      RESOLUTION_CODE_MEANING
,      RESOLUTION_CODE_DESCRIPTION
,      WORKFLOW_PROCESS_ID
,      LAST_INCIDENT_UPDATE_DATE_V
,      RELATED_STATUSES_CNT_V
,      DATE_CLOSED
,      LOGGED_BY_NAME
,      CLOSED_FLAG
,      PUBLISH_FLAG
,      QA_COLLECTION_ID
,      CONTRACT_SERVICE_ID
,      KB_SOLUTION_ID
,      TIME_ZONE_ID
,      CUSTOMER_PO_NUMBER
,      CUSTOMER_TICKET_NUMBER
,      OBLIGATION_DATE
,      SITE_ID
,      CUSTOMER_SITE_ID
,      SR_CREATION_CHANNEL
,      PLATFORM_VERSION_ID
,      CUSTOMER_NUMBER
,      CALLER_TYPE
,      CP_COMPONENT_ID
,      CP_COMPONENT_VERSION_ID
,      CP_SUBCOMPONENT_ID
,      CP_SUBCOMPONENT_VERSION_ID
,      CP_REVISION_ID
,      INV_ITEM_REVISION
,      INV_COMPONENT_ID
,      INV_COMPONENT_VERSION
,      INV_SUBCOMPONENT_ID
,      INV_SUBCOMPONENT_VERSION
,      INV_ORGANIZATION_ID
,      PLATFORM_ID
,      LANGUAGE_ID
,      TERRITORY_ID
,      TIME_DIFFERENCE
,      PRODUCT_NAME
,      PRODUCT_DESCRIPTION
,      OWNER
,      COMPANY_NAME
,      PERSON_FIRST_NAME
,      PERSON_LAST_NAME
,      CONTACT_NAME
,      COUNTRY_CODE
,      AREA_CODE
,      PHONE_NUMBER
,      PHONE
,      EXT
,      EMAIL
,      PHONE_TYPE
,      TIME_ZONE_NAME
,      CONTACT_PARTY_ID
,      CONTACT_POINT_ID
,      ACCOUNT
,      CALLER_TYPE_NAME
,      CALLER_TYPE_DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      PERSON_TITLE
,      CONTACT_TYPE
,      CONTRACT_NUMBER
,      CONTRACT_ID
,      PROJECT_NUMBER
,      ERROR_CODE
FROM APPS.CS_INCIDENTS_V;

Dependencies

[top of page]

APPS.CS_INCIDENTS_V references the following:

SchemaAPPS
ViewCSC_HZ_PARTIES_SELF_V
PL/SQL PackageCSICUMPI_PUB - show dependent code
SynonymCS_CP_REVISIONS
ViewCS_CUSTOMER_PRODUCTS
SynonymCS_CUSTOMER_PRODUCT_STATUSES
SynonymCS_HZ_SR_CONTACT_POINTS
SynonymCS_INCIDENTS_ALL_B
SynonymCS_INCIDENTS_ALL_TL
ViewCS_INCIDENT_SEVERITIES_VL
ViewCS_INCIDENT_STATUSES_VL
ViewCS_INCIDENT_TYPES_VL
ViewCS_INCIDENT_URGENCIES_VL
ViewCS_LOOKUPS
ViewCS_SR_OWNERS_V
PL/SQL PackageCS_SR_UTIL_PKG - show dependent code
PL/SQL PackageCS_STD - show dependent code
SynonymCS_SYSTEMS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_USER
SynonymHZ_CONTACT_POINTS
SynonymHZ_TIMEZONES
ViewJTF_CUST_ACCOUNTS_ALL_V
ViewJTF_PARTIES_ALL_V
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymPER_ALL_PEOPLE_F
APPS.CS_INCIDENTS_V is referenced by following:

SchemaAPPS
Package BodyAHL_UMP_SR_PVT - show dependent code
Package BodyCSC_ROUTING_UTL - show dependent code
Package BodyCSD_ISUP_DEPOT_WF_PVT - show dependent code
Package BodyCSD_WF_PROCESS_PVT - show dependent code
Package BodyCS_SR_FUL_PKG - show dependent code
Package BodyCS_WF_ACTIVITIES_PKG - show dependent code
Package BodyCS_WORKFLOW_PKG - show dependent code
Package BodyOKS_CT_EVENTS_WFA - show dependent code