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.

VIEW: APPS.CS_INCIDENTS_B_SEC

Source

View Text - Preformatted


SELECT
  B.INCIDENT_ID ,
  B.LAST_UPDATE_DATE ,
  B.LAST_UPDATED_BY ,
  B.CREATION_DATE ,
  B.CREATED_BY ,
  B.LAST_UPDATE_LOGIN ,
  B.INCIDENT_NUMBER ,
  B.INCIDENT_DATE ,
  B.INCIDENT_STATUS_ID ,
  B.INCIDENT_TYPE_ID ,
  B.INCIDENT_URGENCY_ID ,
  B.INCIDENT_SEVERITY_ID ,
  B.INCIDENT_OWNER_ID ,
  B.RESOURCE_TYPE ,
  B.RESOURCE_SUBTYPE_ID ,
  B.INVENTORY_ITEM_ID ,
  B.CUSTOMER_ID ,
  B.ACCOUNT_ID ,
  B.BILL_TO_SITE_USE_ID ,
  B.PURCHASE_ORDER_NUM ,
  B.EMPLOYEE_ID ,
  B.FILED_BY_EMPLOYEE_FLAG ,
  B.SHIP_TO_SITE_USE_ID ,
  B.PROBLEM_CODE ,
  B.EXPECTED_RESOLUTION_DATE ,
  B.ACTUAL_RESOLUTION_DATE ,
  B.CUSTOMER_PRODUCT_ID ,
  B.INSTALL_SITE_USE_ID ,
  B.BILL_TO_CONTACT_ID ,
  B.SHIP_TO_CONTACT_ID ,
  B.CURRENT_SERIAL_NUMBER ,
  B.CUSTOMER_NUMBER ,
  B.SYSTEM_ID ,
  B.INCIDENT_ATTRIBUTE_1 ,
  B.INCIDENT_ATTRIBUTE_2 ,
  B.INCIDENT_ATTRIBUTE_3 ,
  B.INCIDENT_ATTRIBUTE_4 ,
  B.INCIDENT_ATTRIBUTE_5 ,
  B.INCIDENT_ATTRIBUTE_6 ,
  B.INCIDENT_ATTRIBUTE_7 ,
  B.INCIDENT_ATTRIBUTE_8 ,
  B.INCIDENT_ATTRIBUTE_9 ,
  B.INCIDENT_ATTRIBUTE_10 ,
  B.INCIDENT_ATTRIBUTE_11 ,
  B.INCIDENT_ATTRIBUTE_12 ,
  B.INCIDENT_ATTRIBUTE_13 ,
  B.INCIDENT_ATTRIBUTE_14 ,
  B.INCIDENT_ATTRIBUTE_15 ,
  B.INCIDENT_CONTEXT ,
  B.RECORD_IS_VALID_FLAG ,
  B.RESOLUTION_CODE ,
  B.ORG_ID ,
  B.ORIGINAL_ORDER_NUMBER ,
  B.WORKFLOW_PROCESS_ID ,
  B.CLOSE_DATE ,
  B.PUBLISH_FLAG ,
  B.INTERFACED_TO_DEPOT_FLAG ,
  B.QA_COLLECTION_ID ,
  B.CONTRACT_SERVICE_ID ,
  B.KB_TYPE ,
  B.KB_SOLUTION_ID ,
  B.TIME_ZONE_ID ,
  B.TIME_DIFFERENCE ,
  B.CUSTOMER_PO_NUMBER ,
  B.OWNER_GROUP_ID ,
  B.CUSTOMER_TICKET_NUMBER ,
  B.OBLIGATION_DATE ,
  B.SITE_ID ,
  B.CUSTOMER_SITE_ID ,
  B.CALLER_TYPE ,
  B.PLATFORM_VERSION_ID ,
  B.OBJECT_VERSION_NUMBER ,
  B.SR_CREATION_CHANNEL ,
  B.CP_COMPONENT_ID ,
  B.CP_COMPONENT_VERSION_ID ,
  B.CP_SUBCOMPONENT_ID ,
  B.CP_SUBCOMPONENT_VERSION_ID ,
  B.CP_REVISION_ID ,
  B.INV_ITEM_REVISION ,
  B.INV_COMPONENT_ID ,
  B.INV_COMPONENT_VERSION ,
  B.INV_SUBCOMPONENT_ID ,
  B.INV_SUBCOMPONENT_VERSION ,
  B.INV_ORGANIZATION_ID ,
  B.PLATFORM_ID ,
  B.LANGUAGE_ID ,
  B.TERRITORY_ID ,
  B.CONTRACT_NUMBER ,
  B.CONTRACT_ID ,
  B.PROJECT_NUMBER ,
  B.CUST_PREF_LANG_ID ,
  B.PLATFORM_VERSION ,
  B.TIER ,
  B.TIER_VERSION ,
  B.CATEGORY_ID ,
  B.OPERATING_SYSTEM ,
  B.OPERATING_SYSTEM_VERSION ,
  B.DATABASE ,
  B.DB_VERSION ,
  B.GROUP_TYPE ,
  B.INV_PLATFORM_ORG_ID ,
  B.PRODUCT_REVISION ,
  B.COMPONENT_VERSION ,
  B.SUBCOMPONENT_VERSION ,
  B.COMM_PREF_CODE ,
  B.LAST_UPDATE_CHANNEL ,
  B.CUST_PREF_LANG_CODE ,
  B.ERROR_CODE ,
  B.CATEGORY_SET_ID ,
  B.EXTERNAL_REFERENCE ,
  B.INCIDENT_OCCURRED_DATE ,
  B.INCIDENT_RESOLVED_DATE ,
  B.INC_RESPONDED_BY_DATE ,
  B.INCIDENT_LOCATION_ID ,
  B.INCIDENT_ADDRESS ,
  B.INCIDENT_CITY ,
  B.INCIDENT_STATE ,
  B.INCIDENT_COUNTRY ,
  B.INCIDENT_PROVINCE ,
  B.INCIDENT_POSTAL_CODE ,
  B.INCIDENT_COUNTY ,
  B.CREDIT_CARD_NUMBER ,
  B.CREDIT_CARD_TYPE_CODE ,
  B.CREDIT_CARD_EXPIRATION_DATE ,
  B.CREDIT_CARD_HOLDER_FNAME ,
  B.CREDIT_CARD_HOLDER_MNAME ,
  B.CREDIT_CARD_HOLDER_LNAME ,
  B.CREDIT_CARD_ID ,
  B.EXTERNAL_ATTRIBUTE_1 ,
  B.EXTERNAL_ATTRIBUTE_2 ,
  B.EXTERNAL_ATTRIBUTE_3 ,
  B.EXTERNAL_ATTRIBUTE_4 ,
  B.EXTERNAL_ATTRIBUTE_5 ,
  B.EXTERNAL_ATTRIBUTE_6 ,
  B.EXTERNAL_ATTRIBUTE_7 ,
  B.EXTERNAL_ATTRIBUTE_8 ,
  B.EXTERNAL_ATTRIBUTE_9 ,
  B.EXTERNAL_ATTRIBUTE_10 ,
  B.EXTERNAL_ATTRIBUTE_11 ,
  B.EXTERNAL_ATTRIBUTE_12 ,
  B.EXTERNAL_ATTRIBUTE_13 ,
  B.EXTERNAL_ATTRIBUTE_14 ,
  B.EXTERNAL_ATTRIBUTE_15 ,
  B.EXTERNAL_CONTEXT ,
  B.CUSTOMER_PHONE_ID ,
  B.CUSTOMER_EMAIL_ID ,
  B.BILL_TO_ACCOUNT_ID ,
  B.SHIP_TO_ACCOUNT_ID ,
  B.BILL_TO_PARTY_ID ,
  B.SHIP_TO_PARTY_ID ,
  B.BILL_TO_SITE_ID ,
  B.SHIP_TO_SITE_ID ,
  B.COVERAGE_TYPE ,
  B.PROGRAM_LOGIN_ID ,
  B.STATUS_FLAG ,
  B.PRIMARY_CONTACT_ID ,
  B.LAST_UPDATE_PROGRAM_CODE ,
  B.CREATION_PROGRAM_CODE ,
  B.INCIDENT_POINT_OF_INTEREST ,
  B.INCIDENT_CROSS_STREET ,
  B.INCIDENT_DIRECTION_QUALIFIER ,
  B.INCIDENT_DISTANCE_QUALIFIER ,
  B.INCIDENT_DISTANCE_QUAL_UOM ,
  B.INCIDENT_ADDRESS2 ,
  B.INCIDENT_ADDRESS3 ,
  B.INCIDENT_ADDRESS4 ,
  B.INCIDENT_ADDRESS_STYLE ,
  B.INCIDENT_ADDR_LINES_PHONETIC ,
  B.INCIDENT_PO_BOX_NUMBER ,
  B.INCIDENT_HOUSE_NUMBER ,
  B.INCIDENT_STREET_SUFFIX ,
  B.INCIDENT_STREET ,
  B.INCIDENT_STREET_NUMBER ,
  B.INCIDENT_FLOOR ,
  B.INCIDENT_SUITE ,
  B.INCIDENT_POSTAL_PLUS4_CODE ,
  B.INCIDENT_POSITION ,
  B.INCIDENT_LOCATION_DIRECTIONS ,
  B.INCIDENT_LOCATION_DESCRIPTION ,
  B.INSTALL_SITE_ID ,
  B.INCIDENT_LOCATION_TYPE ,
  B.ITEM_SERIAL_NUMBER ,
  B.OWNING_DEPARTMENT_ID ,
  B.INCIDENT_LAST_MODIFIED_DATE ,
  B.UNASSIGNED_INDICATOR ,
  B.ESTIMATE_ID ,
  B.ESTIMATE_BUSINESS_GROUP_ID ,
  B.GROUP_TERRITORY_ID ,
  B.OWNER_ASSIGNED_TIME ,
  B.OWNER_ASSIGNED_FLAG ,
  B.MAINT_ORGANIZATION_ID,
  b.instrument_payment_use_id,
  b.project_task_id, 
  b.project_id,
  B.SLA_DATE_1,
  B.SLA_DATE_2,
  B.SLA_DATE_3,
  B.SLA_DATE_4,
  B.SLA_DATE_5,
  B.SLA_DATE_6,
  B.SLA_DURATION_1,
  B.SLA_DURATION_2,
  B.EXPENDITURE_ORG_ID,
  B.PRICE_LIST_HEADER_ID
