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: CSM.CSM_INCIDENTS_ALL_INQ#

Source

View Text - Preformatted


select CLID$$CS CLID$$CS, INCIDENT_ID INCIDENT_ID, INCIDENT_NUMBER INCIDENT_NUMBER, CALLER_TYPE CALLER_TYPE, 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, CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER, INV_ORGANIZATION_ID INV_ORGANIZATION_ID, ITEM_NAME ITEM_NAME, ITEM_DESCRIPTION ITEM_DESCRIPTION, PROBLEM_CODE PROBLEM_CODE, RESOLUTION_CODE RESOLUTION_CODE, CONTRACT_SERVICE_ID CONTRACT_SERVICE_ID, INV_ITEM_REVISION INV_ITEM_REVISION, CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER, 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, 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, LAST_UPDATE_DATE LAST_UPDATE_DATE, DMLTYPE$$ DMLTYPE$$, SEQNO$$ SEQNO$$, TRANID$$ TRANID$$, VERSION$$ VERSION$$, CREATED_BY CREATED_BY, INSTALL_SITE_ID INSTALL_SITE_ID, INCIDENT_LOCATION_ID INCIDENT_LOCATION_ID, INCIDENT_LOCATION_TYPE INCIDENT_LOCATION_TYPE, INCIDENT_OCCURRED_DATE INCIDENT_OCCURRED_DATE, INCIDENT_RESOLVED_DATE INCIDENT_RESOLVED_DATE, INC_RESPONDED_BY_DATE INC_RESPONDED_BY_DATE, OBLIGATION_DATE OBLIGATION_DATE, EXPECTED_RESOLUTION_DATE EXPECTED_RESOLUTION_DATE, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREDIT_CARD_ID CREDIT_CARD_ID, RESOLUTION_SUMMARY RESOLUTION_SUMMARY, CUSTOMER_TICKET_NUMBER CUSTOMER_TICKET_NUMBER, PROJECT_NUMBER PROJECT_NUMBER, INCIDENT_OWNER_ID INCIDENT_OWNER_ID, TIME_ZONE_ID TIME_ZONE_ID, TIME_DIFFERENCE TIME_DIFFERENCE, CUST_PREF_LANG_ID CUST_PREF_LANG_ID, CUST_PREF_LANG_CODE CUST_PREF_LANG_CODE, EXTERNAL_REFERENCE EXTERNAL_REFERENCE, ACCOUNT_ID ACCOUNT_ID, OWNER_GROUP_ID OWNER_GROUP_ID, LAST_UPDATED_BY LAST_UPDATED_BY, OWNER_GROUP_NAME OWNER_GROUP_NAME, SERVER_LAST_UPDATE_DATE SERVER_LAST_UPDATE_DATE, FREE_FORM_INSTANCE#1 FREE_FORM_INSTANCE, FREE_FORM_SERIAL#1 FREE_FORM_SERIAL from "CSM"."CSM_INCIDENTS_ALL_INQ"

View Text - HTML Formatted

SELECT CLID$$CS CLID$$CS
, INCIDENT_ID INCIDENT_ID
, INCIDENT_NUMBER INCIDENT_NUMBER
, CALLER_TYPE CALLER_TYPE
, 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
, CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER
, INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, ITEM_NAME ITEM_NAME
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, PROBLEM_CODE PROBLEM_CODE
, RESOLUTION_CODE RESOLUTION_CODE
, CONTRACT_SERVICE_ID CONTRACT_SERVICE_ID
, INV_ITEM_REVISION INV_ITEM_REVISION
, CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER
, 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
, 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
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DMLTYPE$$ DMLTYPE$$
, SEQNO$$ SEQNO$$
, TRANID$$ TRANID$$
, VERSION$$ VERSION$$
, CREATED_BY CREATED_BY
, INSTALL_SITE_ID INSTALL_SITE_ID
, INCIDENT_LOCATION_ID INCIDENT_LOCATION_ID
, INCIDENT_LOCATION_TYPE INCIDENT_LOCATION_TYPE
, INCIDENT_OCCURRED_DATE INCIDENT_OCCURRED_DATE
, INCIDENT_RESOLVED_DATE INCIDENT_RESOLVED_DATE
, INC_RESPONDED_BY_DATE INC_RESPONDED_BY_DATE
, OBLIGATION_DATE OBLIGATION_DATE
, EXPECTED_RESOLUTION_DATE EXPECTED_RESOLUTION_DATE
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREDIT_CARD_ID CREDIT_CARD_ID
, RESOLUTION_SUMMARY RESOLUTION_SUMMARY
, CUSTOMER_TICKET_NUMBER CUSTOMER_TICKET_NUMBER
, PROJECT_NUMBER PROJECT_NUMBER
, INCIDENT_OWNER_ID INCIDENT_OWNER_ID
, TIME_ZONE_ID TIME_ZONE_ID
, TIME_DIFFERENCE TIME_DIFFERENCE
, CUST_PREF_LANG_ID CUST_PREF_LANG_ID
, CUST_PREF_LANG_CODE CUST_PREF_LANG_CODE
, EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, ACCOUNT_ID ACCOUNT_ID
, OWNER_GROUP_ID OWNER_GROUP_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, OWNER_GROUP_NAME OWNER_GROUP_NAME
, SERVER_LAST_UPDATE_DATE SERVER_LAST_UPDATE_DATE
, FREE_FORM_INSTANCE#1 FREE_FORM_INSTANCE
, FREE_FORM_SERIAL#1 FREE_FORM_SERIAL
FROM "CSM"."CSM_INCIDENTS_ALL_INQ"