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]

TABLE: CSM.CSM_INCIDENTS_ALL_INQ

Object Details

Object Name:	CSM_INCIDENTS_ALL_INQ
Object Type:	TABLE
Owner:	CSM
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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSM_INCIDENTS_ALL_INQ_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANID$$ CLID$$CS SEQNO$$

Columns

Name	Datatype	Length	Comments
CLID$$CS	VARCHAR2	(240)
INCIDENT_ID	NUMBER	(15)
INCIDENT_NUMBER	VARCHAR2	(4000)
CALLER_TYPE	VARCHAR2	(30)
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
DMLTYPE$$	VARCHAR2	(1)
SEQNO$$	NUMBER	(10)
TRANID$$	NUMBER	(10)
VERSION$$	NUMBER	(10)
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
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		Shown as �owner type� on SR detailpage
TIME_ZONE_ID	NUMBER		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 CLID$$CS
,      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
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
,      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 CSM.CSM_INCIDENTS_ALL_INQ;

Dependencies

[top of page]

CSM.CSM_INCIDENTS_ALL_INQ does not reference any database object

CSM.CSM_INCIDENTS_ALL_INQ is referenced by following:

APPS: CSM_INCIDENTS_ALL_INQ