VIEW: APPS.CS_INCIDENTS_DIARY_V

Source

View Text - Preformatted

SELECT 'NOTES' source_type, INC.incident_id, INC.last_update_date incident_date, FU.USER_NAME OWNER, NOTES.JTF_NOTE_ID action_id, NOTES.last_update_date last_update_date, NOTES.NOTES Details, NOTES.NOTE_STATUS, null severity_old, null severity_new, NULL INCIDENT_SEVERITY_FLAG, null type_old, null type_new, NULL INCIDENT_TYPE_FLAG, null status_old, null status_new, NULL INCIDENT_STATUS_FLAG, null urgency_old, null urgency_new, NULL INCIDENT_URGENCY_FLAG, null group_old, null group_new, NULL RESPONSIBLE_GROUP_FLAG, null owner_old, null owner_new, NULL INCIDENT_OWNER_FLAG, null date_old, null date_new, NULL RESOLUTION_date_FLAG, null obligation_date_old, null obligation_date_new, NULL OBLIGATION_DATE_FLAG, null site_id_new, null site_id_old, NULL SITE_FLAG, null bill_to_contact_id_new, null bill_to_contact_id_old, NULL BILL_TO_FLAG, null ship_to_contact_id_new, null ship_to_contact_id_old, NULL SHIP_TO_FLAG, null platform_id_new, null platform_id_old, NULL PLATFORM_ID_FLAG, null platform_version_id_new, null platform_version_id_old, NULL PLAT_VER_ID_FLAG, null customer_product_id_new, null customer_product_id_old, NULL CUSTOMER_PRODUCT_FLAG, null language_id_new, null language_id_old, NULL LANGUAGE_ID_FLAG , null old_severity_name , null new_severity_name , null old_type_name , null new_type_name , null old_status_name , null new_status_name , null old_urgency_name , null new_urgency_name , null old_owner , null new_owner , null old_bill_to_contact_name , null new_bill_to_contact_name , null old_ship_to_contact_name , null new_ship_to_contact_name , null old_platform_name , null new_platform_name , null old_platform_version_name , null new_platform_version_name , null old_description , null new_description , null old_language , null new_language , null old_resource_type , null resource_type , null change_resource_type_flag from cs_incidents_all_b INC, fnd_user FU, jtf_notes_vl NOTES WHERE INC.incident_id = NOTES.source_object_id and NOTES.source_object_code = 'SR' and FU.user_id = NOTES.created_by UNION select 'AUDIT' source_type,audi.incident_id, audi.last_update_date incident_date , FU.USER_NAME OWNER, AUDI.incident_audit_id action_id, AUDI.last_update_date last_update_date, NULL Details, null NOTE_STATUS, to_char(AUDI.old_incident_severity_id) severity_old, to_char(AUDI.incident_severity_id) severity_new, AUDI.CHANGE_INCIDENT_SEVERITY_FLAG incident_severity_flag, to_char(AUDI.old_incident_type_id) type_old, to_char(AUDI.incident_type_id) type_new, AUDI.CHANGE_INCIDENT_TYPE_FLAG incident_type_flag, to_char(AUDI.old_incident_status_id) status_old, to_char(AUDI.incident_status_id) status_new, AUDI.CHANGE_INCIDENT_STATUS_FLAG incident_status_flag, to_char(AUDI.old_incident_urgency_id) urgency_old, to_char(AUDI.incident_urgency_id) urgency_new, AUDI.CHANGE_INCIDENT_URGENCY_FLAG incident_urgency_flag, to_char(AUDI.old_responsible_group_id) group_old, to_char(AUDI.responsible_group_id) group_new, AUDI.CHANGE_RESPONSIBLE_GROUP_FLAG responsible_group_flag, to_char(AUDI.old_incident_owner_id) owner_old, to_char(AUDI.incident_owner_id) owner_new, AUDI.CHANGE_INCIDENT_OWNER_FLAG incident_owner_flag, to_char(AUDI.old_expected_resolution_date) date_old, to_char(AUDI.expected_resolution_date) date_new, AUDI.CHANGE_RESOLUTION_FLAG resolution_date_flag, to_char(AUDI.old_obligation_date) obligation_date_old, to_char(AUDI.obligation_date) obligation_date_new, AUDI.CHANGE_OBLIGATION_FLAG obligation_DATE_flag, to_char(AUDI.site_id) site_id_new, to_char(AUDI.old_site_id) site_id_old, AUDI.CHANGE_SITE_FLAG site_flag, to_char(AUDI.bill_to_contact_id) bill_to_contact_id_new, to_char(AUDI.old_bill_to_contact_id) bill_to_contact_id_old, AUDI.CHANGE_BILL_TO_FLAG bill_to_flag, to_char(AUDI.ship_to_contact_id) ship_to_contact_id_new, to_char(AUDI.old_ship_to_contact_id) ship_to_contact_id_old, AUDI.CHANGE_SHIP_TO_FLAG ship_to_flag, to_char(AUDI.platform_id) platform_id_new, to_char(AUDI.old_platform_id) platform_id_old, AUDI.CHANGE_PLATFORM_ID_FLAG platform_id_flag, to_char(AUDI.platform_version_id) platform_version_id_new, to_char(AUDI.old_platform_version_id) platform_version_id_old, AUDI.CHANGE_PLAT_VER_ID_FLAG plat_ver_id_flag, to_char(AUDI.customer_product_id) customer_product_id_new, to_char(AUDI.old_customer_product_id) customer_product_id_old, AUDI.CHANGE_CUSTOMER_PRODUCT_FLAG customer_product_flag, to_char(AUDI.language_id) language_id_new, to_char(AUDI.old_language_id) language_id_old, AUDI.CHANGE_LANGUAGE_ID_FLAG language_id_flag , severity1.name old_severity_name , severity2.name new_severity_name , type1.name old_type_name , type2.name new_type_name , status1.name old_status_name , status2.name new_status_name , urgency1.name old_urgency_name , urgency2.name new_urgency_name , owner1.resource_name old_owner , owner2.resource_name new_owner , bill_to1.party_name old_bill_to_contact_name , bill_to2.party_name new_bill_to_contact_name , ship_to1.party_name old_ship_to_contact_name , ship_to1.party_name new_ship_to_contact_name , null old_platform_name , null new_platform_name , null old_platform_version_name , null new_platform_version_name , mtl1.description old_description , mtl2.description new_description , null old_language , null new_language , obj1.name old_resource_type , obj2.name resource_type , audi.change_resource_type_flag from fnd_user FU, cs_incidents_AUDIT_vl AUDI , cs_incident_severities severity1 , cs_incident_severities severity2 , cs_incident_types type1 , cs_incident_types type2 , cs_incident_statuses status1 , cs_incident_statuses status2 , cs_incident_urgencies urgency1 , cs_incident_urgencies urgency2 , cs_sr_owners_v owner1 , cs_sr_owners_v owner2 , jtf_objects_vl obj1 , jtf_objects_vl obj2 , jtf_parties_all_v bill_to1 , jtf_parties_all_v bill_to2 , jtf_parties_all_v ship_to1 , jtf_parties_all_v ship_to2 , mtl_system_items mtl1 , mtl_system_items mtl2 , cs_customer_products_all cp1 , cs_customer_products_all cp2 where FU.user_id = AUDI.last_updated_by and severity1.incident_severity_id(+) = audi.old_incident_severity_id and severity2.incident_severity_id(+) = audi.incident_severity_id and type1.incident_type_id(+) = audi.old_incident_type_id and type2.incident_type_id(+) = audi.incident_type_id and status1.incident_status_id(+) = audi.old_incident_status_id and status2.incident_status_id(+) = audi.incident_status_id and urgency1.incident_urgency_id(+) = audi.old_incident_urgency_id and urgency2.incident_urgency_id(+) = audi.incident_urgency_id and owner1.resource_id(+) = audi.old_incident_owner_id and (owner1.resource_type = audi.old_resource_type or audi.old_resource_type is null) and owner2.resource_id(+) = audi.incident_owner_id and (owner2.resource_type = audi.resource_type or audi.resource_type is null ) and obj1.object_code(+) = audi.old_resource_type and obj2.object_code(+) = audi.resource_type and bill_to1.party_id(+) = audi.old_bill_to_contact_id and bill_to2.party_id(+) = audi.bill_to_contact_id and ship_to1.party_id(+) = audi.old_ship_to_contact_id and ship_to2.party_id(+) = audi.ship_to_contact_id and cp1.customer_product_id(+) = audi.old_customer_product_id and cp2.customer_product_id(+) = audi.customer_product_id and cp1.inventory_item_id = mtl1.inventory_item_id(+) and cp2.inventory_item_id = mtl2.inventory_item_id(+) UNION select 'TASKS' source_type,INC.incident_id, INC.last_update_date incident_date, FU.USER_NAME OWNER, TASK.task_id action_id, TASK.last_update_date last_update_date, TASK.description Details, null note_status, null severity_old, null severity_new, NULL INCIDENT_SEVERITY_FLAG, null type_old, null type_new, NULL INCIDENT_TYPE_FLAG, null status_old, null status_new, NULL INCIDENT_STATUS_FLAG, null urgency_old, null urgency_new, NULL INCIDENT_URGENCY_FLAG, null group_old, null group_new, NULL RESPONSIBLE_GROUP_FLAG, null owner_old, null owner_new, NULL INCIDENT_OWNER_FLAG, null date_old, null date_new, NULL RESOLUTION_date_FLAG, null obligation_date_old, null obligation_date_new, NULL OBLIGATION_DATE_FLAG, null site_id_new, null site_id_old, NULL SITE_FLAG, null bill_to_contact_id_new, null bill_to_contact_id_old, NULL BILL_TO_FLAG, null ship_to_contact_id_new, null ship_to_contact_id_old, NULL SHIP_TO_FLAG, null platform_id_new, null platform_id_old, NULL PLATFORM_ID_FLAG, null platform_version_id_new, null platform_version_id_old, NULL PLAT_VER_ID_FLAG, null customer_product_id_new, null customer_product_id_old, NULL CUSTOMER_PRODUCT_FLAG, null language_id_new, null language_id_old, NULL LANGUAGE_ID_FLAG , null old_severity_name , null new_severity_name, null old_type_name , null new_type_name , null old_status_name , null new_status_name , null old_urgency_name , null new_urgency_name , null old_owner , null new_owner , null old_bill_to_contact_name , null new_bill_to_contact_name , null old_ship_to_contact_name , null new_ship_to_contact_name , null old_platform_name , null new_platform_name , null old_platform_version_name , null new_platform__version_name , null old_description , null new_description , null old_language , null new_language , null old_resource_type , null resource_type , null change_resource_type_flag from cs_incidents_all_b INC, fnd_user FU, jtf_tasks_v TASK where TASK.source_object_id = INC.incident_id and TASK.source_object_type_code = 'SR' and FU.user_id = TASK.last_updated_by

