View: JTF_RS_GROUP_MBR_ROLE_VL

Product:	JTF - CRM Foundation
Description:	This view is used in define group form member_roles block.
Implementation/DBA Data:	APPS.JTF_RS_GROUP_MBR_ROLE_VL

View Text

SELECT MEM.GROUP_MEMBER_ID
, MEM.RESOURCE_ID
, MEM.GROUP_ID
, ROL.ROLE_ID
, ROL.ROLE_NAME
, ROL.ROLE_DESC
, ROL.MEMBER_FLAG
, ROL.ADMIN_FLAG
, ROL.MANAGER_FLAG
, ROL.LEAD_FLAG
, RRL.START_DATE_ACTIVE
, RRL.END_DATE_ACTIVE
, RRL.ROLE_RELATE_ID
FROM JTF_RS_GROUP_MEMBERS MEM
, JTF_RS_ROLE_RELATIONS RRL
, JTF_RS_ROLES_VL ROL
WHERE MEM.GROUP_MEMBER_ID = RRL.ROLE_RESOURCE_ID
AND NVL(RRL.DELETE_FLAG
, 'N') <> 'Y'
AND NVL(MEM.DELETE_FLAG
, 'N') <> 'Y'
AND RRL.ROLE_RESOURCE_TYPE = 'RS_GROUP_MEMBER'
AND RRL.ROLE_ID = ROL.ROLE_ID

Columns