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.CSM_INCIDENTS_ALL_V

Object Details

Object Name:	CSM_INCIDENTS_ALL_V
Object Type:	VIEW
Owner:	APPS
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 Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACCESS_ID	NUMBER
INCIDENT_ID	NUMBER	(15)	Yes
INCIDENT_NUMBER	VARCHAR2	(4000)
CALLER_TYPE	VARCHAR2	(30)	Yes
INCIDENT_SEVERITY_ID	NUMBER
INCIDENT_STATUS_ID	NUMBER
INCIDENT_TYPE_ID	NUMBER
INCIDENT_URGENCY_ID	NUMBER	(15)
INCIDENT_DATE	DATE
SUMMARY	VARCHAR2	(4000)
ORG_ID	NUMBER
CUSTOMER_ID	NUMBER	(15)
INSTALL_SITE_USE_ID	NUMBER	(15)
CUSTOMER_PRODUCT_ID	NUMBER	(15)
INVENTORY_ITEM_ID	NUMBER	(15)
CURRENT_SERIAL_NUMBER	VARCHAR2	(30)
INV_ORGANIZATION_ID	NUMBER
ITEM_NAME	VARCHAR2	(4000)
ITEM_DESCRIPTION	VARCHAR2	(240)
PROBLEM_CODE	VARCHAR2	(50)
RESOLUTION_CODE	VARCHAR2	(50)
CONTRACT_SERVICE_ID	NUMBER
INV_ITEM_REVISION	VARCHAR2	(240)
CUSTOMER_PO_NUMBER	VARCHAR2	(50)
CREDIT_CARD_NUMBER	VARCHAR2	(48)
CREDIT_CARD_TYPE_CODE	VARCHAR2	(30)
CREDIT_CARD_EXPIRATION_DATE	DATE
CREDIT_CARD_HOLDER_FNAME	VARCHAR2	(250)
CREDIT_CARD_HOLDER_MNAME	VARCHAR2	(250)
CREDIT_CARD_HOLDER_LNAME	VARCHAR2	(250)
INCIDENT_ATTRIBUTE_1	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_2	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_3	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_4	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_5	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_6	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_7	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_8	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_9	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_10	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_11	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_12	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_13	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_14	VARCHAR2	(150)
INCIDENT_ATTRIBUTE_15	VARCHAR2	(150)
INCIDENT_CONTEXT	VARCHAR2	(30)
LAST_UPDATE_DATE	DATE
CREATED_BY	NUMBER
INSTALL_SITE_ID	NUMBER
INCIDENT_LOCATION_ID	NUMBER
INCIDENT_LOCATION_TYPE	VARCHAR2	(30)
INCIDENT_OCCURRED_DATE	DATE
INCIDENT_RESOLVED_DATE	DATE
INC_RESPONDED_BY_DATE	DATE
OBLIGATION_DATE	DATE
EXPECTED_RESOLUTION_DATE	DATE
EXTERNAL_ATTRIBUTE_1	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_2	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_3	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_4	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_5	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_6	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_7	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_8	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_9	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_10	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_11	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_12	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_13	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_14	VARCHAR2	(150)
EXTERNAL_ATTRIBUTE_15	VARCHAR2	(150)
EXTERNAL_CONTEXT	VARCHAR2	(30)
OBJECT_VERSION_NUMBER	NUMBER
CREDIT_CARD_ID	NUMBER	(15)
RESOLUTION_SUMMARY	VARCHAR2	(250)		Resolution Summary
CUSTOMER_TICKET_NUMBER	VARCHAR2	(50)		Shown as helpdesk on SR detail page
PROJECT_NUMBER	VARCHAR2	(120)		PROJECT NUMBER
INCIDENT_OWNER_ID	NUMBER	(15)		Shown as owner type on SR detailpage
TIME_ZONE_ID	NUMBER	(15)		Time Zone id
TIME_DIFFERENCE	NUMBER			Time Difference
CUST_PREF_LANG_ID	NUMBER			Cust Preferred Language Id
CUST_PREF_LANG_CODE	VARCHAR2	(4)		Cust Preferred Language Code
EXTERNAL_REFERENCE	VARCHAR2	(30)
ACCOUNT_ID	NUMBER
OWNER_GROUP_ID	NUMBER
LAST_UPDATED_BY	NUMBER
OWNER_GROUP_NAME	VARCHAR2	(4000)
SERVER_LAST_UPDATE_DATE	DATE

