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.

[Home] [Help]

VIEW: CSL.CSL_CS_INCIDENTS_ALL_VL_INQ#

Source

View Text - Preformatted


select CLID$$CS CLID$$CS, INCIDENT_ID INCIDENT_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CALLER_TYPE CALLER_TYPE, INCIDENT_NUMBER INCIDENT_NUMBER, INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID, INCIDENT_STATUS_ID INCIDENT_STATUS_ID, INCIDENT_TYPE_ID INCIDENT_TYPE_ID, INCIDENT_URGENCY_ID INCIDENT_URGENCY_ID, INCIDENT_DATE INCIDENT_DATE, SUMMARY SUMMARY, ORG_ID ORG_ID, CUSTOMER_ID CUSTOMER_ID, INSTALL_SITE_USE_ID INSTALL_SITE_USE_ID, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INV_ORGANIZATION_ID INV_ORGANIZATION_ID, PROBLEM_CODE PROBLEM_CODE, RESOLUTION_CODE RESOLUTION_CODE, CONTRACT_SERVICE_ID CONTRACT_SERVICE_ID, CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER, INV_ITEM_REVISION INV_ITEM_REVISION, LANGUAGE LANGUAGE, INCIDENT_ATTRIBUTE_1 INCIDENT_ATTRIBUTE_1, INCIDENT_ATTRIBUTE_2 INCIDENT_ATTRIBUTE_2, INCIDENT_ATTRIBUTE_3 INCIDENT_ATTRIBUTE_3, INCIDENT_ATTRIBUTE_4 INCIDENT_ATTRIBUTE_4, INCIDENT_ATTRIBUTE_5 INCIDENT_ATTRIBUTE_5, INCIDENT_ATTRIBUTE_6 INCIDENT_ATTRIBUTE_6, INCIDENT_ATTRIBUTE_7 INCIDENT_ATTRIBUTE_7, INCIDENT_ATTRIBUTE_8 INCIDENT_ATTRIBUTE_8, INCIDENT_ATTRIBUTE_9 INCIDENT_ATTRIBUTE_9, INCIDENT_ATTRIBUTE_10 INCIDENT_ATTRIBUTE_10, INCIDENT_ATTRIBUTE_11 INCIDENT_ATTRIBUTE_11, INCIDENT_ATTRIBUTE_12 INCIDENT_ATTRIBUTE_12, INCIDENT_ATTRIBUTE_13 INCIDENT_ATTRIBUTE_13, INCIDENT_ATTRIBUTE_14 INCIDENT_ATTRIBUTE_14, INCIDENT_ATTRIBUTE_15 INCIDENT_ATTRIBUTE_15, INCIDENT_CONTEXT INCIDENT_CONTEXT, CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, DMLTYPE$$ DMLTYPE$$, SEQNO$$ SEQNO$$, TRANID$$ TRANID$$, VERSION$$ VERSION$$, CREDIT_CARD_NUMBER CREDIT_CARD_NUMBER, CREDIT_CARD_TYPE_CODE CREDIT_CARD_TYPE_CODE, CREDIT_CARD_EXPIRATION_DATE CREDIT_CARD_EXPIRATION_DATE, CREDIT_CARD_HOLDER_FNAME CREDIT_CARD_HOLDER_FNAME, CREDIT_CARD_HOLDER_MNAME CREDIT_CARD_HOLDER_MNAME, CREDIT_CARD_HOLDER_LNAME CREDIT_CARD_HOLDER_LNAME, CREDIT_CARD_ID CREDIT_CARD_ID, INSTALL_SITE_ID INSTALL_SITE_ID, OBLIGATION_DATE OBLIGATION_DATE, EXPECTED_RESOLUTION_DATE EXPECTED_RESOLUTION_DATE, INCIDENT_LOCATION_ID INCIDENT_LOCATION_ID, INCIDENT_ADDRESS INCIDENT_ADDRESS, INCIDENT_CITY INCIDENT_CITY, INCIDENT_STATE INCIDENT_STATE, INCIDENT_COUNTRY INCIDENT_COUNTRY, INCIDENT_PROVINCE INCIDENT_PROVINCE, INCIDENT_POSTAL_CODE INCIDENT_POSTAL_CODE, INCIDENT_COUNTY INCIDENT_COUNTY, INCIDENT_LOCATION_TYPE INCIDENT_LOCATION_TYPE, CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS, ITEM_DESCRIPTION ITEM_DESCRIPTION, EXTERNAL_ATTRIBUTE_1 EXTERNAL_ATTRIBUTE_1, EXTERNAL_ATTRIBUTE_2 EXTERNAL_ATTRIBUTE_2, EXTERNAL_ATTRIBUTE_3 EXTERNAL_ATTRIBUTE_3, EXTERNAL_ATTRIBUTE_4 EXTERNAL_ATTRIBUTE_4, EXTERNAL_ATTRIBUTE_5 EXTERNAL_ATTRIBUTE_5, EXTERNAL_ATTRIBUTE_6 EXTERNAL_ATTRIBUTE_6, EXTERNAL_ATTRIBUTE_7 EXTERNAL_ATTRIBUTE_7, EXTERNAL_ATTRIBUTE_8 EXTERNAL_ATTRIBUTE_8, EXTERNAL_ATTRIBUTE_9 EXTERNAL_ATTRIBUTE_9, EXTERNAL_ATTRIBUTE_10 EXTERNAL_ATTRIBUTE_10, EXTERNAL_ATTRIBUTE_11 EXTERNAL_ATTRIBUTE_11, EXTERNAL_ATTRIBUTE_12 EXTERNAL_ATTRIBUTE_12, EXTERNAL_ATTRIBUTE_13 EXTERNAL_ATTRIBUTE_13, EXTERNAL_ATTRIBUTE_14 EXTERNAL_ATTRIBUTE_14, EXTERNAL_ATTRIBUTE_15 EXTERNAL_ATTRIBUTE_15, EXTERNAL_CONTEXT EXTERNAL_CONTEXT from "CSL"."CSL_CS_INCIDENTS_ALL_VL_INQ"

