[Home] [Help] [Dependency Information]
Object Name: | CSL_CS_INCIDENTS_ALL_VL_INQ# |
---|---|
Object Type: | VIEW |
Owner: | CSL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLID$$CS | VARCHAR2 | (240) | ||
INCIDENT_ID | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
CALLER_TYPE | VARCHAR2 | (30) | ||
INCIDENT_NUMBER | VARCHAR2 | (64) | ||
INCIDENT_SEVERITY_ID | NUMBER | (15) | ||
INCIDENT_STATUS_ID | NUMBER | (15) | ||
INCIDENT_TYPE_ID | NUMBER | (15) | ||
INCIDENT_URGENCY_ID | NUMBER | (15) | ||
INCIDENT_DATE | DATE | |||
SUMMARY | VARCHAR2 | (240) | ||
ORG_ID | NUMBER | |||
CUSTOMER_ID | NUMBER | (15) | ||
INSTALL_SITE_USE_ID | NUMBER | (15) | ||
CUSTOMER_PRODUCT_ID | NUMBER | (15) | ||
INVENTORY_ITEM_ID | NUMBER | (15) | ||
INV_ORGANIZATION_ID | NUMBER | |||
PROBLEM_CODE | VARCHAR2 | (50) | ||
RESOLUTION_CODE | VARCHAR2 | (50) | ||
CONTRACT_SERVICE_ID | NUMBER | |||
CURRENT_SERIAL_NUMBER | VARCHAR2 | (30) | ||
INV_ITEM_REVISION | VARCHAR2 | (240) | ||
LANGUAGE | VARCHAR2 | (4) | ||
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) | ||
CUSTOMER_PO_NUMBER | VARCHAR2 | (50) | ||
LAST_UPDATE_DATE | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
SEQNO$$ | NUMBER | (10) | ||
TRANID$$ | NUMBER | (10) | ||
VERSION$$ | NUMBER | (10) | ||
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) | ||
CREDIT_CARD_ID | NUMBER | |||
INSTALL_SITE_ID | NUMBER | |||
OBLIGATION_DATE | DATE | |||
EXPECTED_RESOLUTION_DATE | DATE | |||
INCIDENT_LOCATION_ID | NUMBER | |||
INCIDENT_ADDRESS | VARCHAR2 | (960) | ||
INCIDENT_CITY | VARCHAR2 | (60) | ||
INCIDENT_STATE | VARCHAR2 | (60) | ||
INCIDENT_COUNTRY | VARCHAR2 | (60) | ||
INCIDENT_PROVINCE | VARCHAR2 | (60) | ||
INCIDENT_POSTAL_CODE | VARCHAR2 | (60) | ||
INCIDENT_COUNTY | VARCHAR2 | (60) | ||
INCIDENT_LOCATION_TYPE | VARCHAR2 | (30) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
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) |
Cut, paste (and edit) the following text to query this object:
SELECT CLID$$CS
, INCIDENT_ID
, OBJECT_VERSION_NUMBER
, CALLER_TYPE
, INCIDENT_NUMBER
, 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
, INV_ORGANIZATION_ID
, PROBLEM_CODE
, RESOLUTION_CODE
, CONTRACT_SERVICE_ID
, CURRENT_SERIAL_NUMBER
, INV_ITEM_REVISION
, LANGUAGE
, 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
, CUSTOMER_PO_NUMBER
, LAST_UPDATE_DATE
, DMLTYPE$$
, SEQNO$$
, TRANID$$
, VERSION$$
, CREDIT_CARD_NUMBER
, CREDIT_CARD_TYPE_CODE
, CREDIT_CARD_EXPIRATION_DATE
, CREDIT_CARD_HOLDER_FNAME
, CREDIT_CARD_HOLDER_MNAME
, CREDIT_CARD_HOLDER_LNAME
, CREDIT_CARD_ID
, INSTALL_SITE_ID
, OBLIGATION_DATE
, EXPECTED_RESOLUTION_DATE
, INCIDENT_LOCATION_ID
, INCIDENT_ADDRESS
, INCIDENT_CITY
, INCIDENT_STATE
, INCIDENT_COUNTRY
, INCIDENT_PROVINCE
, INCIDENT_POSTAL_CODE
, INCIDENT_COUNTY
, INCIDENT_LOCATION_TYPE
, CONCATENATED_SEGMENTS
, ITEM_DESCRIPTION
, 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
FROM CSL.CSL_CS_INCIDENTS_ALL_VL_INQ#;
|
|
|