[Home] [Help] [Dependency Information]
Object Name: | CSM_INCIDENTS_ALL_INQ |
---|---|
Object Type: | TABLE |
Owner: | CSM |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSM_INCIDENTS_ALL_INQ_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TRANID$$
CLID$$CS SEQNO$$ |
Name | Datatype | Length | Mandatory | 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 | |||
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 | |||
FREE_FORM_INSTANCE#1 | VARCHAR2 | (4000) | ||
FREE_FORM_SERIAL#1 | VARCHAR2 | (4000) |
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
, FREE_FORM_INSTANCE#1
, FREE_FORM_SERIAL#1
FROM CSM.CSM_INCIDENTS_ALL_INQ;
CSM.CSM_INCIDENTS_ALL_INQ does not reference any database object
CSM.CSM_INCIDENTS_ALL_INQ is referenced by following:
|
|
|