VIEW: CS.CS_INCIDENTS_ALL_B#

Source

View Text - Preformatted

select INCIDENT_ID INCIDENT_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_TIME CREATION_TIME, INCIDENT_NUMBER INCIDENT_NUMBER, INCIDENT_DATE INCIDENT_DATE, OPEN_FLAG OPEN_FLAG, SERVICE_ENTITY_ID SERVICE_ENTITY_ID, INCIDENT_STATUS_ID INCIDENT_STATUS_ID, INCIDENT_TYPE_ID INCIDENT_TYPE_ID, INCIDENT_URGENCY_ID INCIDENT_URGENCY_ID, INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID, SUMMARY SUMMARY, RESPONSIBLE_GROUP_ID RESPONSIBLE_GROUP_ID, SECURITY_LEVEL_CODE SECURITY_LEVEL_CODE, INCIDENT_OWNER_ID INCIDENT_OWNER_ID, CLASSIFICATION_CODE CLASSIFICATION_CODE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, COMPONENT_INVENTORY_ITEM_ID COMPONENT_INVENTORY_ITEM_ID, CUSTOMER_ID CUSTOMER_ID, ORIGINAL_CUSTOMER_ID ORIGINAL_CUSTOMER_ID, CUSTOMER_NAME CUSTOMER_NAME, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, PURCHASE_ORDER_NUM PURCHASE_ORDER_NUM, IDENTIFICATION_NUMBER IDENTIFICATION_NUMBER, SERVICE_INVENTORY_ITEM_ID SERVICE_INVENTORY_ITEM_ID, EMPLOYEE_ID EMPLOYEE_ID, FILED_BY_EMPLOYEE_FLAG FILED_BY_EMPLOYEE_FLAG, BILLABLE_FLAG BILLABLE_FLAG, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, PROBLEM_CODE PROBLEM_CODE, EXPECTED_RESOLUTION_DATE EXPECTED_RESOLUTION_DATE, ACTUAL_RESOLUTION_DATE ACTUAL_RESOLUTION_DATE, PROBLEM_DESCRIPTION PROBLEM_DESCRIPTION, RESOLUTION_DESCRIPTION RESOLUTION_DESCRIPTION, RUNNING_TOTALS RUNNING_TOTALS, CURRENT_CONTACT_PERSON_ID CURRENT_CONTACT_PERSON_ID, INITIATING_PERSON_ID INITIATING_PERSON_ID, CURRENT_CONTACT_NAME CURRENT_CONTACT_NAME, CURRENT_CONTACT_AREA_CODE CURRENT_CONTACT_AREA_CODE, CURRENT_CONTACT_TELEPHONE CURRENT_CONTACT_TELEPHONE, CURRENT_CONTACT_EXTENSION CURRENT_CONTACT_EXTENSION, CURRENT_CONTACT_EMAIL_ADDRESS CURRENT_CONTACT_EMAIL_ADDRESS, CURRENT_CONTACT_TIME_DIFF CURRENT_CONTACT_TIME_DIFF, CURRENT_CONTACT_FAX_AREA_CODE CURRENT_CONTACT_FAX_AREA_CODE, CURRENT_CONTACT_FAX_NUMBER CURRENT_CONTACT_FAX_NUMBER, REPRESENTED_BY_EMPLOYEE REPRESENTED_BY_EMPLOYEE, REPRESENTED_BY_NAME REPRESENTED_BY_NAME, REPRESENTED_BY_TIME_DIFFERENCE REPRESENTED_BY_TIME_DIFFERENCE, REPRESENTED_BY_AREA_CODE REPRESENTED_BY_AREA_CODE, REPRESENTED_BY_TELEPHONE REPRESENTED_BY_TELEPHONE, REPRESENTED_BY_EXTENSION REPRESENTED_BY_EXTENSION, REPRESENTED_BY_FAX_AREA_CODE REPRESENTED_BY_FAX_AREA_CODE, REPRESENTED_BY_FAX_NUMBER REPRESENTED_BY_FAX_NUMBER, REPRESENTED_BY_EMAIL_ADDRESS REPRESENTED_BY_EMAIL_ADDRESS, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, INTERNAL_CONTACT_ID INTERNAL_CONTACT_ID, HOURS_AFTER_GMT HOURS_AFTER_GMT, INITIATING_TIME_DIFFERENCE INITIATING_TIME_DIFFERENCE, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID, CP_SERVICE_ID CP_SERVICE_ID, CURRENTLY_SERVICED_FLAG CURRENTLY_SERVICED_FLAG, LAST_CUSTOMER_CALLBACK_TIME LAST_CUSTOMER_CALLBACK_TIME, PREVENTIVE_MAINTENANCE_FLAG PREVENTIVE_MAINTENANCE_FLAG, BILL_TO_TITLE BILL_TO_TITLE, BILL_TO_CUSTOMER BILL_TO_CUSTOMER, BILL_TO_ADDRESS_LINE_1 BILL_TO_ADDRESS_LINE_1, BILL_TO_ADDRESS_LINE_2 BILL_TO_ADDRESS_LINE_2, BILL_TO_ADDRESS_LINE_3 BILL_TO_ADDRESS_LINE_3, BILL_TO_CONTACT BILL_TO_CONTACT, SHIP_TO_TITLE SHIP_TO_TITLE, SHIP_TO_CUSTOMER SHIP_TO_CUSTOMER, SHIP_TO_ADDRESS_LINE_1 SHIP_TO_ADDRESS_LINE_1, SHIP_TO_ADDRESS_LINE_2 SHIP_TO_ADDRESS_LINE_2, SHIP_TO_ADDRESS_LINE_3 SHIP_TO_ADDRESS_LINE_3, SHIP_TO_CONTACT SHIP_TO_CONTACT, INSTALL_TITLE INSTALL_TITLE, INSTALL_CUSTOMER INSTALL_CUSTOMER, INSTALL_ADDRESS_LINE_1 INSTALL_ADDRESS_LINE_1, INSTALL_ADDRESS_LINE_2 INSTALL_ADDRESS_LINE_2, INSTALL_ADDRESS_LINE_3 INSTALL_ADDRESS_LINE_3, INSTALL_SITE_USE_ID INSTALL_SITE_USE_ID, BILL_TO_CONTACT_ID BILL_TO_CONTACT_ID, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, INITIATING_NAME INITIATING_NAME, INITIATING_AREA_CODE INITIATING_AREA_CODE, INITIATING_TELEPHONE INITIATING_TELEPHONE, INITIATING_EXTENSION INITIATING_EXTENSION, INITIATING_FAX_AREA_CODE INITIATING_FAX_AREA_CODE, INITIATING_FAX_NUMBER INITIATING_FAX_NUMBER, PRODUCT_NAME PRODUCT_NAME, PRODUCT_DESCRIPTION PRODUCT_DESCRIPTION, CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER, PRODUCT_REVISION PRODUCT_REVISION, CUSTOMER_NUMBER CUSTOMER_NUMBER, SYSTEM_ID SYSTEM_ID, 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, RECORD_IS_VALID_FLAG RECORD_IS_VALID_FLAG, INCIDENT_COMMENTS INCIDENT_COMMENTS, RESOLUTION_CODE RESOLUTION_CODE, RMA_NUMBER RMA_NUMBER, RMA_HEADER_ID RMA_HEADER_ID, RMA_FLAG RMA_FLAG, ORG_ID ORG_ID, ORIGINAL_ORDER_NUMBER ORIGINAL_ORDER_NUMBER, WORKFLOW_PROCESS_ID WORKFLOW_PROCESS_ID, WEB_ENTRY_FLAG WEB_ENTRY_FLAG, CLOSE_DATE CLOSE_DATE, PUBLISH_FLAG PUBLISH_FLAG, MAKE_PUBLIC_PROBLEM MAKE_PUBLIC_PROBLEM, MAKE_PUBLIC_RESOLUTION MAKE_PUBLIC_RESOLUTION, ESTIMATE_ID ESTIMATE_ID, ESTIMATE_BUSINESS_GROUP_ID ESTIMATE_BUSINESS_GROUP_ID, INTERFACED_TO_DEPOT_FLAG INTERFACED_TO_DEPOT_FLAG, QA_COLLECTION_ID QA_COLLECTION_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, CONTRACT_ID CONTRACT_ID, CONTRACT_NUMBER CONTRACT_NUMBER, CONTRACT_SERVICE_ID CONTRACT_SERVICE_ID, RESOURCE_TYPE RESOURCE_TYPE, RESOURCE_SUBTYPE_ID RESOURCE_SUBTYPE_ID, ACCOUNT_ID ACCOUNT_ID, KB_TYPE KB_TYPE, KB_SOLUTION_ID KB_SOLUTION_ID, TIME_ZONE_ID TIME_ZONE_ID, TIME_DIFFERENCE TIME_DIFFERENCE, CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER, OWNER_GROUP_ID OWNER_GROUP_ID, CUSTOMER_TICKET_NUMBER CUSTOMER_TICKET_NUMBER, OBLIGATION_DATE OBLIGATION_DATE, SITE_ID SITE_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, CALLER_TYPE CALLER_TYPE, PLATFORM_VERSION_ID PLATFORM_VERSION_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CP_COMPONENT_ID CP_COMPONENT_ID, CP_COMPONENT_VERSION_ID CP_COMPONENT_VERSION_ID, CP_SUBCOMPONENT_ID CP_SUBCOMPONENT_ID, CP_SUBCOMPONENT_VERSION_ID CP_SUBCOMPONENT_VERSION_ID, PLATFORM_ID PLATFORM_ID, LANGUAGE_ID LANGUAGE_ID, TERRITORY_ID TERRITORY_ID, CP_REVISION_ID CP_REVISION_ID, INV_ITEM_REVISION INV_ITEM_REVISION, INV_COMPONENT_ID INV_COMPONENT_ID, INV_COMPONENT_VERSION INV_COMPONENT_VERSION, INV_SUBCOMPONENT_ID INV_SUBCOMPONENT_ID, INV_SUBCOMPONENT_VERSION INV_SUBCOMPONENT_VERSION, INV_ORGANIZATION_ID INV_ORGANIZATION_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, UPGRADED_STATUS_FLAG1 UPGRADED_STATUS_FLAG1, UPGRADED_STATUS_FLAG2 UPGRADED_STATUS_FLAG2, UPGRADED_STATUS_FLAG3 UPGRADED_STATUS_FLAG3, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, ORIG_SYSTEM_REFERENCE_ID ORIG_SYSTEM_REFERENCE_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROJECT_NUMBER PROJECT_NUMBER, PLATFORM_VERSION PLATFORM_VERSION, DB_VERSION DB_VERSION, CUST_PREF_LANG_ID CUST_PREF_LANG_ID, TIER TIER, TIER_VERSION TIER_VERSION, CATEGORY_ID CATEGORY_ID, OPERATING_SYSTEM OPERATING_SYSTEM, OPERATING_SYSTEM_VERSION OPERATING_SYSTEM_VERSION, DATABASE DATABASE, GROUP_TYPE GROUP_TYPE, GROUP_TERRITORY_ID GROUP_TERRITORY_ID, OWNER_ASSIGNED_TIME OWNER_ASSIGNED_TIME, OWNER_ASSIGNED_FLAG OWNER_ASSIGNED_FLAG, INV_PLATFORM_ORG_ID INV_PLATFORM_ORG_ID, COMPONENT_VERSION COMPONENT_VERSION, SUBCOMPONENT_VERSION SUBCOMPONENT_VERSION, COMM_PREF_CODE COMM_PREF_CODE, LAST_UPDATE_CHANNEL LAST_UPDATE_CHANNEL, CUST_PREF_LANG_CODE CUST_PREF_LANG_CODE, ERROR_CODE ERROR_CODE, CATEGORY_SET_ID CATEGORY_SET_ID, EXTERNAL_REFERENCE EXTERNAL_REFERENCE, INCIDENT_OCCURRED_DATE INCIDENT_OCCURRED_DATE, INCIDENT_RESOLVED_DATE INCIDENT_RESOLVED_DATE, INC_RESPONDED_BY_DATE INC_RESPONDED_BY_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, SR_CREATION_CHANNEL SR_CREATION_CHANNEL, DEF_DEFECT_ID DEF_DEFECT_ID, DEF_DEFECT_ID2 DEF_DEFECT_ID2, 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, 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, LAST_UPDATE_PROGRAM_CODE LAST_UPDATE_PROGRAM_CODE, CREATION_PROGRAM_CODE CREATION_PROGRAM_CODE, COVERAGE_TYPE COVERAGE_TYPE, BILL_TO_ACCOUNT_ID BILL_TO_ACCOUNT_ID, SHIP_TO_ACCOUNT_ID SHIP_TO_ACCOUNT_ID, CUSTOMER_EMAIL_ID CUSTOMER_EMAIL_ID, CUSTOMER_PHONE_ID CUSTOMER_PHONE_ID, BILL_TO_PARTY_ID BILL_TO_PARTY_ID, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID, BILL_TO_SITE_ID BILL_TO_SITE_ID, SHIP_TO_SITE_ID SHIP_TO_SITE_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, STATUS_FLAG STATUS_FLAG, PRIMARY_CONTACT_ID PRIMARY_CONTACT_ID, INCIDENT_POINT_OF_INTEREST INCIDENT_POINT_OF_INTEREST, INCIDENT_CROSS_STREET INCIDENT_CROSS_STREET, INCIDENT_DIRECTION_QUALIFIER INCIDENT_DIRECTION_QUALIFIER, INCIDENT_DISTANCE_QUALIFIER INCIDENT_DISTANCE_QUALIFIER, INCIDENT_DISTANCE_QUAL_UOM INCIDENT_DISTANCE_QUAL_UOM, INCIDENT_ADDRESS2 INCIDENT_ADDRESS2, INCIDENT_ADDRESS3 INCIDENT_ADDRESS3, INCIDENT_ADDRESS4 INCIDENT_ADDRESS4, INCIDENT_ADDRESS_STYLE INCIDENT_ADDRESS_STYLE, INCIDENT_ADDR_LINES_PHONETIC INCIDENT_ADDR_LINES_PHONETIC, INCIDENT_PO_BOX_NUMBER INCIDENT_PO_BOX_NUMBER, INCIDENT_HOUSE_NUMBER INCIDENT_HOUSE_NUMBER, INCIDENT_STREET_SUFFIX INCIDENT_STREET_SUFFIX, INCIDENT_STREET INCIDENT_STREET, INCIDENT_STREET_NUMBER INCIDENT_STREET_NUMBER, INCIDENT_FLOOR INCIDENT_FLOOR, INCIDENT_SUITE INCIDENT_SUITE, INCIDENT_POSTAL_PLUS4_CODE INCIDENT_POSTAL_PLUS4_CODE, INCIDENT_POSITION INCIDENT_POSITION, INCIDENT_LOCATION_DIRECTIONS INCIDENT_LOCATION_DIRECTIONS, INCIDENT_LOCATION_DESCRIPTION INCIDENT_LOCATION_DESCRIPTION, INSTALL_SITE_ID INSTALL_SITE_ID, OWNING_DEPARTMENT_ID OWNING_DEPARTMENT_ID, ITEM_SERIAL_NUMBER ITEM_SERIAL_NUMBER, INCIDENT_LOCATION_TYPE INCIDENT_LOCATION_TYPE, INCIDENT_LAST_MODIFIED_DATE INCIDENT_LAST_MODIFIED_DATE, UNASSIGNED_INDICATOR UNASSIGNED_INDICATOR, MAINT_ORGANIZATION_ID MAINT_ORGANIZATION_ID, INSTRUMENT_PAYMENT_USE_ID INSTRUMENT_PAYMENT_USE_ID, PROJECT_TASK_ID PROJECT_TASK_ID, SLA_DATE_1 SLA_DATE_1, SLA_DATE_2 SLA_DATE_2, SLA_DATE_3 SLA_DATE_3, SLA_DATE_4 SLA_DATE_4, SLA_DATE_5 SLA_DATE_5, SLA_DATE_6 SLA_DATE_6, SLA_DURATION_1 SLA_DURATION_1, SLA_DURATION_2 SLA_DURATION_2, PRICE_LIST_HEADER_ID PRICE_LIST_HEADER_ID, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID from "CS"."CS_INCIDENTS_ALL_B"

