[Home] [Help]
View: CS_SR_UWQ_TEAM_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's teams. |
Implementation/DBA Data: |
APPS.CS_SR_UWQ_TEAM_COUNT_V
|
View Text
SELECT INC_B.INCIDENT_ID
, INC_B.INCIDENT_NUMBER
, INC_B.INCIDENT_STATUS_ID
, INC_B.OWNER_GROUP_ID RESOURCE_ID
, INC_B.GROUP_TYPE 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.GROUP_TYPE='RS_TEAM'
Columns
Name |
INCIDENT_ID |
INCIDENT_NUMBER |
INCIDENT_STATUS_ID |
RESOURCE_ID |
RESOURCE_TYPE |
OWNER_ID |
INCIDENT_SEVERITY_ID |