View: CS_SR_MEMBERS_V

Product:	CS - Service
Description:	Group and Individual Owners
Implementation/DBA Data:	APPS.CS_SR_MEMBERS_V

View Text

SELECT '999' GROUP_TYPE
, 999 GROUP_ID
, RESOURCE_ID
, RESOURCE_NAME
, 'RS_'|| CATEGORY RESOURCE_TYPE
FROM JTF_RS_RESOURCE_EXTNS_VL
WHERE TRUNC(SYSDATE) BETWEEN NVL(TRUNC(START_DATE_ACTIVE)
, TRUNC(SYSDATE)) AND NVL(TRUNC(END_DATE_ACTIVE)
, TRUNC(SYSDATE)) UNION ALL SELECT 'RS_GROUP' GROUP_TYPE
, GRP.GROUP_ID
, GRP.RESOURCE_ID
, RS.RESOURCE_NAME
, 'RS_'||GRP.CATEGORY RESOURCE_TYPE
FROM JTF_RS_GROUP_MEMBERS_VL GRP
, JTF_RS_RESOURCE_EXTNS_VL RS
WHERE GRP.RESOURCE_ID = RS.RESOURCE_ID
AND GRP.CATEGORY = RS.CATEGORY AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(RS.START_DATE_ACTIVE)
, TRUNC(SYSDATE)) AND NVL(TRUNC(RS.END_DATE_ACTIVE)
, TRUNC(SYSDATE)) UNION ALL SELECT 'RS_TEAM' GROUP_TYPE
, TEAM.TEAM_ID GROUP_ID
, TEAM_RESOURCE_ID RESOURCE_ID
, RSC.RESOURCE_NAME
, 'RS_'||TEAM.CATEGORY RESOURCE_TYPE
FROM JTF_RS_TEAM_MEMBERS_VL TEAM
, JTF_RS_RESOURCE_EXTNS_VL RSC
WHERE TEAM.RESOURCE_TYPE = 'INDIVIDUAL'
AND TEAM.TEAM_RESOURCE_ID = RSC.RESOURCE_ID
AND TEAM.CATEGORY = RSC.CATEGORY AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(RSC.START_DATE_ACTIVE)
, TRUNC(SYSDATE)) AND NVL(TRUNC(RSC.END_DATE_ACTIVE)
, TRUNC(SYSDATE))

Columns