FROM
  CS_INCIDENTS_ALL_B b

View Text - HTML Formatted

SELECT B.INCIDENT_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.INCIDENT_NUMBER
, B.INCIDENT_DATE
, B.INCIDENT_STATUS_ID
, B.INCIDENT_TYPE_ID
, B.INCIDENT_URGENCY_ID
, B.INCIDENT_SEVERITY_ID
, B.INCIDENT_OWNER_ID
, B.RESOURCE_TYPE
, B.RESOURCE_SUBTYPE_ID
, B.INVENTORY_ITEM_ID
, B.CUSTOMER_ID
, B.ACCOUNT_ID
, B.BILL_TO_SITE_USE_ID
, B.PURCHASE_ORDER_NUM
, B.EMPLOYEE_ID
, B.FILED_BY_EMPLOYEE_FLAG
, B.SHIP_TO_SITE_USE_ID
, B.PROBLEM_CODE
, B.EXPECTED_RESOLUTION_DATE
, B.ACTUAL_RESOLUTION_DATE
, B.CUSTOMER_PRODUCT_ID
, B.INSTALL_SITE_USE_ID
, B.BILL_TO_CONTACT_ID
, B.SHIP_TO_CONTACT_ID
, B.CURRENT_SERIAL_NUMBER
, B.CUSTOMER_NUMBER
, B.SYSTEM_ID
, B.INCIDENT_ATTRIBUTE_1
, B.INCIDENT_ATTRIBUTE_2
, B.INCIDENT_ATTRIBUTE_3
, B.INCIDENT_ATTRIBUTE_4
, B.INCIDENT_ATTRIBUTE_5
, B.INCIDENT_ATTRIBUTE_6
, B.INCIDENT_ATTRIBUTE_7
, B.INCIDENT_ATTRIBUTE_8
, B.INCIDENT_ATTRIBUTE_9
, B.INCIDENT_ATTRIBUTE_10
, B.INCIDENT_ATTRIBUTE_11
, B.INCIDENT_ATTRIBUTE_12
, B.INCIDENT_ATTRIBUTE_13
, B.INCIDENT_ATTRIBUTE_14
, B.INCIDENT_ATTRIBUTE_15
, B.INCIDENT_CONTEXT
, B.RECORD_IS_VALID_FLAG
, B.RESOLUTION_CODE
, B.ORG_ID
, B.ORIGINAL_ORDER_NUMBER
, B.WORKFLOW_PROCESS_ID
, B.CLOSE_DATE
, B.PUBLISH_FLAG
, B.INTERFACED_TO_DEPOT_FLAG
, B.QA_COLLECTION_ID
, B.CONTRACT_SERVICE_ID
, B.KB_TYPE
, B.KB_SOLUTION_ID
, B.TIME_ZONE_ID
, B.TIME_DIFFERENCE
, B.CUSTOMER_PO_NUMBER
, B.OWNER_GROUP_ID
, B.CUSTOMER_TICKET_NUMBER
, B.OBLIGATION_DATE
, B.SITE_ID
, B.CUSTOMER_SITE_ID
, B.CALLER_TYPE
, B.PLATFORM_VERSION_ID
, B.OBJECT_VERSION_NUMBER
, B.SR_CREATION_CHANNEL
, B.CP_COMPONENT_ID
, B.CP_COMPONENT_VERSION_ID
, B.CP_SUBCOMPONENT_ID
, B.CP_SUBCOMPONENT_VERSION_ID
, B.CP_REVISION_ID
, B.INV_ITEM_REVISION
, B.INV_COMPONENT_ID
, B.INV_COMPONENT_VERSION
, B.INV_SUBCOMPONENT_ID
, B.INV_SUBCOMPONENT_VERSION
, B.INV_ORGANIZATION_ID
, B.PLATFORM_ID
, B.LANGUAGE_ID
, B.TERRITORY_ID
, B.CONTRACT_NUMBER
, B.CONTRACT_ID
, B.PROJECT_NUMBER
, B.CUST_PREF_LANG_ID
, B.PLATFORM_VERSION
, B.TIER
, B.TIER_VERSION
, B.CATEGORY_ID
, B.OPERATING_SYSTEM
, B.OPERATING_SYSTEM_VERSION
, B.DATABASE
, B.DB_VERSION
, B.GROUP_TYPE
, B.INV_PLATFORM_ORG_ID
, B.PRODUCT_REVISION
, B.COMPONENT_VERSION
, B.SUBCOMPONENT_VERSION
, B.COMM_PREF_CODE
, B.LAST_UPDATE_CHANNEL
, B.CUST_PREF_LANG_CODE
, B.ERROR_CODE
, B.CATEGORY_SET_ID
, B.EXTERNAL_REFERENCE
, B.INCIDENT_OCCURRED_DATE
, B.INCIDENT_RESOLVED_DATE
, B.INC_RESPONDED_BY_DATE
, B.INCIDENT_LOCATION_ID
, B.INCIDENT_ADDRESS
, B.INCIDENT_CITY
, B.INCIDENT_STATE
, B.INCIDENT_COUNTRY
, B.INCIDENT_PROVINCE
, B.INCIDENT_POSTAL_CODE
, B.INCIDENT_COUNTY
, B.CREDIT_CARD_NUMBER
, B.CREDIT_CARD_TYPE_CODE
, B.CREDIT_CARD_EXPIRATION_DATE
, B.CREDIT_CARD_HOLDER_FNAME
, B.CREDIT_CARD_HOLDER_MNAME
, B.CREDIT_CARD_HOLDER_LNAME
, B.CREDIT_CARD_ID
, B.EXTERNAL_ATTRIBUTE_1
, B.EXTERNAL_ATTRIBUTE_2
, B.EXTERNAL_ATTRIBUTE_3
, B.EXTERNAL_ATTRIBUTE_4
, B.EXTERNAL_ATTRIBUTE_5
, B.EXTERNAL_ATTRIBUTE_6
, B.EXTERNAL_ATTRIBUTE_7
, B.EXTERNAL_ATTRIBUTE_8
, B.EXTERNAL_ATTRIBUTE_9
, B.EXTERNAL_ATTRIBUTE_10
, B.EXTERNAL_ATTRIBUTE_11
, B.EXTERNAL_ATTRIBUTE_12
, B.EXTERNAL_ATTRIBUTE_13
, B.EXTERNAL_ATTRIBUTE_14
, B.EXTERNAL_ATTRIBUTE_15
, B.EXTERNAL_CONTEXT
, B.CUSTOMER_PHONE_ID
, B.CUSTOMER_EMAIL_ID
, B.BILL_TO_ACCOUNT_ID
, B.SHIP_TO_ACCOUNT_ID
, B.BILL_TO_PARTY_ID
, B.SHIP_TO_PARTY_ID
, B.BILL_TO_SITE_ID
, B.SHIP_TO_SITE_ID
, B.COVERAGE_TYPE
, B.PROGRAM_LOGIN_ID
, B.STATUS_FLAG
, B.PRIMARY_CONTACT_ID
, B.LAST_UPDATE_PROGRAM_CODE
, B.CREATION_PROGRAM_CODE
, B.INCIDENT_POINT_OF_INTEREST
, B.INCIDENT_CROSS_STREET
, B.INCIDENT_DIRECTION_QUALIFIER
, B.INCIDENT_DISTANCE_QUALIFIER
, B.INCIDENT_DISTANCE_QUAL_UOM
, B.INCIDENT_ADDRESS2
, B.INCIDENT_ADDRESS3
, B.INCIDENT_ADDRESS4
, B.INCIDENT_ADDRESS_STYLE
, B.INCIDENT_ADDR_LINES_PHONETIC
, B.INCIDENT_PO_BOX_NUMBER
, B.INCIDENT_HOUSE_NUMBER
, B.INCIDENT_STREET_SUFFIX
, B.INCIDENT_STREET
, B.INCIDENT_STREET_NUMBER
, B.INCIDENT_FLOOR
, B.INCIDENT_SUITE
, B.INCIDENT_POSTAL_PLUS4_CODE
, B.INCIDENT_POSITION
, B.INCIDENT_LOCATION_DIRECTIONS
, B.INCIDENT_LOCATION_DESCRIPTION
, B.INSTALL_SITE_ID
, B.INCIDENT_LOCATION_TYPE
, B.ITEM_SERIAL_NUMBER
, B.OWNING_DEPARTMENT_ID
, B.INCIDENT_LAST_MODIFIED_DATE
, B.UNASSIGNED_INDICATOR
, B.ESTIMATE_ID
, B.ESTIMATE_BUSINESS_GROUP_ID
, B.GROUP_TERRITORY_ID
, B.OWNER_ASSIGNED_TIME
, B.OWNER_ASSIGNED_FLAG
, B.MAINT_ORGANIZATION_ID
, B.INSTRUMENT_PAYMENT_USE_ID
, B.PROJECT_TASK_ID
, B.PROJECT_ID
, B.SLA_DATE_1
, B.SLA_DATE_2
, B.SLA_DATE_3
, B.SLA_DATE_4
, B.SLA_DATE_5
, B.SLA_DATE_6
, B.SLA_DURATION_1
, B.SLA_DURATION_2
, B.EXPENDITURE_ORG_ID
, B.PRICE_LIST_HEADER_ID FROM CS_INCIDENTS_ALL_B B