View: JTF_TTY_ALL_RESOURCES_V

Product:	JTF - CRM Foundation
Description:	View for all resources
Implementation/DBA Data:	APPS.JTF_TTY_ALL_RESOURCES_V

View Text

SELECT RSC.RESOURCE_NAME RESOURCE_NAME
, RSC.RESOURCE_ID RESOURCE_ID
, GRPS.GROUP_NAME GROUP_NAME
, GRPS.GROUP_ID
, J1.ROLE_NAME ROLE_NAME
, J1.ROLE_CODE ROLE_CODE
, J1.MANAGER_FLAG MANAGER_FLAG
FROM JTF_RS_RESOURCE_EXTNS_VL RSC
, JTF_RS_GROUPS_VL GRPS
, JTF_RS_ROLES_VL J1
, JTF_RS_GROUP_MBR_ROLE_VL J2
WHERE SYSDATE BETWEEN RSC.START_DATE_ACTIVE
AND NVL(RSC.END_DATE_ACTIVE
, SYSDATE)
AND SYSDATE BETWEEN J2.START_DATE_ACTIVE
AND NVL(J2.END_DATE_ACTIVE
, SYSDATE+1)
AND J1.ROLE_ID = J2.ROLE_ID
AND J1.ACTIVE_FLAG = 'Y'
AND (J1.ROLE_TYPE_CODE = 'SALES' OR J1.ROLE_TYPE_CODE = 'TELESALES' OR J1.ROLE_TYPE_CODE = 'FIELDSALES' )
AND J2.GROUP_ID = GRPS.GROUP_ID
AND J2.RESOURCE_ID = RSC.RESOURCE_ID

Columns