1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| SELECT SD.INCIDENT_ID AS "INTERACTION",
SD.COMPANY AS "SOCIETE",
SD.OPEN AS "STATUT",
SD.AFFECTED_ITEM AS "DEVICETYPE",
SD.LOGICAL_NAME AS "CI",
SD.TITLE AS "RESUME",
SD.DESCRIPTION AS "DESCRIPTION",
SD.RESOLUTION AS "SOLUTION",
SD.OPEN_TIME AS "DATECREATION",
SD.UPDATE_TIME AS "DATEMAJ",
SD.CLOSE_TIME AS "DATECLOTURE",
SD.OPENED_BY AS "CREATEUR",
SD.CALLBACK_CONTACT AS "APPELANT",
SD.SUBCATEGORY AS "DOMAINE",
SD.PRODUCT_TYPE AS "SOUSDOMAINE",
SD.RESOLUTION_CODE AS "CODECLOTURE",
SD.PRIORITY_CODE AS "PRIORITE"
FROM INCIDENTSM1 SD
LEFT OUTER JOIN LOCM1 LOC
ON (LOC.LOCATION_FULL_NAME = SD.LOCATION_FULL_NAME)
WHERE SD.CATEGORY = 'incident'
AND SD.OPEN_TIME >= TO_DATE('2013-01-01', 'YYYY-MM-DD')
ORDER BY SD.INCIDENT_ID; |
Partager