VIEW: APPS.CS_SR_OWNERS_SEARCH_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')