View: CS_SR_OWNERS_SEARCH_V

Product:	CS - Service
Description:	This view is used to retrieve owner name of an SR
Implementation/DBA Data:	APPS.CS_SR_OWNERS_SEARCH_V

View Text

SELECT RSC.RESOURCE_ID
, RSC.SOURCE_NAME RESOURCE_NAME
, 'RS_EMPLOYEE' RESOURCE_TYPE
FROM CS_JTF_RS_RESOURCE_EXTNS_SEC RSC
WHERE RSC.CATEGORY = 'EMPLOYEE' UNION ALL SELECT GRP_TL.GROUP_ID
, GRP_TL.GROUP_NAME
, 'RS_GROUP' RESOURCE_TYPE
FROM JTF_RS_GROUPS_TL GRP_TL
, JTF_RS_GROUP_USAGES GRP_USG
WHERE GRP_USG.USAGE = 'SUPPORT'
AND GRP_TL.GROUP_ID = GRP_USG.GROUP_ID
AND GRP_TL.LANGUAGE = USERENV('LANG') UNION ALL SELECT TEAM_TL.TEAM_ID
, TEAM_TL.TEAM_NAME
, 'RS_TEAM' RESOURCE_TYPE
FROM JTF_RS_TEAMS_TL TEAM_TL
, JTF_RS_TEAM_USAGES TEAM_USG
WHERE TEAM_USG.USAGE = 'SUPPORT'
AND TEAM_TL.TEAM_ID = TEAM_USG.TEAM_ID
AND TEAM_TL.LANGUAGE = USERENV('LANG')

Columns