eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CS_SR_MEMBERS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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