Query Text

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


SELECT ACCESS_ID
,      INCIDENT_ID
,      INCIDENT_NUMBER
,      CALLER_TYPE
,      INCIDENT_SEVERITY_ID
,      INCIDENT_STATUS_ID
,      INCIDENT_TYPE_ID
,      INCIDENT_URGENCY_ID
,      INCIDENT_DATE
,      SUMMARY
,      ORG_ID
,      CUSTOMER_ID
,      INSTALL_SITE_USE_ID
,      CUSTOMER_PRODUCT_ID
,      INVENTORY_ITEM_ID
,      CURRENT_SERIAL_NUMBER
,      INV_ORGANIZATION_ID
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      PROBLEM_CODE
,      RESOLUTION_CODE
,      CONTRACT_SERVICE_ID
,      INV_ITEM_REVISION
,      CUSTOMER_PO_NUMBER
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_TYPE_CODE
,      CREDIT_CARD_EXPIRATION_DATE
,      CREDIT_CARD_HOLDER_FNAME
,      CREDIT_CARD_HOLDER_MNAME
,      CREDIT_CARD_HOLDER_LNAME
,      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
,      LAST_UPDATE_DATE
,      CREATED_BY
,      INSTALL_SITE_ID
,      INCIDENT_LOCATION_ID
,      INCIDENT_LOCATION_TYPE
,      INCIDENT_OCCURRED_DATE
,      INCIDENT_RESOLVED_DATE
,      INC_RESPONDED_BY_DATE
,      OBLIGATION_DATE
,      EXPECTED_RESOLUTION_DATE
,      EXTERNAL_ATTRIBUTE_1
,      EXTERNAL_ATTRIBUTE_2
,      EXTERNAL_ATTRIBUTE_3
,      EXTERNAL_ATTRIBUTE_4
,      EXTERNAL_ATTRIBUTE_5
,      EXTERNAL_ATTRIBUTE_6
,      EXTERNAL_ATTRIBUTE_7
,      EXTERNAL_ATTRIBUTE_8
,      EXTERNAL_ATTRIBUTE_9
,      EXTERNAL_ATTRIBUTE_10
,      EXTERNAL_ATTRIBUTE_11
,      EXTERNAL_ATTRIBUTE_12
,      EXTERNAL_ATTRIBUTE_13
,      EXTERNAL_ATTRIBUTE_14
,      EXTERNAL_ATTRIBUTE_15
,      EXTERNAL_CONTEXT
,      OBJECT_VERSION_NUMBER
,      CREDIT_CARD_ID
,      RESOLUTION_SUMMARY
,      CUSTOMER_TICKET_NUMBER
,      PROJECT_NUMBER
,      INCIDENT_OWNER_ID
,      TIME_ZONE_ID
,      TIME_DIFFERENCE
,      CUST_PREF_LANG_ID
,      CUST_PREF_LANG_CODE
,      EXTERNAL_REFERENCE
,      ACCOUNT_ID
,      OWNER_GROUP_ID
,      LAST_UPDATED_BY
,      OWNER_GROUP_NAME
,      SERVER_LAST_UPDATE_DATE
FROM APPS.CSM_INCIDENTS_ALL_V;

Dependencies

[top of page]

APPS.CSM_INCIDENTS_ALL_V references the following:

APPS: ASG_BASE - show dependent code; CSM_INCIDENTS_ALL_ACC; CSM_UTIL_PKG - show dependent code; CS_INCIDENTS_ALL_B; CS_INCIDENTS_ALL_TL; MTL_SYSTEM_ITEMS_KFV

APPS.CSM_INCIDENTS_ALL_V is not referenced by any database object