View Text - HTML Formatted

SELECT CLID$$CS CLID$$CS
, INCIDENT_ID INCIDENT_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CALLER_TYPE CALLER_TYPE
, INCIDENT_NUMBER INCIDENT_NUMBER
, INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID
, INCIDENT_STATUS_ID INCIDENT_STATUS_ID
, INCIDENT_TYPE_ID INCIDENT_TYPE_ID
, INCIDENT_URGENCY_ID INCIDENT_URGENCY_ID
, INCIDENT_DATE INCIDENT_DATE
, SUMMARY SUMMARY
, ORG_ID ORG_ID
, CUSTOMER_ID CUSTOMER_ID
, INSTALL_SITE_USE_ID INSTALL_SITE_USE_ID
, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, PROBLEM_CODE PROBLEM_CODE
, RESOLUTION_CODE RESOLUTION_CODE
, CONTRACT_SERVICE_ID CONTRACT_SERVICE_ID
, CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER
, INV_ITEM_REVISION INV_ITEM_REVISION
, LANGUAGE LANGUAGE
, INCIDENT_ATTRIBUTE_1 INCIDENT_ATTRIBUTE_1
, INCIDENT_ATTRIBUTE_2 INCIDENT_ATTRIBUTE_2
, INCIDENT_ATTRIBUTE_3 INCIDENT_ATTRIBUTE_3
, INCIDENT_ATTRIBUTE_4 INCIDENT_ATTRIBUTE_4
, INCIDENT_ATTRIBUTE_5 INCIDENT_ATTRIBUTE_5
, INCIDENT_ATTRIBUTE_6 INCIDENT_ATTRIBUTE_6
, INCIDENT_ATTRIBUTE_7 INCIDENT_ATTRIBUTE_7
, INCIDENT_ATTRIBUTE_8 INCIDENT_ATTRIBUTE_8
, INCIDENT_ATTRIBUTE_9 INCIDENT_ATTRIBUTE_9
, INCIDENT_ATTRIBUTE_10 INCIDENT_ATTRIBUTE_10
, INCIDENT_ATTRIBUTE_11 INCIDENT_ATTRIBUTE_11
, INCIDENT_ATTRIBUTE_12 INCIDENT_ATTRIBUTE_12
, INCIDENT_ATTRIBUTE_13 INCIDENT_ATTRIBUTE_13
, INCIDENT_ATTRIBUTE_14 INCIDENT_ATTRIBUTE_14
, INCIDENT_ATTRIBUTE_15 INCIDENT_ATTRIBUTE_15
, INCIDENT_CONTEXT INCIDENT_CONTEXT
, CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DMLTYPE$$ DMLTYPE$$
, SEQNO$$ SEQNO$$
, TRANID$$ TRANID$$
, VERSION$$ VERSION$$
, CREDIT_CARD_NUMBER CREDIT_CARD_NUMBER
, CREDIT_CARD_TYPE_CODE CREDIT_CARD_TYPE_CODE
, CREDIT_CARD_EXPIRATION_DATE CREDIT_CARD_EXPIRATION_DATE
, CREDIT_CARD_HOLDER_FNAME CREDIT_CARD_HOLDER_FNAME
, CREDIT_CARD_HOLDER_MNAME CREDIT_CARD_HOLDER_MNAME
, CREDIT_CARD_HOLDER_LNAME CREDIT_CARD_HOLDER_LNAME
, CREDIT_CARD_ID CREDIT_CARD_ID
, INSTALL_SITE_ID INSTALL_SITE_ID
, OBLIGATION_DATE OBLIGATION_DATE
, EXPECTED_RESOLUTION_DATE EXPECTED_RESOLUTION_DATE
, INCIDENT_LOCATION_ID INCIDENT_LOCATION_ID
, INCIDENT_ADDRESS INCIDENT_ADDRESS
, INCIDENT_CITY INCIDENT_CITY
, INCIDENT_STATE INCIDENT_STATE
, INCIDENT_COUNTRY INCIDENT_COUNTRY
, INCIDENT_PROVINCE INCIDENT_PROVINCE
, INCIDENT_POSTAL_CODE INCIDENT_POSTAL_CODE
, INCIDENT_COUNTY INCIDENT_COUNTY
, INCIDENT_LOCATION_TYPE INCIDENT_LOCATION_TYPE
, CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, EXTERNAL_ATTRIBUTE_1 EXTERNAL_ATTRIBUTE_1
, EXTERNAL_ATTRIBUTE_2 EXTERNAL_ATTRIBUTE_2
, EXTERNAL_ATTRIBUTE_3 EXTERNAL_ATTRIBUTE_3
, EXTERNAL_ATTRIBUTE_4 EXTERNAL_ATTRIBUTE_4
, EXTERNAL_ATTRIBUTE_5 EXTERNAL_ATTRIBUTE_5
, EXTERNAL_ATTRIBUTE_6 EXTERNAL_ATTRIBUTE_6
, EXTERNAL_ATTRIBUTE_7 EXTERNAL_ATTRIBUTE_7
, EXTERNAL_ATTRIBUTE_8 EXTERNAL_ATTRIBUTE_8
, EXTERNAL_ATTRIBUTE_9 EXTERNAL_ATTRIBUTE_9
, EXTERNAL_ATTRIBUTE_10 EXTERNAL_ATTRIBUTE_10
, EXTERNAL_ATTRIBUTE_11 EXTERNAL_ATTRIBUTE_11
, EXTERNAL_ATTRIBUTE_12 EXTERNAL_ATTRIBUTE_12
, EXTERNAL_ATTRIBUTE_13 EXTERNAL_ATTRIBUTE_13
, EXTERNAL_ATTRIBUTE_14 EXTERNAL_ATTRIBUTE_14
, EXTERNAL_ATTRIBUTE_15 EXTERNAL_ATTRIBUTE_15
, EXTERNAL_CONTEXT EXTERNAL_CONTEXT
FROM "CSL"."CSL_CS_INCIDENTS_ALL_VL_INQ"