[Home] [Help]
| Product: | XNS - Service for Communications (Obsolete) |
|---|---|
| Description: | Service request history for customer products in the installed base |
| Implementation/DBA Data: | Not implemented in this database |
SELECT INC.ROW_ID ROW_ID
, INC.INCIDENT_ID
, INC.LAST_UPDATE_DATE
, INC.LAST_UPDATED_BY
, INC.CREATION_DATE
, INC.CREATED_BY
, INC.LAST_UPDATE_LOGIN
, INC.CUSTOMER_PRODUCT_ID
, INC.INCIDENT_NUMBER
, INC.INCIDENT_DATE
, INC.CLOSE_DATE
, TYP.NAME INCIDENT_TYPE
, SEV.NAME SEVERITY
, STS.NAME STATUS
, URG.NAME URGENCY
, PER.FULL_NAME OWNER
, L1.MEANING PROBLEM_SUMMARY
, L1.DESCRIPTION PROBLEM_DESCRIPTION
, L2.DESCRIPTION RESOLUTION_DESCRIPTION
FROM CS_INCIDENTS_ALL_VL INC
, CS_INCIDENT_TYPES_VL TYP
, CS_INCIDENT_SEVERITIES_VL SEV
, CS_INCIDENT_STATUSES_VL STS
, CS_INCIDENT_URGENCIES_VL URG
, PER_PEOPLE_X PER
, FND_LOOKUPS L1
, FND_LOOKUPS L2
WHERE INC.INCIDENT_TYPE_ID = TYP.INCIDENT_TYPE_ID
AND INC.INCIDENT_STATUS_ID = STS.INCIDENT_STATUS_ID
AND INC.INCIDENT_OWNER_ID = PER.PERSON_ID(+)
AND INC.INCIDENT_URGENCY_ID = URG.INCIDENT_URGENCY_ID(+)
AND INC.INCIDENT_SEVERITY_ID = SEV.INCIDENT_SEVERITY_ID(+)
AND INC.PROBLEM_CODE = L1.LOOKUP_CODE(+)
AND L1.LOOKUP_TYPE = 'REQUEST_PROBLEM_CODE'
AND INC.RESOLUTION_CODE = L2.LOOKUP_CODE(+)
AND L2.LOOKUP_TYPE= 'REQUEST_RESOLUTION_CODE'