Skip to content

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

VIEW: CSM.CSM_INCIDENTS_ALL_INQ#

Object Details
Object Name: CSM_INCIDENTS_ALL_INQ#
Object Type: VIEW
Owner: CSM
Subobject Name:
Status: VALID

[View Source]

Columns
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)
CUSTOMER_TICKET_NUMBER VARCHAR2 (50)
PROJECT_NUMBER VARCHAR2 (120)
INCIDENT_OWNER_ID NUMBER

TIME_ZONE_ID NUMBER

TIME_DIFFERENCE NUMBER

CUST_PREF_LANG_ID NUMBER

CUST_PREF_LANG_CODE VARCHAR2 (4)
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 VARCHAR2 (4000)
FREE_FORM_SERIAL VARCHAR2 (4000)
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
,      FREE_FORM_INSTANCE
,      FREE_FORM_SERIAL
FROM CSM.CSM_INCIDENTS_ALL_INQ#;

Dependencies

[top of page]

CSM.CSM_INCIDENTS_ALL_INQ# references the following:

SchemaCSM
TableCSM_INCIDENTS_ALL_INQ
CSM.CSM_INCIDENTS_ALL_INQ# is referenced by following:

SchemaAPPS
SynonymCSM_INCIDENTS_ALL_INQ