View Text - HTML Formatted

SELECT 'NOTES' SOURCE_TYPE
, INC.INCIDENT_ID
, INC.LAST_UPDATE_DATE INCIDENT_DATE
, FU.USER_NAME OWNER
, NOTES.JTF_NOTE_ID ACTION_ID
, NOTES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NOTES.NOTES DETAILS
, NOTES.NOTE_STATUS
, NULL SEVERITY_OLD
, NULL SEVERITY_NEW
, NULL INCIDENT_SEVERITY_FLAG
, NULL TYPE_OLD
, NULL TYPE_NEW
, NULL INCIDENT_TYPE_FLAG
, NULL STATUS_OLD
, NULL STATUS_NEW
, NULL INCIDENT_STATUS_FLAG
, NULL URGENCY_OLD
, NULL URGENCY_NEW
, NULL INCIDENT_URGENCY_FLAG
, NULL GROUP_OLD
, NULL GROUP_NEW
, NULL RESPONSIBLE_GROUP_FLAG
, NULL OWNER_OLD
, NULL OWNER_NEW
, NULL INCIDENT_OWNER_FLAG
, NULL DATE_OLD
, NULL DATE_NEW
, NULL RESOLUTION_DATE_FLAG
, NULL OBLIGATION_DATE_OLD
, NULL OBLIGATION_DATE_NEW
, NULL OBLIGATION_DATE_FLAG
, NULL SITE_ID_NEW
, NULL SITE_ID_OLD
, NULL SITE_FLAG
, NULL BILL_TO_CONTACT_ID_NEW
, NULL BILL_TO_CONTACT_ID_OLD
, NULL BILL_TO_FLAG
, NULL SHIP_TO_CONTACT_ID_NEW
, NULL SHIP_TO_CONTACT_ID_OLD
, NULL SHIP_TO_FLAG
, NULL PLATFORM_ID_NEW
, NULL PLATFORM_ID_OLD
, NULL PLATFORM_ID_FLAG
, NULL PLATFORM_VERSION_ID_NEW
, NULL PLATFORM_VERSION_ID_OLD
, NULL PLAT_VER_ID_FLAG
, NULL CUSTOMER_PRODUCT_ID_NEW
, NULL CUSTOMER_PRODUCT_ID_OLD
, NULL CUSTOMER_PRODUCT_FLAG
, NULL LANGUAGE_ID_NEW
, NULL LANGUAGE_ID_OLD
, NULL LANGUAGE_ID_FLAG
, NULL OLD_SEVERITY_NAME
, NULL NEW_SEVERITY_NAME
, NULL OLD_TYPE_NAME
, NULL NEW_TYPE_NAME
, NULL OLD_STATUS_NAME
, NULL NEW_STATUS_NAME
, NULL OLD_URGENCY_NAME
, NULL NEW_URGENCY_NAME
, NULL OLD_OWNER
, NULL NEW_OWNER
, NULL OLD_BILL_TO_CONTACT_NAME
, NULL NEW_BILL_TO_CONTACT_NAME
, NULL OLD_SHIP_TO_CONTACT_NAME
, NULL NEW_SHIP_TO_CONTACT_NAME
, NULL OLD_PLATFORM_NAME
, NULL NEW_PLATFORM_NAME
, NULL OLD_PLATFORM_VERSION_NAME
, NULL NEW_PLATFORM_VERSION_NAME
, NULL OLD_DESCRIPTION
, NULL NEW_DESCRIPTION
, NULL OLD_LANGUAGE
, NULL NEW_LANGUAGE
, NULL OLD_RESOURCE_TYPE
, NULL RESOURCE_TYPE
, NULL CHANGE_RESOURCE_TYPE_FLAG
FROM CS_INCIDENTS_ALL_B INC
, FND_USER FU
, JTF_NOTES_VL NOTES
WHERE INC.INCIDENT_ID = NOTES.SOURCE_OBJECT_ID
AND NOTES.SOURCE_OBJECT_CODE = 'SR'
AND FU.USER_ID = NOTES.CREATED_BY UNION SELECT 'AUDIT' SOURCE_TYPE
, AUDI.INCIDENT_ID
, AUDI.LAST_UPDATE_DATE INCIDENT_DATE
, FU.USER_NAME OWNER
, AUDI.INCIDENT_AUDIT_ID ACTION_ID
, AUDI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NULL DETAILS
, NULL NOTE_STATUS
, TO_CHAR(AUDI.OLD_INCIDENT_SEVERITY_ID) SEVERITY_OLD
, TO_CHAR(AUDI.INCIDENT_SEVERITY_ID) SEVERITY_NEW
, AUDI.CHANGE_INCIDENT_SEVERITY_FLAG INCIDENT_SEVERITY_FLAG
, TO_CHAR(AUDI.OLD_INCIDENT_TYPE_ID) TYPE_OLD
, TO_CHAR(AUDI.INCIDENT_TYPE_ID) TYPE_NEW
, AUDI.CHANGE_INCIDENT_TYPE_FLAG INCIDENT_TYPE_FLAG
, TO_CHAR(AUDI.OLD_INCIDENT_STATUS_ID) STATUS_OLD
, TO_CHAR(AUDI.INCIDENT_STATUS_ID) STATUS_NEW
, AUDI.CHANGE_INCIDENT_STATUS_FLAG INCIDENT_STATUS_FLAG
, TO_CHAR(AUDI.OLD_INCIDENT_URGENCY_ID) URGENCY_OLD
, TO_CHAR(AUDI.INCIDENT_URGENCY_ID) URGENCY_NEW
, AUDI.CHANGE_INCIDENT_URGENCY_FLAG INCIDENT_URGENCY_FLAG
, TO_CHAR(AUDI.OLD_RESPONSIBLE_GROUP_ID) GROUP_OLD
, TO_CHAR(AUDI.RESPONSIBLE_GROUP_ID) GROUP_NEW
, AUDI.CHANGE_RESPONSIBLE_GROUP_FLAG RESPONSIBLE_GROUP_FLAG
, TO_CHAR(AUDI.OLD_INCIDENT_OWNER_ID) OWNER_OLD
, TO_CHAR(AUDI.INCIDENT_OWNER_ID) OWNER_NEW
, AUDI.CHANGE_INCIDENT_OWNER_FLAG INCIDENT_OWNER_FLAG
, TO_CHAR(AUDI.OLD_EXPECTED_RESOLUTION_DATE) DATE_OLD
, TO_CHAR(AUDI.EXPECTED_RESOLUTION_DATE) DATE_NEW
, AUDI.CHANGE_RESOLUTION_FLAG RESOLUTION_DATE_FLAG
, TO_CHAR(AUDI.OLD_OBLIGATION_DATE) OBLIGATION_DATE_OLD
, TO_CHAR(AUDI.OBLIGATION_DATE) OBLIGATION_DATE_NEW
, AUDI.CHANGE_OBLIGATION_FLAG OBLIGATION_DATE_FLAG
, TO_CHAR(AUDI.SITE_ID) SITE_ID_NEW
, TO_CHAR(AUDI.OLD_SITE_ID) SITE_ID_OLD
, AUDI.CHANGE_SITE_FLAG SITE_FLAG
, TO_CHAR(AUDI.BILL_TO_CONTACT_ID) BILL_TO_CONTACT_ID_NEW
, TO_CHAR(AUDI.OLD_BILL_TO_CONTACT_ID) BILL_TO_CONTACT_ID_OLD
, AUDI.CHANGE_BILL_TO_FLAG BILL_TO_FLAG
, TO_CHAR(AUDI.SHIP_TO_CONTACT_ID) SHIP_TO_CONTACT_ID_NEW
, TO_CHAR(AUDI.OLD_SHIP_TO_CONTACT_ID) SHIP_TO_CONTACT_ID_OLD
, AUDI.CHANGE_SHIP_TO_FLAG SHIP_TO_FLAG
, TO_CHAR(AUDI.PLATFORM_ID) PLATFORM_ID_NEW
, TO_CHAR(AUDI.OLD_PLATFORM_ID) PLATFORM_ID_OLD
, AUDI.CHANGE_PLATFORM_ID_FLAG PLATFORM_ID_FLAG
, TO_CHAR(AUDI.PLATFORM_VERSION_ID) PLATFORM_VERSION_ID_NEW
, TO_CHAR(AUDI.OLD_PLATFORM_VERSION_ID) PLATFORM_VERSION_ID_OLD
, AUDI.CHANGE_PLAT_VER_ID_FLAG PLAT_VER_ID_FLAG
, TO_CHAR(AUDI.CUSTOMER_PRODUCT_ID) CUSTOMER_PRODUCT_ID_NEW
, TO_CHAR(AUDI.OLD_CUSTOMER_PRODUCT_ID) CUSTOMER_PRODUCT_ID_OLD
, AUDI.CHANGE_CUSTOMER_PRODUCT_FLAG CUSTOMER_PRODUCT_FLAG
, TO_CHAR(AUDI.LANGUAGE_ID) LANGUAGE_ID_NEW
, TO_CHAR(AUDI.OLD_LANGUAGE_ID) LANGUAGE_ID_OLD
, AUDI.CHANGE_LANGUAGE_ID_FLAG LANGUAGE_ID_FLAG
, SEVERITY1.NAME OLD_SEVERITY_NAME
, SEVERITY2.NAME NEW_SEVERITY_NAME
, TYPE1.NAME OLD_TYPE_NAME
, TYPE2.NAME NEW_TYPE_NAME
, STATUS1.NAME OLD_STATUS_NAME
, STATUS2.NAME NEW_STATUS_NAME
, URGENCY1.NAME OLD_URGENCY_NAME
, URGENCY2.NAME NEW_URGENCY_NAME
, OWNER1.RESOURCE_NAME OLD_OWNER
, OWNER2.RESOURCE_NAME NEW_OWNER
, BILL_TO1.PARTY_NAME OLD_BILL_TO_CONTACT_NAME
, BILL_TO2.PARTY_NAME NEW_BILL_TO_CONTACT_NAME
, SHIP_TO1.PARTY_NAME OLD_SHIP_TO_CONTACT_NAME
, SHIP_TO1.PARTY_NAME NEW_SHIP_TO_CONTACT_NAME
, NULL OLD_PLATFORM_NAME
, NULL NEW_PLATFORM_NAME
, NULL OLD_PLATFORM_VERSION_NAME
, NULL NEW_PLATFORM_VERSION_NAME
, MTL1.DESCRIPTION OLD_DESCRIPTION
, MTL2.DESCRIPTION NEW_DESCRIPTION
, NULL OLD_LANGUAGE
, NULL NEW_LANGUAGE
, OBJ1.NAME OLD_RESOURCE_TYPE
, OBJ2.NAME RESOURCE_TYPE
, AUDI.CHANGE_RESOURCE_TYPE_FLAG
FROM FND_USER FU
, CS_INCIDENTS_AUDIT_VL AUDI
, CS_INCIDENT_SEVERITIES SEVERITY1
, CS_INCIDENT_SEVERITIES SEVERITY2
, CS_INCIDENT_TYPES TYPE1
, CS_INCIDENT_TYPES TYPE2
, CS_INCIDENT_STATUSES STATUS1
, CS_INCIDENT_STATUSES STATUS2
, CS_INCIDENT_URGENCIES URGENCY1
, CS_INCIDENT_URGENCIES URGENCY2
, CS_SR_OWNERS_V OWNER1
, CS_SR_OWNERS_V OWNER2
, JTF_OBJECTS_VL OBJ1
, JTF_OBJECTS_VL OBJ2
, JTF_PARTIES_ALL_V BILL_TO1
, JTF_PARTIES_ALL_V BILL_TO2
, JTF_PARTIES_ALL_V SHIP_TO1
, JTF_PARTIES_ALL_V SHIP_TO2
, MTL_SYSTEM_ITEMS MTL1
, MTL_SYSTEM_ITEMS MTL2
, CS_CUSTOMER_PRODUCTS_ALL CP1
, CS_CUSTOMER_PRODUCTS_ALL CP2
WHERE FU.USER_ID = AUDI.LAST_UPDATED_BY
AND SEVERITY1.INCIDENT_SEVERITY_ID(+) = AUDI.OLD_INCIDENT_SEVERITY_ID
AND SEVERITY2.INCIDENT_SEVERITY_ID(+) = AUDI.INCIDENT_SEVERITY_ID
AND TYPE1.INCIDENT_TYPE_ID(+) = AUDI.OLD_INCIDENT_TYPE_ID
AND TYPE2.INCIDENT_TYPE_ID(+) = AUDI.INCIDENT_TYPE_ID
AND STATUS1.INCIDENT_STATUS_ID(+) = AUDI.OLD_INCIDENT_STATUS_ID
AND STATUS2.INCIDENT_STATUS_ID(+) = AUDI.INCIDENT_STATUS_ID
AND URGENCY1.INCIDENT_URGENCY_ID(+) = AUDI.OLD_INCIDENT_URGENCY_ID
AND URGENCY2.INCIDENT_URGENCY_ID(+) = AUDI.INCIDENT_URGENCY_ID
AND OWNER1.RESOURCE_ID(+) = AUDI.OLD_INCIDENT_OWNER_ID
AND (OWNER1.RESOURCE_TYPE = AUDI.OLD_RESOURCE_TYPE OR AUDI.OLD_RESOURCE_TYPE IS NULL)
AND OWNER2.RESOURCE_ID(+) = AUDI.INCIDENT_OWNER_ID
AND (OWNER2.RESOURCE_TYPE = AUDI.RESOURCE_TYPE OR AUDI.RESOURCE_TYPE IS NULL )
AND OBJ1.OBJECT_CODE(+) = AUDI.OLD_RESOURCE_TYPE
AND OBJ2.OBJECT_CODE(+) = AUDI.RESOURCE_TYPE
AND BILL_TO1.PARTY_ID(+) = AUDI.OLD_BILL_TO_CONTACT_ID
AND BILL_TO2.PARTY_ID(+) = AUDI.BILL_TO_CONTACT_ID
AND SHIP_TO1.PARTY_ID(+) = AUDI.OLD_SHIP_TO_CONTACT_ID
AND SHIP_TO2.PARTY_ID(+) = AUDI.SHIP_TO_CONTACT_ID
AND CP1.CUSTOMER_PRODUCT_ID(+) = AUDI.OLD_CUSTOMER_PRODUCT_ID
AND CP2.CUSTOMER_PRODUCT_ID(+) = AUDI.CUSTOMER_PRODUCT_ID
AND CP1.INVENTORY_ITEM_ID = MTL1.INVENTORY_ITEM_ID(+)
AND CP2.INVENTORY_ITEM_ID = MTL2.INVENTORY_ITEM_ID(+) UNION SELECT 'TASKS' SOURCE_TYPE
, INC.INCIDENT_ID
, INC.LAST_UPDATE_DATE INCIDENT_DATE
, FU.USER_NAME OWNER
, TASK.TASK_ID ACTION_ID
, TASK.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TASK.DESCRIPTION DETAILS
, NULL NOTE_STATUS
, NULL SEVERITY_OLD
, NULL SEVERITY_NEW
, NULL INCIDENT_SEVERITY_FLAG
, NULL TYPE_OLD
, NULL TYPE_NEW
, NULL INCIDENT_TYPE_FLAG
, NULL STATUS_OLD
, NULL STATUS_NEW
, NULL INCIDENT_STATUS_FLAG
, NULL URGENCY_OLD
, NULL URGENCY_NEW
, NULL INCIDENT_URGENCY_FLAG
, NULL GROUP_OLD
, NULL GROUP_NEW
, NULL RESPONSIBLE_GROUP_FLAG
, NULL OWNER_OLD
, NULL OWNER_NEW
, NULL INCIDENT_OWNER_FLAG
, NULL DATE_OLD
, NULL DATE_NEW
, NULL RESOLUTION_DATE_FLAG
, NULL OBLIGATION_DATE_OLD
, NULL OBLIGATION_DATE_NEW
, NULL OBLIGATION_DATE_FLAG
, NULL SITE_ID_NEW
, NULL SITE_ID_OLD
, NULL SITE_FLAG
, NULL BILL_TO_CONTACT_ID_NEW
, NULL BILL_TO_CONTACT_ID_OLD
, NULL BILL_TO_FLAG
, NULL SHIP_TO_CONTACT_ID_NEW
, NULL SHIP_TO_CONTACT_ID_OLD
, NULL SHIP_TO_FLAG
, NULL PLATFORM_ID_NEW
, NULL PLATFORM_ID_OLD
, NULL PLATFORM_ID_FLAG
, NULL PLATFORM_VERSION_ID_NEW
, NULL PLATFORM_VERSION_ID_OLD
, NULL PLAT_VER_ID_FLAG
, NULL CUSTOMER_PRODUCT_ID_NEW
, NULL CUSTOMER_PRODUCT_ID_OLD
, NULL CUSTOMER_PRODUCT_FLAG
, NULL LANGUAGE_ID_NEW
, NULL LANGUAGE_ID_OLD
, NULL LANGUAGE_ID_FLAG
, NULL OLD_SEVERITY_NAME
, NULL NEW_SEVERITY_NAME
, NULL OLD_TYPE_NAME
, NULL NEW_TYPE_NAME
, NULL OLD_STATUS_NAME
, NULL NEW_STATUS_NAME
, NULL OLD_URGENCY_NAME
, NULL NEW_URGENCY_NAME
, NULL OLD_OWNER
, NULL NEW_OWNER
, NULL OLD_BILL_TO_CONTACT_NAME
, NULL NEW_BILL_TO_CONTACT_NAME
, NULL OLD_SHIP_TO_CONTACT_NAME
, NULL NEW_SHIP_TO_CONTACT_NAME
, NULL OLD_PLATFORM_NAME
, NULL NEW_PLATFORM_NAME
, NULL OLD_PLATFORM_VERSION_NAME
, NULL NEW_PLATFORM__VERSION_NAME
, NULL OLD_DESCRIPTION
, NULL NEW_DESCRIPTION
, NULL OLD_LANGUAGE
, NULL NEW_LANGUAGE
, NULL OLD_RESOURCE_TYPE
, NULL RESOURCE_TYPE
, NULL CHANGE_RESOURCE_TYPE_FLAG
FROM CS_INCIDENTS_ALL_B INC
, FND_USER FU
, JTF_TASKS_V TASK
WHERE TASK.SOURCE_OBJECT_ID = INC.INCIDENT_ID
AND TASK.SOURCE_OBJECT_TYPE_CODE = 'SR'
AND FU.USER_ID = TASK.LAST_UPDATED_BY