View Text - HTML Formatted

SELECT INCIDENT_ID INCIDENT_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_TIME CREATION_TIME
, INCIDENT_NUMBER INCIDENT_NUMBER
, INCIDENT_DATE INCIDENT_DATE
, OPEN_FLAG OPEN_FLAG
, SERVICE_ENTITY_ID SERVICE_ENTITY_ID
, INCIDENT_STATUS_ID INCIDENT_STATUS_ID
, INCIDENT_TYPE_ID INCIDENT_TYPE_ID
, INCIDENT_URGENCY_ID INCIDENT_URGENCY_ID
, INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID
, SUMMARY SUMMARY
, RESPONSIBLE_GROUP_ID RESPONSIBLE_GROUP_ID
, SECURITY_LEVEL_CODE SECURITY_LEVEL_CODE
, INCIDENT_OWNER_ID INCIDENT_OWNER_ID
, CLASSIFICATION_CODE CLASSIFICATION_CODE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, COMPONENT_INVENTORY_ITEM_ID COMPONENT_INVENTORY_ITEM_ID
, CUSTOMER_ID CUSTOMER_ID
, ORIGINAL_CUSTOMER_ID ORIGINAL_CUSTOMER_ID
, CUSTOMER_NAME CUSTOMER_NAME
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, PURCHASE_ORDER_NUM PURCHASE_ORDER_NUM
, IDENTIFICATION_NUMBER IDENTIFICATION_NUMBER
, SERVICE_INVENTORY_ITEM_ID SERVICE_INVENTORY_ITEM_ID
, EMPLOYEE_ID EMPLOYEE_ID
, FILED_BY_EMPLOYEE_FLAG FILED_BY_EMPLOYEE_FLAG
, BILLABLE_FLAG BILLABLE_FLAG
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, PROBLEM_CODE PROBLEM_CODE
, EXPECTED_RESOLUTION_DATE EXPECTED_RESOLUTION_DATE
, ACTUAL_RESOLUTION_DATE ACTUAL_RESOLUTION_DATE
, PROBLEM_DESCRIPTION PROBLEM_DESCRIPTION
, RESOLUTION_DESCRIPTION RESOLUTION_DESCRIPTION
, RUNNING_TOTALS RUNNING_TOTALS
, CURRENT_CONTACT_PERSON_ID CURRENT_CONTACT_PERSON_ID
, INITIATING_PERSON_ID INITIATING_PERSON_ID
, CURRENT_CONTACT_NAME CURRENT_CONTACT_NAME
, CURRENT_CONTACT_AREA_CODE CURRENT_CONTACT_AREA_CODE
, CURRENT_CONTACT_TELEPHONE CURRENT_CONTACT_TELEPHONE
, CURRENT_CONTACT_EXTENSION CURRENT_CONTACT_EXTENSION
, CURRENT_CONTACT_EMAIL_ADDRESS CURRENT_CONTACT_EMAIL_ADDRESS
, CURRENT_CONTACT_TIME_DIFF CURRENT_CONTACT_TIME_DIFF
, CURRENT_CONTACT_FAX_AREA_CODE CURRENT_CONTACT_FAX_AREA_CODE
, CURRENT_CONTACT_FAX_NUMBER CURRENT_CONTACT_FAX_NUMBER
, REPRESENTED_BY_EMPLOYEE REPRESENTED_BY_EMPLOYEE
, REPRESENTED_BY_NAME REPRESENTED_BY_NAME
, REPRESENTED_BY_TIME_DIFFERENCE REPRESENTED_BY_TIME_DIFFERENCE
, REPRESENTED_BY_AREA_CODE REPRESENTED_BY_AREA_CODE
, REPRESENTED_BY_TELEPHONE REPRESENTED_BY_TELEPHONE
, REPRESENTED_BY_EXTENSION REPRESENTED_BY_EXTENSION
, REPRESENTED_BY_FAX_AREA_CODE REPRESENTED_BY_FAX_AREA_CODE
, REPRESENTED_BY_FAX_NUMBER REPRESENTED_BY_FAX_NUMBER
, REPRESENTED_BY_EMAIL_ADDRESS REPRESENTED_BY_EMAIL_ADDRESS
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, INTERNAL_CONTACT_ID INTERNAL_CONTACT_ID
, HOURS_AFTER_GMT HOURS_AFTER_GMT
, INITIATING_TIME_DIFFERENCE INITIATING_TIME_DIFFERENCE
, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, CP_SERVICE_ID CP_SERVICE_ID
, CURRENTLY_SERVICED_FLAG CURRENTLY_SERVICED_FLAG
, LAST_CUSTOMER_CALLBACK_TIME LAST_CUSTOMER_CALLBACK_TIME
, PREVENTIVE_MAINTENANCE_FLAG PREVENTIVE_MAINTENANCE_FLAG
, BILL_TO_TITLE BILL_TO_TITLE
, BILL_TO_CUSTOMER BILL_TO_CUSTOMER
, BILL_TO_ADDRESS_LINE_1 BILL_TO_ADDRESS_LINE_1
, BILL_TO_ADDRESS_LINE_2 BILL_TO_ADDRESS_LINE_2
, BILL_TO_ADDRESS_LINE_3 BILL_TO_ADDRESS_LINE_3
, BILL_TO_CONTACT BILL_TO_CONTACT
, SHIP_TO_TITLE SHIP_TO_TITLE
, SHIP_TO_CUSTOMER SHIP_TO_CUSTOMER
, SHIP_TO_ADDRESS_LINE_1 SHIP_TO_ADDRESS_LINE_1
, SHIP_TO_ADDRESS_LINE_2 SHIP_TO_ADDRESS_LINE_2
, SHIP_TO_ADDRESS_LINE_3 SHIP_TO_ADDRESS_LINE_3
, SHIP_TO_CONTACT SHIP_TO_CONTACT
, INSTALL_TITLE INSTALL_TITLE
, INSTALL_CUSTOMER INSTALL_CUSTOMER
, INSTALL_ADDRESS_LINE_1 INSTALL_ADDRESS_LINE_1
, INSTALL_ADDRESS_LINE_2 INSTALL_ADDRESS_LINE_2
, INSTALL_ADDRESS_LINE_3 INSTALL_ADDRESS_LINE_3
, INSTALL_SITE_USE_ID INSTALL_SITE_USE_ID
, BILL_TO_CONTACT_ID BILL_TO_CONTACT_ID
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, INITIATING_NAME INITIATING_NAME
, INITIATING_AREA_CODE INITIATING_AREA_CODE
, INITIATING_TELEPHONE INITIATING_TELEPHONE
, INITIATING_EXTENSION INITIATING_EXTENSION
, INITIATING_FAX_AREA_CODE INITIATING_FAX_AREA_CODE
, INITIATING_FAX_NUMBER INITIATING_FAX_NUMBER
, PRODUCT_NAME PRODUCT_NAME
, PRODUCT_DESCRIPTION PRODUCT_DESCRIPTION
, CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER
, PRODUCT_REVISION PRODUCT_REVISION
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, SYSTEM_ID SYSTEM_ID
, 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
, RECORD_IS_VALID_FLAG RECORD_IS_VALID_FLAG
, INCIDENT_COMMENTS INCIDENT_COMMENTS
, RESOLUTION_CODE RESOLUTION_CODE
, RMA_NUMBER RMA_NUMBER
, RMA_HEADER_ID RMA_HEADER_ID
, RMA_FLAG RMA_FLAG
, ORG_ID ORG_ID
, ORIGINAL_ORDER_NUMBER ORIGINAL_ORDER_NUMBER
, WORKFLOW_PROCESS_ID WORKFLOW_PROCESS_ID
, WEB_ENTRY_FLAG WEB_ENTRY_FLAG
, CLOSE_DATE CLOSE_DATE
, PUBLISH_FLAG PUBLISH_FLAG
, MAKE_PUBLIC_PROBLEM MAKE_PUBLIC_PROBLEM
, MAKE_PUBLIC_RESOLUTION MAKE_PUBLIC_RESOLUTION
, ESTIMATE_ID ESTIMATE_ID
, ESTIMATE_BUSINESS_GROUP_ID ESTIMATE_BUSINESS_GROUP_ID
, INTERFACED_TO_DEPOT_FLAG INTERFACED_TO_DEPOT_FLAG
, QA_COLLECTION_ID QA_COLLECTION_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, CONTRACT_ID CONTRACT_ID
, CONTRACT_NUMBER CONTRACT_NUMBER
, CONTRACT_SERVICE_ID CONTRACT_SERVICE_ID
, RESOURCE_TYPE RESOURCE_TYPE
, RESOURCE_SUBTYPE_ID RESOURCE_SUBTYPE_ID
, ACCOUNT_ID ACCOUNT_ID
, KB_TYPE KB_TYPE
, KB_SOLUTION_ID KB_SOLUTION_ID
, TIME_ZONE_ID TIME_ZONE_ID
, TIME_DIFFERENCE TIME_DIFFERENCE
, CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER
, OWNER_GROUP_ID OWNER_GROUP_ID
, CUSTOMER_TICKET_NUMBER CUSTOMER_TICKET_NUMBER
, OBLIGATION_DATE OBLIGATION_DATE
, SITE_ID SITE_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, CALLER_TYPE CALLER_TYPE
, PLATFORM_VERSION_ID PLATFORM_VERSION_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CP_COMPONENT_ID CP_COMPONENT_ID
, CP_COMPONENT_VERSION_ID CP_COMPONENT_VERSION_ID
, CP_SUBCOMPONENT_ID CP_SUBCOMPONENT_ID
, CP_SUBCOMPONENT_VERSION_ID CP_SUBCOMPONENT_VERSION_ID
, PLATFORM_ID PLATFORM_ID
, LANGUAGE_ID LANGUAGE_ID
, TERRITORY_ID TERRITORY_ID
, CP_REVISION_ID CP_REVISION_ID
, INV_ITEM_REVISION INV_ITEM_REVISION
, INV_COMPONENT_ID INV_COMPONENT_ID
, INV_COMPONENT_VERSION INV_COMPONENT_VERSION
, INV_SUBCOMPONENT_ID INV_SUBCOMPONENT_ID
, INV_SUBCOMPONENT_VERSION INV_SUBCOMPONENT_VERSION
, INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, UPGRADED_STATUS_FLAG1 UPGRADED_STATUS_FLAG1
, UPGRADED_STATUS_FLAG2 UPGRADED_STATUS_FLAG2
, UPGRADED_STATUS_FLAG3 UPGRADED_STATUS_FLAG3
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, ORIG_SYSTEM_REFERENCE_ID ORIG_SYSTEM_REFERENCE_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROJECT_NUMBER PROJECT_NUMBER
, PLATFORM_VERSION PLATFORM_VERSION
, DB_VERSION DB_VERSION
, CUST_PREF_LANG_ID CUST_PREF_LANG_ID
, TIER TIER
, TIER_VERSION TIER_VERSION
, CATEGORY_ID CATEGORY_ID
, OPERATING_SYSTEM OPERATING_SYSTEM
, OPERATING_SYSTEM_VERSION OPERATING_SYSTEM_VERSION
, DATABASE DATABASE
, GROUP_TYPE GROUP_TYPE
, GROUP_TERRITORY_ID GROUP_TERRITORY_ID
, OWNER_ASSIGNED_TIME OWNER_ASSIGNED_TIME
, OWNER_ASSIGNED_FLAG OWNER_ASSIGNED_FLAG
, INV_PLATFORM_ORG_ID INV_PLATFORM_ORG_ID
, COMPONENT_VERSION COMPONENT_VERSION
, SUBCOMPONENT_VERSION SUBCOMPONENT_VERSION
, COMM_PREF_CODE COMM_PREF_CODE
, LAST_UPDATE_CHANNEL LAST_UPDATE_CHANNEL
, CUST_PREF_LANG_CODE CUST_PREF_LANG_CODE
, ERROR_CODE ERROR_CODE
, CATEGORY_SET_ID CATEGORY_SET_ID
, EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, INCIDENT_OCCURRED_DATE INCIDENT_OCCURRED_DATE
, INCIDENT_RESOLVED_DATE INCIDENT_RESOLVED_DATE
, INC_RESPONDED_BY_DATE INC_RESPONDED_BY_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
, SR_CREATION_CHANNEL SR_CREATION_CHANNEL
, DEF_DEFECT_ID DEF_DEFECT_ID
, DEF_DEFECT_ID2 DEF_DEFECT_ID2
, 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
, 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
, LAST_UPDATE_PROGRAM_CODE LAST_UPDATE_PROGRAM_CODE
, CREATION_PROGRAM_CODE CREATION_PROGRAM_CODE
, COVERAGE_TYPE COVERAGE_TYPE
, BILL_TO_ACCOUNT_ID BILL_TO_ACCOUNT_ID
, SHIP_TO_ACCOUNT_ID SHIP_TO_ACCOUNT_ID
, CUSTOMER_EMAIL_ID CUSTOMER_EMAIL_ID
, CUSTOMER_PHONE_ID CUSTOMER_PHONE_ID
, BILL_TO_PARTY_ID BILL_TO_PARTY_ID
, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID
, BILL_TO_SITE_ID BILL_TO_SITE_ID
, SHIP_TO_SITE_ID SHIP_TO_SITE_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, STATUS_FLAG STATUS_FLAG
, PRIMARY_CONTACT_ID PRIMARY_CONTACT_ID
, INCIDENT_POINT_OF_INTEREST INCIDENT_POINT_OF_INTEREST
, INCIDENT_CROSS_STREET INCIDENT_CROSS_STREET
, INCIDENT_DIRECTION_QUALIFIER INCIDENT_DIRECTION_QUALIFIER
, INCIDENT_DISTANCE_QUALIFIER INCIDENT_DISTANCE_QUALIFIER
, INCIDENT_DISTANCE_QUAL_UOM INCIDENT_DISTANCE_QUAL_UOM
, INCIDENT_ADDRESS2 INCIDENT_ADDRESS2
, INCIDENT_ADDRESS3 INCIDENT_ADDRESS3
, INCIDENT_ADDRESS4 INCIDENT_ADDRESS4
, INCIDENT_ADDRESS_STYLE INCIDENT_ADDRESS_STYLE
, INCIDENT_ADDR_LINES_PHONETIC INCIDENT_ADDR_LINES_PHONETIC
, INCIDENT_PO_BOX_NUMBER INCIDENT_PO_BOX_NUMBER
, INCIDENT_HOUSE_NUMBER INCIDENT_HOUSE_NUMBER
, INCIDENT_STREET_SUFFIX INCIDENT_STREET_SUFFIX
, INCIDENT_STREET INCIDENT_STREET
, INCIDENT_STREET_NUMBER INCIDENT_STREET_NUMBER
, INCIDENT_FLOOR INCIDENT_FLOOR
, INCIDENT_SUITE INCIDENT_SUITE
, INCIDENT_POSTAL_PLUS4_CODE INCIDENT_POSTAL_PLUS4_CODE
, INCIDENT_POSITION INCIDENT_POSITION
, INCIDENT_LOCATION_DIRECTIONS INCIDENT_LOCATION_DIRECTIONS
, INCIDENT_LOCATION_DESCRIPTION INCIDENT_LOCATION_DESCRIPTION
, INSTALL_SITE_ID INSTALL_SITE_ID
, OWNING_DEPARTMENT_ID OWNING_DEPARTMENT_ID
, ITEM_SERIAL_NUMBER ITEM_SERIAL_NUMBER
, INCIDENT_LOCATION_TYPE INCIDENT_LOCATION_TYPE
, INCIDENT_LAST_MODIFIED_DATE INCIDENT_LAST_MODIFIED_DATE
, UNASSIGNED_INDICATOR UNASSIGNED_INDICATOR
, MAINT_ORGANIZATION_ID MAINT_ORGANIZATION_ID
, INSTRUMENT_PAYMENT_USE_ID INSTRUMENT_PAYMENT_USE_ID
, PROJECT_TASK_ID PROJECT_TASK_ID
, SLA_DATE_1 SLA_DATE_1
, SLA_DATE_2 SLA_DATE_2
, SLA_DATE_3 SLA_DATE_3
, SLA_DATE_4 SLA_DATE_4
, SLA_DATE_5 SLA_DATE_5
, SLA_DATE_6 SLA_DATE_6
, SLA_DURATION_1 SLA_DURATION_1
, SLA_DURATION_2 SLA_DURATION_2
, PRICE_LIST_HEADER_ID PRICE_LIST_HEADER_ID
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
FROM "CS"."CS_INCIDENTS_ALL_B"