View: CS_SR_UWQ_EMP_COUNT_V

Product:	CS - Service
Description:	This view is used by the UWQ (Universal Work Queue) to query up the count of Service Requests against the user logged in.
Implementation/DBA Data:	APPS.CS_SR_UWQ_EMP_COUNT_V

View Text

SELECT INC_B.INCIDENT_ID
, INC_B.INCIDENT_NUMBER
, INC_B.INCIDENT_STATUS_ID
, INC_B.INCIDENT_OWNER_ID RESOURCE_ID
, INC_B.RESOURCE_TYPE
, INC_B.INCIDENT_OWNER_ID OWNER_ID
, INC_B.INCIDENT_SEVERITY_ID
FROM CS_INCIDENTS_B_SEC INC_B
WHERE INC_B.STATUS_FLAG = 'O'
AND INC_B.RESOURCE_TYPE='RS_EMPLOYEE'

Columns