View: CS_SR_OWNERS_V

Product:	CS - Service
Description:	This view shows all resources of type 'EMPLOYEE', 'TEAM' and 'GROUP'
Implementation/DBA Data:	APPS.CS_SR_OWNERS_V

View Text

SELECT RSC.RESOURCE_ID
, RSC.RESOURCE_NUMBER RESOURCE_NUMBER
, RSC.FULL_NAME RESOURCE_NAME
, RSC.SUPPORT_SITE_ID
, NULL USAGE
, 'RS_EMPLOYEE' RESOURCE_TYPE
, RSC.ORG_ID ORG_ID
FROM JTF_RS_EMP_DTLS_VL RSC
WHERE TRUNC(SYSDATE) BETWEEN NVL(TRUNC(RSC.START_DATE_ACTIVE)
, TRUNC(SYSDATE))
AND NVL(TRUNC(RSC.END_DATE_ACTIVE)
, TRUNC(SYSDATE)) UNION ALL SELECT GRP.GROUP_ID
, GRP.GROUP_NUMBER
, GRP.GROUP_NAME
, -99999
, GRP_USG.USAGE
, 'RS_GROUP' RESOURCE_TYPE
, TO_NUMBER(NULL)
FROM JTF_RS_GROUPS_VL GRP
, JTF_RS_GROUP_USAGES GRP_USG
WHERE TRUNC(SYSDATE) BETWEEN NVL(TRUNC(GRP.START_DATE_ACTIVE)
, TRUNC(SYSDATE))
AND NVL(TRUNC(GRP.END_DATE_ACTIVE)
, TRUNC(SYSDATE)) AND GRP_USG.USAGE = 'SUPPORT' AND GRP.GROUP_ID = GRP_USG.GROUP_ID UNION ALL SELECT TEAM.TEAM_ID
, TEAM.TEAM_NUMBER
, TEAM.TEAM_NAME
, -99999
, TEAM_USG.USAGE
, 'RS_TEAM' RESOURCE_TYPE
, TO_NUMBER(NULL)
FROM JTF_RS_TEAMS_VL TEAM
, JTF_RS_TEAM_USAGES TEAM_USG
WHERE TRUNC(SYSDATE) BETWEEN NVL(TRUNC(TEAM.START_DATE_ACTIVE)
, TRUNC(SYSDATE))
AND NVL(TRUNC(TEAM.END_DATE_ACTIVE)
, TRUNC(SYSDATE)) AND TEAM_USG.USAGE = 'SUPPORT' AND TEAM.TEAM_ID = TEAM_USG.TEAM_ID

Columns