VIEW: APPS.CS_INCIDENTS_AUDIT_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID , B.INCIDENT_AUDIT_ID , B.INCIDENT_ID , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_LOGIN , B.CREATION_TIME , B.INCIDENT_STATUS_ID , B.OLD_INCIDENT_STATUS_ID , B.CHANGE_INCIDENT_STATUS_FLAG , B.INCIDENT_TYPE_ID , B.OLD_INCIDENT_TYPE_ID , B.CHANGE_INCIDENT_TYPE_FLAG , B.INCIDENT_URGENCY_ID , B.OLD_INCIDENT_URGENCY_ID , B.CHANGE_INCIDENT_URGENCY_FLAG , B.INCIDENT_SEVERITY_ID , B.OLD_INCIDENT_SEVERITY_ID , B.CHANGE_INCIDENT_SEVERITY_FLAG , B.RESPONSIBLE_GROUP_ID , B.OLD_RESPONSIBLE_GROUP_ID , B.CHANGE_RESPONSIBLE_GROUP_FLAG , B.INCIDENT_OWNER_ID , B.OLD_INCIDENT_OWNER_ID , B.CHANGE_INCIDENT_OWNER_FLAG , B.CREATE_MANUAL_ACTION , B.ACTION_ID , B.EXPECTED_RESOLUTION_DATE , B.OLD_EXPECTED_RESOLUTION_DATE , B.CHANGE_RESOLUTION_FLAG , B.WORKFLOW_PROCESS_NAME , B.WORKFLOW_PROCESS_ITEMKEY , B.NEW_WORKFLOW_FLAG , B.GROUP_ID , B.OLD_GROUP_ID , B.CHANGE_GROUP_FLAG , B.OBLIGATION_DATE , B.OLD_OBLIGATION_DATE , B.CHANGE_OBLIGATION_FLAG , B.SITE_ID , B.OLD_SITE_ID , B.CHANGE_SITE_FLAG , B.BILL_TO_CONTACT_ID , B.OLD_BILL_TO_CONTACT_ID , B.CHANGE_BILL_TO_FLAG , B.SHIP_TO_CONTACT_ID , B.OLD_SHIP_TO_CONTACT_ID , B.CHANGE_SHIP_TO_FLAG , B.INCIDENT_DATE , B.OLD_INCIDENT_DATE , B.CHANGE_INCIDENT_DATE_FLAG , B.CLOSE_DATE , B.OLD_CLOSE_DATE , B.CHANGE_CLOSE_DATE_FLAG , B.CUSTOMER_PRODUCT_ID , B.OLD_CUSTOMER_PRODUCT_ID , B.CHANGE_CUSTOMER_PRODUCT_FLAG , B.AUDIT_FIELD , B.PLATFORM_ID , B.OLD_PLATFORM_ID , B.CHANGE_PLATFORM_ID_FLAG , B.PLATFORM_VERSION_ID , B.OLD_PLATFORM_VERSION_ID , B.CHANGE_PLAT_VER_ID_FLAG , B.LANGUAGE_ID , B.OLD_LANGUAGE_ID , B.CHANGE_LANGUAGE_ID_FLAG , B.TERRITORY_ID , B.OLD_TERRITORY_ID , B.CHANGE_TERRITORY_ID_FLAG , B.CP_COMPONENT_ID , B.OLD_CP_COMPONENT_ID , B.CHANGE_CP_COMPONENT_ID_FLAG , B.CP_COMPONENT_VERSION_ID , B.OLD_CP_COMPONENT_VERSION_ID , B.CHANGE_CP_COMP_VER_ID_FLAG , B.CP_SUBCOMPONENT_ID , B.OLD_CP_SUBCOMPONENT_ID , B.CHANGE_CP_SUBCOMPONENT_ID_FLAG , B.CP_SUBCOMPONENT_VERSION_ID , B.OLD_CP_SUBCOMPONENT_VERSION_ID , B.CHANGE_CP_SUBCOMP_VER_ID_FLAG , B.CP_REVISION_ID , B.OLD_CP_REVISION_ID , B.CHANGE_CP_REVISION_ID_FLAG , B.INV_ITEM_REVISION , B.OLD_INV_ITEM_REVISION , B.CHANGE_INV_ITEM_REVISION , B.INV_COMPONENT_ID , B.OLD_INV_COMPONENT_ID , B.CHANGE_INV_COMPONENT_ID , B.INV_COMPONENT_VERSION , B.OLD_INV_COMPONENT_VERSION , B.CHANGE_INV_COMPONENT_VERSION , B.INV_SUBCOMPONENT_ID , B.OLD_INV_SUBCOMPONENT_ID , B.CHANGE_INV_SUBCOMPONENT_ID , B.INV_SUBCOMPONENT_VERSION , B.OLD_INV_SUBCOMPONENT_VERSION , B.CHANGE_INV_SUBCOMP_VERSION , B.RESOURCE_TYPE , B.OLD_RESOURCE_TYPE , B.CHANGE_RESOURCE_TYPE_FLAG , T.CHANGE_DESCRIPTION , T.LANGUAGE , T.SOURCE_LANG, B.GROUP_TYPE, B.OLD_GROUP_TYPE, B.CHANGE_GROUP_TYPE_FLAG, B.OWNER_ASSIGNED_TIME, B.OLD_OWNER_ASSIGNED_TIME, B.CHANGE_ASSIGNED_TIME_FLAG, B.INV_PLATFORM_ORG_ID, B.OLD_INV_PLATFORM_ORG_ID, B.CHANGE_PLATFORM_ORG_ID_FLAG, B.COMPONENT_VERSION, B.OLD_COMPONENT_VERSION, B.CHANGE_COMP_VER_FLAG, B.SUBCOMPONENT_VERSION, B.OLD_SUBCOMPONENT_VERSION, B.CHANGE_SUBCOMP_VER_FLAG, B.PRODUCT_REVISION, B.OLD_PRODUCT_REVISION, B.CHANGE_PRODUCT_REVISION_FLAG , B.STATUS_FLAG, B.OLD_STATUS_FLAG, B.CHANGE_STATUS_FLAG, B.INVENTORY_ITEM_ID, B.OLD_INVENTORY_ITEM_ID, B.CHANGE_INVENTORY_ITEM_FLAG, B.INV_ORGANIZATION_ID, B.OLD_INV_ORGANIZATION_ID, B.CHANGE_INV_ORGANIZATION_FLAG, B.PRIMARY_CONTACT_ID, B.OLD_PRIMARY_CONTACT_ID, B.CHANGE_PRIMARY_CONTACT_FLAG, b.OLD_INCIDENT_NUMBER , b.INCIDENT_NUMBER , b.OLD_CUSTOMER_ID , b.CUSTOMER_ID , b.OLD_BILL_TO_SITE_USE_ID , b.BILL_TO_SITE_USE_ID , b.OLD_EMPLOYEE_ID , b.EMPLOYEE_ID , b.OLD_SHIP_TO_SITE_USE_ID , b.SHIP_TO_SITE_USE_ID , b.OLD_PROBLEM_CODE , b.PROBLEM_CODE , b.OLD_ACTUAL_RESOLUTION_DATE , b.ACTUAL_RESOLUTION_DATE , b.OLD_INSTALL_SITE_USE_ID , b.INSTALL_SITE_USE_ID , b.OLD_CURRENT_SERIAL_NUMBER , b.CURRENT_SERIAL_NUMBER , b.OLD_SYSTEM_ID , b.SYSTEM_ID , b.OLD_INCIDENT_ATTRIBUTE_1 , b.INCIDENT_ATTRIBUTE_1 , b.OLD_INCIDENT_ATTRIBUTE_2 , b.INCIDENT_ATTRIBUTE_2 , b.OLD_INCIDENT_ATTRIBUTE_3 , b.INCIDENT_ATTRIBUTE_3 , b.OLD_INCIDENT_ATTRIBUTE_4 , b.INCIDENT_ATTRIBUTE_4 , b.OLD_INCIDENT_ATTRIBUTE_5 , b.INCIDENT_ATTRIBUTE_5 , b.OLD_INCIDENT_ATTRIBUTE_6 , b.INCIDENT_ATTRIBUTE_6 , b.OLD_INCIDENT_ATTRIBUTE_7 , b.INCIDENT_ATTRIBUTE_7 , b.OLD_INCIDENT_ATTRIBUTE_8 , b.INCIDENT_ATTRIBUTE_8 , b.OLD_INCIDENT_ATTRIBUTE_9 , b.INCIDENT_ATTRIBUTE_9 , b.OLD_INCIDENT_ATTRIBUTE_10 , b.INCIDENT_ATTRIBUTE_10 , b.OLD_INCIDENT_ATTRIBUTE_11 , b.INCIDENT_ATTRIBUTE_11 , b.OLD_INCIDENT_ATTRIBUTE_12 , b.INCIDENT_ATTRIBUTE_12 , b.OLD_INCIDENT_ATTRIBUTE_13 , b.INCIDENT_ATTRIBUTE_13 , b.OLD_INCIDENT_ATTRIBUTE_14 , b.INCIDENT_ATTRIBUTE_14 , b.OLD_INCIDENT_ATTRIBUTE_15 , b.INCIDENT_ATTRIBUTE_15 , b.OLD_INCIDENT_CONTEXT , b.INCIDENT_CONTEXT , b.OLD_RESOLUTION_CODE , b.RESOLUTION_CODE , b.OLD_ORIGINAL_ORDER_NUMBER , b.ORIGINAL_ORDER_NUMBER , b.OLD_ORG_ID , b.ORG_ID , b.OLD_PURCHASE_ORDER_NUMBER , b.PURCHASE_ORDER_NUMBER , b.OLD_PUBLISH_FLAG , b.PUBLISH_FLAG , b.OLD_QA_COLLECTION_ID , b.QA_COLLECTION_ID , b.OLD_CONTRACT_ID , b.CONTRACT_ID , b.OLD_CONTRACT_NUMBER , b.CONTRACT_NUMBER , b.OLD_CONTRACT_SERVICE_ID , b.CONTRACT_SERVICE_ID , b.OLD_TIME_ZONE_ID , b.TIME_ZONE_ID , b.OLD_ACCOUNT_ID , b.ACCOUNT_ID , b.OLD_TIME_DIFFERENCE , b.TIME_DIFFERENCE , b.OLD_CUSTOMER_PO_NUMBER , b.CUSTOMER_PO_NUMBER , b.OLD_CUSTOMER_TICKET_NUMBER , b.CUSTOMER_TICKET_NUMBER , b.OLD_CUSTOMER_SITE_ID , b.CUSTOMER_SITE_ID , b.OLD_CALLER_TYPE , b.CALLER_TYPE , b.OLD_INC_OBJECT_VERSION_NUMBER , b.INC_OBJECT_VERSION_NUMBER , b.OBJECT_VERSION_NUMBER , b.OLD_SECURITY_GROUP_ID , b.SECURITY_GROUP_ID , b.OLD_ORIG_SYSTEM_REFERENCE , b.ORIG_SYSTEM_REFERENCE , b.OLD_ORIG_SYSTEM_REFERENCE_ID , b.ORIG_SYSTEM_REFERENCE_ID , b.OLD_INC_REQUEST_ID , b.INC_REQUEST_ID , b.REQUEST_ID , b.OLD_INC_PROGRAM_APPLICATION_ID , b.INC_PROGRAM_APPLICATION_ID , b.PROGRAM_APPLICATION_ID , b.OLD_INC_PROGRAM_ID , b.INC_PROGRAM_ID , b.PROGRAM_ID , b.OLD_INC_PROGRAM_UPDATE_DATE , b.INC_PROGRAM_UPDATE_DATE , b.PROGRAM_UPDATE_DATE , b.OLD_PROJECT_NUMBER , b.PROJECT_NUMBER , b.OLD_PLATFORM_VERSION , b.PLATFORM_VERSION , b.OLD_DB_VERSION , b.DB_VERSION , b.OLD_CUST_PREF_LANG_ID , b.CUST_PREF_LANG_ID , b.OLD_TIER , b.TIER , b.OLD_TIER_VERSION, b.TIER_VERSION, b.OLD_CATEGORY_ID , b.CATEGORY_ID , b.OLD_OPERATING_SYSTEM , b.OPERATING_SYSTEM , b.OLD_OPERATING_SYSTEM_VERSION , b.OPERATING_SYSTEM_VERSION , b.OLD_DATABASE , b.DATABASE , b.OLD_GROUP_TERRITORY_ID , b.GROUP_TERRITORY_ID , b.OLD_COMM_PREF_CODE , b.COMM_PREF_CODE , b.OLD_LAST_UPDATE_CHANNEL , b.LAST_UPDATE_CHANNEL , b.OLD_CUST_PREF_LANG_CODE , b.CUST_PREF_LANG_CODE , b.OLD_ERROR_CODE , b.ERROR_CODE , b.OLD_CATEGORY_SET_ID , b.CATEGORY_SET_ID , b.OLD_EXTERNAL_REFERENCE , b.EXTERNAL_REFERENCE , b.OLD_INCIDENT_OCCURRED_DATE , b.INCIDENT_OCCURRED_DATE , b.OLD_INCIDENT_RESOLVED_DATE , b.INCIDENT_RESOLVED_DATE , b.OLD_INC_RESPONDED_BY_DATE , b.INC_RESPONDED_BY_DATE , b.OLD_INCIDENT_LOCATION_ID , b.INCIDENT_LOCATION_ID , b.OLD_INCIDENT_ADDRESS , b.INCIDENT_ADDRESS , b.OLD_INCIDENT_CITY , b.INCIDENT_CITY , b.OLD_INCIDENT_STATE , b.INCIDENT_STATE , b.OLD_INCIDENT_COUNTRY , b.INCIDENT_COUNTRY , b.OLD_INCIDENT_PROVINCE , b.INCIDENT_PROVINCE , b.OLD_INCIDENT_POSTAL_CODE , b.INCIDENT_POSTAL_CODE , b.OLD_INCIDENT_COUNTY , b.INCIDENT_COUNTY , b.OLD_SR_CREATION_CHANNEL , b.SR_CREATION_CHANNEL , b.OLD_DEF_DEFECT_ID , b.DEF_DEFECT_ID , b.OLD_DEF_DEFECT_ID2 , b.DEF_DEFECT_ID2 , b.OLD_CREDIT_CARD_NUMBER , b.CREDIT_CARD_NUMBER , b.OLD_CREDIT_CARD_TYPE_CODE , b.CREDIT_CARD_TYPE_CODE , b.OLD_CREDIT_CARD_EXPIRATION_DT , b.CREDIT_CARD_EXPIRATION_DT , b.OLD_CREDIT_CARD_HOLDER_FNAME , b.CREDIT_CARD_HOLDER_FNAME , b.OLD_CREDIT_CARD_HOLDER_MNAME , b.CREDIT_CARD_HOLDER_MNAME , b.OLD_CREDIT_CARD_HOLDER_LNAME , b.CREDIT_CARD_HOLDER_LNAME , b.OLD_CREDIT_CARD_ID , b.CREDIT_CARD_ID , b.OLD_EXTERNAL_ATTRIBUTE_1 , b.EXTERNAL_ATTRIBUTE_1 , b.OLD_EXTERNAL_ATTRIBUTE_2 , b.EXTERNAL_ATTRIBUTE_2 , b.OLD_EXTERNAL_ATTRIBUTE_3 , b.EXTERNAL_ATTRIBUTE_3 , b.OLD_EXTERNAL_ATTRIBUTE_4 , b.EXTERNAL_ATTRIBUTE_4 , b.OLD_EXTERNAL_ATTRIBUTE_5 , b.EXTERNAL_ATTRIBUTE_5 , b.OLD_EXTERNAL_ATTRIBUTE_6 , b.EXTERNAL_ATTRIBUTE_6 , b.OLD_EXTERNAL_ATTRIBUTE_7 , b.EXTERNAL_ATTRIBUTE_7 , b.OLD_EXTERNAL_ATTRIBUTE_8 , b.EXTERNAL_ATTRIBUTE_8 , b.OLD_EXTERNAL_ATTRIBUTE_9 , b.EXTERNAL_ATTRIBUTE_9 , b.OLD_EXTERNAL_ATTRIBUTE_10 , b.EXTERNAL_ATTRIBUTE_10 , b.OLD_EXTERNAL_ATTRIBUTE_11 , b.EXTERNAL_ATTRIBUTE_11 , b.OLD_EXTERNAL_ATTRIBUTE_12 , b.EXTERNAL_ATTRIBUTE_12 , b.OLD_EXTERNAL_ATTRIBUTE_13 , b.EXTERNAL_ATTRIBUTE_13 , b.OLD_EXTERNAL_ATTRIBUTE_14 , b.EXTERNAL_ATTRIBUTE_14 , b.OLD_EXTERNAL_ATTRIBUTE_15 , b.EXTERNAL_ATTRIBUTE_15 , b.OLD_EXTERNAL_CONTEXT , b.EXTERNAL_CONTEXT , b.OLD_LAST_UPDATE_PROGRAM_CODE , b.LAST_UPDATE_PROGRAM_CODE , b.OLD_CREATION_PROGRAM_CODE , b.CREATION_PROGRAM_CODE , b.OLD_COVERAGE_TYPE , b.COVERAGE_TYPE , b.OLD_BILL_TO_ACCOUNT_ID , b.BILL_TO_ACCOUNT_ID , b.OLD_SHIP_TO_ACCOUNT_ID , b.SHIP_TO_ACCOUNT_ID , b.OLD_CUSTOMER_EMAIL_ID , b.CUSTOMER_EMAIL_ID , b.OLD_CUSTOMER_PHONE_ID , b.CUSTOMER_PHONE_ID , b.OLD_BILL_TO_PARTY_ID , b.BILL_TO_PARTY_ID , b.OLD_SHIP_TO_PARTY_ID , b.SHIP_TO_PARTY_ID , b.OLD_BILL_TO_SITE_ID , b.BILL_TO_SITE_ID , b.OLD_SHIP_TO_SITE_ID , b.SHIP_TO_SITE_ID , b.OLD_PROGRAM_LOGIN_ID , b.PROGRAM_LOGIN_ID , b.OLD_INCIDENT_POINT_OF_INTEREST , b.INCIDENT_POINT_OF_INTEREST , b.OLD_INCIDENT_CROSS_STREET , b.INCIDENT_CROSS_STREET , b.OLD_INCIDENT_DIRECTION_QUALIF , b.INCIDENT_DIRECTION_QUALIF , b.OLD_INCIDENT_DISTANCE_QUALIF , b.INCIDENT_DISTANCE_QUALIF , b.OLD_INCIDENT_DISTANCE_QUAL_UOM , b.INCIDENT_DISTANCE_QUAL_UOM , b.OLD_INCIDENT_ADDRESS2 , b.INCIDENT_ADDRESS2 , b.OLD_INCIDENT_ADDRESS3 , b.INCIDENT_ADDRESS3 , b.OLD_INCIDENT_ADDRESS4 , b.INCIDENT_ADDRESS4 , b.OLD_INCIDENT_ADDRESS_STYLE , b.INCIDENT_ADDRESS_STYLE , b.OLD_INCIDENT_ADDR_LNS_PHONETIC , b.INCIDENT_ADDR_LNS_PHONETIC , b.OLD_INCIDENT_PO_BOX_NUMBER , b.INCIDENT_PO_BOX_NUMBER , b.OLD_INCIDENT_HOUSE_NUMBER , b.INCIDENT_HOUSE_NUMBER , b.OLD_INCIDENT_STREET_SUFFIX , b.INCIDENT_STREET_SUFFIX , b.OLD_INCIDENT_STREET , b.INCIDENT_STREET , b.OLD_INCIDENT_STREET_NUMBER , b.INCIDENT_STREET_NUMBER , b.OLD_INCIDENT_FLOOR , b.INCIDENT_FLOOR , b.OLD_INCIDENT_SUITE , b.INCIDENT_SUITE , b.OLD_INCIDENT_POSTAL_PLUS4_CODE , b.INCIDENT_POSTAL_PLUS4_CODE , b.OLD_INCIDENT_POSITION , b.INCIDENT_POSITION , b.OLD_INCIDENT_LOC_DIRECTIONS , b.INCIDENT_LOC_DIRECTIONS , b.OLD_INCIDENT_LOC_DESCRIPTION , b.INCIDENT_LOC_DESCRIPTION , b.OLD_INSTALL_SITE_ID , b.INSTALL_SITE_ID , b.INCIDENT_LAST_MODIFIED_DATE , b.UPDATED_ENTITY_CODE , b.UPDATED_ENTITY_ID , b.ENTITY_ACTIVITY_CODE , b.OLD_OWNING_DEPARTMENT_ID , b.OWNING_DEPARTMENT_ID , b.OLD_ITEM_SERIAL_NUMBER , b.ITEM_SERIAL_NUMBER , b.OLD_INCIDENT_LOCATION_TYPE , b.INCIDENT_LOCATION_TYPE , b.OLD_UNASSIGNED_INDICATOR, b.UNASSIGNED_INDICATOR, b.OLD_OWNER_ASSIGNED_FLAG, b.OWNER_ASSIGNED_FLAG, b.old_maint_organization_id, b.maint_organization_id, b.old_project_id, b.project_id, b.old_project_task_id, b.project_Task_id, b.old_price_list_header_id, b.price_list_header_id, b.old_sla_date_1, b.sla_date_1, b.old_sla_date_2, b.sla_date_2, b.old_sla_date_3, b.sla_date_3, b.old_sla_date_4, b.sla_date_4, b.old_sla_date_5, b.sla_date_5, b.old_sla_date_6, b.sla_date_6, b.old_sla_duration_1, b.sla_duration_1, b.old_sla_duration_2, b.sla_duration_2, b.old_EXPENDITURE_ORG_ID, b.EXPENDITURE_ORG_ID, b.change_sla_date_1_flag, b.change_sla_date_2_flag, b.change_sla_date_3_flag, b.change_sla_date_4_flag, b.change_sla_date_5_flag, b.change_sla_date_6_flag, b.change_sla_duration_1_flag, b.change_sla_duration_2_flag FROM CS_INCIDENTS_AUDIT_B B, CS_INCIDENTS_AUDIT_TL T WHERE B.INCIDENT_AUDIT_ID=T.INCIDENT_AUDIT_ID AND T.LANGUAGE=userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.INCIDENT_AUDIT_ID
, B.INCIDENT_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATION_TIME
, B.INCIDENT_STATUS_ID
, B.OLD_INCIDENT_STATUS_ID
, B.CHANGE_INCIDENT_STATUS_FLAG
, B.INCIDENT_TYPE_ID
, B.OLD_INCIDENT_TYPE_ID
, B.CHANGE_INCIDENT_TYPE_FLAG
, B.INCIDENT_URGENCY_ID
, B.OLD_INCIDENT_URGENCY_ID
, B.CHANGE_INCIDENT_URGENCY_FLAG
, B.INCIDENT_SEVERITY_ID
, B.OLD_INCIDENT_SEVERITY_ID
, B.CHANGE_INCIDENT_SEVERITY_FLAG
, B.RESPONSIBLE_GROUP_ID
, B.OLD_RESPONSIBLE_GROUP_ID
, B.CHANGE_RESPONSIBLE_GROUP_FLAG
, B.INCIDENT_OWNER_ID
, B.OLD_INCIDENT_OWNER_ID
, B.CHANGE_INCIDENT_OWNER_FLAG
, B.CREATE_MANUAL_ACTION
, B.ACTION_ID
, B.EXPECTED_RESOLUTION_DATE
, B.OLD_EXPECTED_RESOLUTION_DATE
, B.CHANGE_RESOLUTION_FLAG
, B.WORKFLOW_PROCESS_NAME
, B.WORKFLOW_PROCESS_ITEMKEY
, B.NEW_WORKFLOW_FLAG
, B.GROUP_ID
, B.OLD_GROUP_ID
, B.CHANGE_GROUP_FLAG
, B.OBLIGATION_DATE
, B.OLD_OBLIGATION_DATE
, B.CHANGE_OBLIGATION_FLAG
, B.SITE_ID
, B.OLD_SITE_ID
, B.CHANGE_SITE_FLAG
, B.BILL_TO_CONTACT_ID
, B.OLD_BILL_TO_CONTACT_ID
, B.CHANGE_BILL_TO_FLAG
, B.SHIP_TO_CONTACT_ID
, B.OLD_SHIP_TO_CONTACT_ID
, B.CHANGE_SHIP_TO_FLAG
, B.INCIDENT_DATE
, B.OLD_INCIDENT_DATE
, B.CHANGE_INCIDENT_DATE_FLAG
, B.CLOSE_DATE
, B.OLD_CLOSE_DATE
, B.CHANGE_CLOSE_DATE_FLAG
, B.CUSTOMER_PRODUCT_ID
, B.OLD_CUSTOMER_PRODUCT_ID
, B.CHANGE_CUSTOMER_PRODUCT_FLAG
, B.AUDIT_FIELD
, B.PLATFORM_ID
, B.OLD_PLATFORM_ID
, B.CHANGE_PLATFORM_ID_FLAG
, B.PLATFORM_VERSION_ID
, B.OLD_PLATFORM_VERSION_ID
, B.CHANGE_PLAT_VER_ID_FLAG
, B.LANGUAGE_ID
, B.OLD_LANGUAGE_ID
, B.CHANGE_LANGUAGE_ID_FLAG
, B.TERRITORY_ID
, B.OLD_TERRITORY_ID
, B.CHANGE_TERRITORY_ID_FLAG
, B.CP_COMPONENT_ID
, B.OLD_CP_COMPONENT_ID
, B.CHANGE_CP_COMPONENT_ID_FLAG
, B.CP_COMPONENT_VERSION_ID
, B.OLD_CP_COMPONENT_VERSION_ID
, B.CHANGE_CP_COMP_VER_ID_FLAG
, B.CP_SUBCOMPONENT_ID
, B.OLD_CP_SUBCOMPONENT_ID
, B.CHANGE_CP_SUBCOMPONENT_ID_FLAG
, B.CP_SUBCOMPONENT_VERSION_ID
, B.OLD_CP_SUBCOMPONENT_VERSION_ID
, B.CHANGE_CP_SUBCOMP_VER_ID_FLAG
, B.CP_REVISION_ID
, B.OLD_CP_REVISION_ID
, B.CHANGE_CP_REVISION_ID_FLAG
, B.INV_ITEM_REVISION
, B.OLD_INV_ITEM_REVISION
, B.CHANGE_INV_ITEM_REVISION
, B.INV_COMPONENT_ID
, B.OLD_INV_COMPONENT_ID
, B.CHANGE_INV_COMPONENT_ID
, B.INV_COMPONENT_VERSION
, B.OLD_INV_COMPONENT_VERSION
, B.CHANGE_INV_COMPONENT_VERSION
, B.INV_SUBCOMPONENT_ID
, B.OLD_INV_SUBCOMPONENT_ID
, B.CHANGE_INV_SUBCOMPONENT_ID
, B.INV_SUBCOMPONENT_VERSION
, B.OLD_INV_SUBCOMPONENT_VERSION
, B.CHANGE_INV_SUBCOMP_VERSION
, B.RESOURCE_TYPE
, B.OLD_RESOURCE_TYPE
, B.CHANGE_RESOURCE_TYPE_FLAG
, T.CHANGE_DESCRIPTION
, T.LANGUAGE
, T.SOURCE_LANG
, B.GROUP_TYPE
, B.OLD_GROUP_TYPE
, B.CHANGE_GROUP_TYPE_FLAG
, B.OWNER_ASSIGNED_TIME
, B.OLD_OWNER_ASSIGNED_TIME
, B.CHANGE_ASSIGNED_TIME_FLAG
, B.INV_PLATFORM_ORG_ID
, B.OLD_INV_PLATFORM_ORG_ID
, B.CHANGE_PLATFORM_ORG_ID_FLAG
, B.COMPONENT_VERSION
, B.OLD_COMPONENT_VERSION
, B.CHANGE_COMP_VER_FLAG
, B.SUBCOMPONENT_VERSION
, B.OLD_SUBCOMPONENT_VERSION
, B.CHANGE_SUBCOMP_VER_FLAG
, B.PRODUCT_REVISION
, B.OLD_PRODUCT_REVISION
, B.CHANGE_PRODUCT_REVISION_FLAG
, B.STATUS_FLAG
, B.OLD_STATUS_FLAG
, B.CHANGE_STATUS_FLAG
, B.INVENTORY_ITEM_ID
, B.OLD_INVENTORY_ITEM_ID
, B.CHANGE_INVENTORY_ITEM_FLAG
, B.INV_ORGANIZATION_ID
, B.OLD_INV_ORGANIZATION_ID
, B.CHANGE_INV_ORGANIZATION_FLAG
, B.PRIMARY_CONTACT_ID
, B.OLD_PRIMARY_CONTACT_ID
, B.CHANGE_PRIMARY_CONTACT_FLAG
, B.OLD_INCIDENT_NUMBER
, B.INCIDENT_NUMBER
, B.OLD_CUSTOMER_ID
, B.CUSTOMER_ID
, B.OLD_BILL_TO_SITE_USE_ID
, B.BILL_TO_SITE_USE_ID
, B.OLD_EMPLOYEE_ID
, B.EMPLOYEE_ID
, B.OLD_SHIP_TO_SITE_USE_ID
, B.SHIP_TO_SITE_USE_ID
, B.OLD_PROBLEM_CODE
, B.PROBLEM_CODE
, B.OLD_ACTUAL_RESOLUTION_DATE
, B.ACTUAL_RESOLUTION_DATE
, B.OLD_INSTALL_SITE_USE_ID
, B.INSTALL_SITE_USE_ID
, B.OLD_CURRENT_SERIAL_NUMBER
, B.CURRENT_SERIAL_NUMBER
, B.OLD_SYSTEM_ID
, B.SYSTEM_ID
, B.OLD_INCIDENT_ATTRIBUTE_1
, B.INCIDENT_ATTRIBUTE_1
, B.OLD_INCIDENT_ATTRIBUTE_2
, B.INCIDENT_ATTRIBUTE_2
, B.OLD_INCIDENT_ATTRIBUTE_3
, B.INCIDENT_ATTRIBUTE_3
, B.OLD_INCIDENT_ATTRIBUTE_4
, B.INCIDENT_ATTRIBUTE_4
, B.OLD_INCIDENT_ATTRIBUTE_5
, B.INCIDENT_ATTRIBUTE_5
, B.OLD_INCIDENT_ATTRIBUTE_6
, B.INCIDENT_ATTRIBUTE_6
, B.OLD_INCIDENT_ATTRIBUTE_7
, B.INCIDENT_ATTRIBUTE_7
, B.OLD_INCIDENT_ATTRIBUTE_8
, B.INCIDENT_ATTRIBUTE_8
, B.OLD_INCIDENT_ATTRIBUTE_9
, B.INCIDENT_ATTRIBUTE_9
, B.OLD_INCIDENT_ATTRIBUTE_10
, B.INCIDENT_ATTRIBUTE_10
, B.OLD_INCIDENT_ATTRIBUTE_11
, B.INCIDENT_ATTRIBUTE_11
, B.OLD_INCIDENT_ATTRIBUTE_12
, B.INCIDENT_ATTRIBUTE_12
, B.OLD_INCIDENT_ATTRIBUTE_13
, B.INCIDENT_ATTRIBUTE_13
, B.OLD_INCIDENT_ATTRIBUTE_14
, B.INCIDENT_ATTRIBUTE_14
, B.OLD_INCIDENT_ATTRIBUTE_15
, B.INCIDENT_ATTRIBUTE_15
, B.OLD_INCIDENT_CONTEXT
, B.INCIDENT_CONTEXT
, B.OLD_RESOLUTION_CODE
, B.RESOLUTION_CODE
, B.OLD_ORIGINAL_ORDER_NUMBER
, B.ORIGINAL_ORDER_NUMBER
, B.OLD_ORG_ID
, B.ORG_ID
, B.OLD_PURCHASE_ORDER_NUMBER
, B.PURCHASE_ORDER_NUMBER
, B.OLD_PUBLISH_FLAG
, B.PUBLISH_FLAG
, B.OLD_QA_COLLECTION_ID
, B.QA_COLLECTION_ID
, B.OLD_CONTRACT_ID
, B.CONTRACT_ID
, B.OLD_CONTRACT_NUMBER
, B.CONTRACT_NUMBER
, B.OLD_CONTRACT_SERVICE_ID
, B.CONTRACT_SERVICE_ID
, B.OLD_TIME_ZONE_ID
, B.TIME_ZONE_ID
, B.OLD_ACCOUNT_ID
, B.ACCOUNT_ID
, B.OLD_TIME_DIFFERENCE
, B.TIME_DIFFERENCE
, B.OLD_CUSTOMER_PO_NUMBER
, B.CUSTOMER_PO_NUMBER
, B.OLD_CUSTOMER_TICKET_NUMBER
, B.CUSTOMER_TICKET_NUMBER
, B.OLD_CUSTOMER_SITE_ID
, B.CUSTOMER_SITE_ID
, B.OLD_CALLER_TYPE
, B.CALLER_TYPE
, B.OLD_INC_OBJECT_VERSION_NUMBER
, B.INC_OBJECT_VERSION_NUMBER
, B.OBJECT_VERSION_NUMBER
, B.OLD_SECURITY_GROUP_ID
, B.SECURITY_GROUP_ID
, B.OLD_ORIG_SYSTEM_REFERENCE
, B.ORIG_SYSTEM_REFERENCE
, B.OLD_ORIG_SYSTEM_REFERENCE_ID
, B.ORIG_SYSTEM_REFERENCE_ID
, B.OLD_INC_REQUEST_ID
, B.INC_REQUEST_ID
, B.REQUEST_ID
, B.OLD_INC_PROGRAM_APPLICATION_ID
, B.INC_PROGRAM_APPLICATION_ID
, B.PROGRAM_APPLICATION_ID
, B.OLD_INC_PROGRAM_ID
, B.INC_PROGRAM_ID
, B.PROGRAM_ID
, B.OLD_INC_PROGRAM_UPDATE_DATE
, B.INC_PROGRAM_UPDATE_DATE
, B.PROGRAM_UPDATE_DATE
, B.OLD_PROJECT_NUMBER
, B.PROJECT_NUMBER
, B.OLD_PLATFORM_VERSION
, B.PLATFORM_VERSION
, B.OLD_DB_VERSION
, B.DB_VERSION
, B.OLD_CUST_PREF_LANG_ID
, B.CUST_PREF_LANG_ID
, B.OLD_TIER
, B.TIER
, B.OLD_TIER_VERSION
, B.TIER_VERSION
, B.OLD_CATEGORY_ID
, B.CATEGORY_ID
, B.OLD_OPERATING_SYSTEM
, B.OPERATING_SYSTEM
, B.OLD_OPERATING_SYSTEM_VERSION
, B.OPERATING_SYSTEM_VERSION
, B.OLD_DATABASE
, B.DATABASE
, B.OLD_GROUP_TERRITORY_ID
, B.GROUP_TERRITORY_ID
, B.OLD_COMM_PREF_CODE
, B.COMM_PREF_CODE
, B.OLD_LAST_UPDATE_CHANNEL
, B.LAST_UPDATE_CHANNEL
, B.OLD_CUST_PREF_LANG_CODE
, B.CUST_PREF_LANG_CODE
, B.OLD_ERROR_CODE
, B.ERROR_CODE
, B.OLD_CATEGORY_SET_ID
, B.CATEGORY_SET_ID
, B.OLD_EXTERNAL_REFERENCE
, B.EXTERNAL_REFERENCE
, B.OLD_INCIDENT_OCCURRED_DATE
, B.INCIDENT_OCCURRED_DATE
, B.OLD_INCIDENT_RESOLVED_DATE
, B.INCIDENT_RESOLVED_DATE
, B.OLD_INC_RESPONDED_BY_DATE
, B.INC_RESPONDED_BY_DATE
, B.OLD_INCIDENT_LOCATION_ID
, B.INCIDENT_LOCATION_ID
, B.OLD_INCIDENT_ADDRESS
, B.INCIDENT_ADDRESS
, B.OLD_INCIDENT_CITY
, B.INCIDENT_CITY
, B.OLD_INCIDENT_STATE
, B.INCIDENT_STATE
, B.OLD_INCIDENT_COUNTRY
, B.INCIDENT_COUNTRY
, B.OLD_INCIDENT_PROVINCE
, B.INCIDENT_PROVINCE
, B.OLD_INCIDENT_POSTAL_CODE
, B.INCIDENT_POSTAL_CODE
, B.OLD_INCIDENT_COUNTY
, B.INCIDENT_COUNTY
, B.OLD_SR_CREATION_CHANNEL
, B.SR_CREATION_CHANNEL
, B.OLD_DEF_DEFECT_ID
, B.DEF_DEFECT_ID
, B.OLD_DEF_DEFECT_ID2
, B.DEF_DEFECT_ID2
, B.OLD_CREDIT_CARD_NUMBER
, B.CREDIT_CARD_NUMBER
, B.OLD_CREDIT_CARD_TYPE_CODE
, B.CREDIT_CARD_TYPE_CODE
, B.OLD_CREDIT_CARD_EXPIRATION_DT
, B.CREDIT_CARD_EXPIRATION_DT
, B.OLD_CREDIT_CARD_HOLDER_FNAME
, B.CREDIT_CARD_HOLDER_FNAME
, B.OLD_CREDIT_CARD_HOLDER_MNAME
, B.CREDIT_CARD_HOLDER_MNAME
, B.OLD_CREDIT_CARD_HOLDER_LNAME
, B.CREDIT_CARD_HOLDER_LNAME
, B.OLD_CREDIT_CARD_ID
, B.CREDIT_CARD_ID
, B.OLD_EXTERNAL_ATTRIBUTE_1
, B.EXTERNAL_ATTRIBUTE_1
, B.OLD_EXTERNAL_ATTRIBUTE_2
, B.EXTERNAL_ATTRIBUTE_2
, B.OLD_EXTERNAL_ATTRIBUTE_3
, B.EXTERNAL_ATTRIBUTE_3
, B.OLD_EXTERNAL_ATTRIBUTE_4
, B.EXTERNAL_ATTRIBUTE_4
, B.OLD_EXTERNAL_ATTRIBUTE_5
, B.EXTERNAL_ATTRIBUTE_5
, B.OLD_EXTERNAL_ATTRIBUTE_6
, B.EXTERNAL_ATTRIBUTE_6
, B.OLD_EXTERNAL_ATTRIBUTE_7
, B.EXTERNAL_ATTRIBUTE_7
, B.OLD_EXTERNAL_ATTRIBUTE_8
, B.EXTERNAL_ATTRIBUTE_8
, B.OLD_EXTERNAL_ATTRIBUTE_9
, B.EXTERNAL_ATTRIBUTE_9
, B.OLD_EXTERNAL_ATTRIBUTE_10
, B.EXTERNAL_ATTRIBUTE_10
, B.OLD_EXTERNAL_ATTRIBUTE_11
, B.EXTERNAL_ATTRIBUTE_11
, B.OLD_EXTERNAL_ATTRIBUTE_12
, B.EXTERNAL_ATTRIBUTE_12
, B.OLD_EXTERNAL_ATTRIBUTE_13
, B.EXTERNAL_ATTRIBUTE_13
, B.OLD_EXTERNAL_ATTRIBUTE_14
, B.EXTERNAL_ATTRIBUTE_14
, B.OLD_EXTERNAL_ATTRIBUTE_15
, B.EXTERNAL_ATTRIBUTE_15
, B.OLD_EXTERNAL_CONTEXT
, B.EXTERNAL_CONTEXT
, B.OLD_LAST_UPDATE_PROGRAM_CODE
, B.LAST_UPDATE_PROGRAM_CODE
, B.OLD_CREATION_PROGRAM_CODE
, B.CREATION_PROGRAM_CODE
, B.OLD_COVERAGE_TYPE
, B.COVERAGE_TYPE
, B.OLD_BILL_TO_ACCOUNT_ID
, B.BILL_TO_ACCOUNT_ID
, B.OLD_SHIP_TO_ACCOUNT_ID
, B.SHIP_TO_ACCOUNT_ID
, B.OLD_CUSTOMER_EMAIL_ID
, B.CUSTOMER_EMAIL_ID
, B.OLD_CUSTOMER_PHONE_ID
, B.CUSTOMER_PHONE_ID
, B.OLD_BILL_TO_PARTY_ID
, B.BILL_TO_PARTY_ID
, B.OLD_SHIP_TO_PARTY_ID
, B.SHIP_TO_PARTY_ID
, B.OLD_BILL_TO_SITE_ID
, B.BILL_TO_SITE_ID
, B.OLD_SHIP_TO_SITE_ID
, B.SHIP_TO_SITE_ID
, B.OLD_PROGRAM_LOGIN_ID
, B.PROGRAM_LOGIN_ID
, B.OLD_INCIDENT_POINT_OF_INTEREST
, B.INCIDENT_POINT_OF_INTEREST
, B.OLD_INCIDENT_CROSS_STREET
, B.INCIDENT_CROSS_STREET
, B.OLD_INCIDENT_DIRECTION_QUALIF
, B.INCIDENT_DIRECTION_QUALIF
, B.OLD_INCIDENT_DISTANCE_QUALIF
, B.INCIDENT_DISTANCE_QUALIF
, B.OLD_INCIDENT_DISTANCE_QUAL_UOM
, B.INCIDENT_DISTANCE_QUAL_UOM
, B.OLD_INCIDENT_ADDRESS2
, B.INCIDENT_ADDRESS2
, B.OLD_INCIDENT_ADDRESS3
, B.INCIDENT_ADDRESS3
, B.OLD_INCIDENT_ADDRESS4
, B.INCIDENT_ADDRESS4
, B.OLD_INCIDENT_ADDRESS_STYLE
, B.INCIDENT_ADDRESS_STYLE
, B.OLD_INCIDENT_ADDR_LNS_PHONETIC
, B.INCIDENT_ADDR_LNS_PHONETIC
, B.OLD_INCIDENT_PO_BOX_NUMBER
, B.INCIDENT_PO_BOX_NUMBER
, B.OLD_INCIDENT_HOUSE_NUMBER
, B.INCIDENT_HOUSE_NUMBER
, B.OLD_INCIDENT_STREET_SUFFIX
, B.INCIDENT_STREET_SUFFIX
, B.OLD_INCIDENT_STREET
, B.INCIDENT_STREET
, B.OLD_INCIDENT_STREET_NUMBER
, B.INCIDENT_STREET_NUMBER
, B.OLD_INCIDENT_FLOOR
, B.INCIDENT_FLOOR
, B.OLD_INCIDENT_SUITE
, B.INCIDENT_SUITE
, B.OLD_INCIDENT_POSTAL_PLUS4_CODE
, B.INCIDENT_POSTAL_PLUS4_CODE
, B.OLD_INCIDENT_POSITION
, B.INCIDENT_POSITION
, B.OLD_INCIDENT_LOC_DIRECTIONS
, B.INCIDENT_LOC_DIRECTIONS
, B.OLD_INCIDENT_LOC_DESCRIPTION
, B.INCIDENT_LOC_DESCRIPTION
, B.OLD_INSTALL_SITE_ID
, B.INSTALL_SITE_ID
, B.INCIDENT_LAST_MODIFIED_DATE
, B.UPDATED_ENTITY_CODE
, B.UPDATED_ENTITY_ID
, B.ENTITY_ACTIVITY_CODE
, B.OLD_OWNING_DEPARTMENT_ID
, B.OWNING_DEPARTMENT_ID
, B.OLD_ITEM_SERIAL_NUMBER
, B.ITEM_SERIAL_NUMBER
, B.OLD_INCIDENT_LOCATION_TYPE
, B.INCIDENT_LOCATION_TYPE
, B.OLD_UNASSIGNED_INDICATOR
, B.UNASSIGNED_INDICATOR
, B.OLD_OWNER_ASSIGNED_FLAG
, B.OWNER_ASSIGNED_FLAG
, B.OLD_MAINT_ORGANIZATION_ID
, B.MAINT_ORGANIZATION_ID
, B.OLD_PROJECT_ID
, B.PROJECT_ID
, B.OLD_PROJECT_TASK_ID
, B.PROJECT_TASK_ID
, B.OLD_PRICE_LIST_HEADER_ID
, B.PRICE_LIST_HEADER_ID
, B.OLD_SLA_DATE_1
, B.SLA_DATE_1
, B.OLD_SLA_DATE_2
, B.SLA_DATE_2
, B.OLD_SLA_DATE_3
, B.SLA_DATE_3
, B.OLD_SLA_DATE_4
, B.SLA_DATE_4
, B.OLD_SLA_DATE_5
, B.SLA_DATE_5
, B.OLD_SLA_DATE_6
, B.SLA_DATE_6
, B.OLD_SLA_DURATION_1
, B.SLA_DURATION_1
, B.OLD_SLA_DURATION_2
, B.SLA_DURATION_2
, B.OLD_EXPENDITURE_ORG_ID
, B.EXPENDITURE_ORG_ID
, B.CHANGE_SLA_DATE_1_FLAG
, B.CHANGE_SLA_DATE_2_FLAG
, B.CHANGE_SLA_DATE_3_FLAG
, B.CHANGE_SLA_DATE_4_FLAG
, B.CHANGE_SLA_DATE_5_FLAG
, B.CHANGE_SLA_DATE_6_FLAG
, B.CHANGE_SLA_DURATION_1_FLAG
, B.CHANGE_SLA_DURATION_2_FLAG
FROM CS_INCIDENTS_AUDIT_B B
, CS_INCIDENTS_AUDIT_TL T
WHERE B.INCIDENT_AUDIT_ID=T.INCIDENT_AUDIT_ID
AND T.LANGUAGE=USERENV('LANG')