View: EAM_SERVICE_REQUEST_DETAILS_V

Product:	EAM - Enterprise Asset Management
Description:	Service request details
Implementation/DBA Data:	APPS.EAM_SERVICE_REQUEST_DETAILS_V

View Text

SELECT DISTINCT CIA.INCIDENT_ID
, CIA.INCIDENT_NUMBER
, CIA.INCIDENT_STATUS_ID
, CIS.NAME STATUS
, CIA.INCIDENT_SEVERITY_ID
, CISE.NAME SEVERITY
, CIA.ORG_ID
, CIA.INV_ORGANIZATION_ID
, CIA.INVENTORY_ITEM_ID
, OOD.OPERATING_UNIT
, EAM_COMMON_UTILITIES_PVT.GET_ITEM_NAME(CIA.INCIDENT_ID
, CIA.ORG_ID
, CIA.INV_ORGANIZATION_ID) AS ITEM_NAME
, SUBSTR(HOU.NAME
, 1
, 30) AS OPERATING_UNIT_NAME
FROM CS_INCIDENTS_ALL_B CIA
, ORG_ORGANIZATION_DEFINITIONS OOD
, CS_INCIDENT_STATUSES_B CIS
, CS_INCIDENT_SEVERITIES_B CISE
, HR_ORGANIZATION_UNITS HOU
WHERE CIA.INCIDENT_STATUS_ID = CIS.INCIDENT_STATUS_ID
AND CIA.INCIDENT_SEVERITY_ID = CISE.INCIDENT_SEVERITY_ID
AND NVL(CIS.CLOSE_FLAG
, 'N') <> 'Y'
AND (CIA.ORG_ID = OOD.OPERATING_UNIT OR OOD.ORGANIZATION_ID = CIA.INV_ORGANIZATION_ID)
AND OOD.OPERATING_UNIT = HOU.ORGANIZATION_ID

Columns