VIEW: APPS.JTF_RS_GROUP_MBR_ROLE_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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