VIEW: APPS.CS_SR_OWNERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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