View: JTF_TERR_QLFY_RSC_DST_V

Product:	JTF - CRM Foundation
Description:	This views stores all the active resources , groups and teams.
Implementation/DBA Data:	APPS.JTF_TERR_QLFY_RSC_DST_V

View Text

SELECT RSC.RESOURCE_ID RESOURCE_ID
, DECODE( RSC.CATEGORY
, 'EMPLOYEE'
, 'RS_EMPLOYEE'
, 'PARTNER'
, 'RS_PARTNER'
, 'SUPPLIER_CONTACT'
, 'RS_SUPPLIER_CONTACT'
, 'PARTY'
, 'RS_PARTY'
, 'OTHER'
, 'RS_OTHER'
, 'TBH'
, 'RS_TBH') RESOURCE_TYPE
, DECODE( RSC.CATEGORY
, 'EMPLOYEE'
, 'EMPLOYEE RESOURCE'
, 'PARTNER'
, 'PARTNER RESOURCE'
, 'SUPPLIER_CONTACT'
, 'SUPPLIER RESOURCE'
, 'PARTY'
, 'PARTY RESOURCE'
, 'OTHER'
, 'OTHER RESOURCE'
, 'TBH'
, 'TO BE HIRED') RESOURCE_TYPE_NAME
, RSC.RESOURCE_NAME RESOURCE_NAME
, NULL
, NULL
, NULL
, NULL
FROM JTF_RS_RESOURCE_EXTNS_VL RSC
WHERE NVL(RSC.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE
AND RSC.START_DATE_ACTIVE <= SYSDATE UNION ALL SELECT GRP.GROUP_ID RESOURCE_ID
, 'RS_GROUP' RESOURCE_TYPE
, 'GROUP RESOURCE' RESOURCE_TYPE_NAME
, GRP.GROUP_NAME RESOURCE_NAME
, NULL
, NULL
, NULL
, NULL
FROM JTF_RS_GROUPS_VL GRP
WHERE NVL(GRP.START_DATE_ACTIVE
, SYSDATE-1) <= SYSDATE
AND NVL(GRP.END_DATE_ACTIVE
, SYSDATE+1) >= SYSDATE UNION ALL SELECT TM.TEAM_ID RESOURCE_ID
, 'RS_TEAM' RESOURCE_TYPE
, 'TEAM RESOURCE' RESOURCE_TYPE_NAME
, TM.TEAM_NAME RESOURCE_NAME
, NULL
, NULL
, NULL
, NULL
FROM JTF_RS_TEAMS_VL TM
WHERE NVL(TM.START_DATE_ACTIVE
, SYSDATE-1) <= SYSDATE
AND NVL(TM.END_DATE_ACTIVE
, SYSDATE+1) >= SYSDATE

Columns