View: CS_INCIDENTS_DIARY_V

Product:	CS - Service
Description:	This view is not used anymore. This has been obsoleted. Starting 11.5.6 this view will not be supported and will remain just for backward compatability. The view CS_INCIDENTS_LOG_V has some of the functionality from this view but is not a c
Implementation/DBA Data:	APPS.CS_INCIDENTS_DIARY_V

View Text

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

Columns