Clarity

SELECT
  MEMBER.ID USER_ID,
  MEMBER.USER_NAME,
  RES.LAST_NAME,
  RES.FIRST_NAME,
  RES.EMAIL EMAIL_ADDRESS,
  USER_GROUP.GROUP_ID MEMBER_GROUP_ID,
  CONTACT.PHONE_WORK,
  COMPANY.COMPANY_NAME,
  PROJECT.PROJECT_ID,
  niku.CLB_IS_PROJECT_MANAGER_FCT( PROJECT.PROJECT_MANAGERS_GROUP_ID,
                                     MEMBER.ID ) IS_PROJECT_MANAGER,
  RES.UNIQUE_NAME,
  RES.ID RESOURCE_ID
FROM
  CMN_SEC_USERS   MEMBER left outer join
  
SRM_COMPANIES COMPANY on MEMBER.COMPANY_ID = COMPANY.ID,
  CMN_SEC_USER_GROUPS  USER_GROUP left outer join
  
SRM_CONTACTS  CONTACT on USER_GROUP.USER_ID = CONTACT.PRINCIPAL_ID













AND  'USERS' = CONTACT.PRINCIPAL_TYPE,
  CLB_PROJECT_GROUP_KEYS    PROJECT,
  SRM_RESOURCES RES
WHERE PROJECT.PROJECT_MEMBERS_GROUP_ID =USER_GROUP.GROUP_ID
AND  USER_GROUP.USER_ID = MEMBER.ID
AND RES.USER_ID = MEMBER.ID

    SELECT i.code 
         , i.name
         , r.full_name
         , r.unique_name 
      FROM inv_investments i
         , srm_resources r
         --
         , cmn_sec_user_groups ug
         , clb_project_group_keys gk
         --
     WHERE i.code = '[color=#ff0000]-- YOUR PROJECT CODE GOES IN HERE --[/color]'
       AND gk.project_id = i.id
       AND gk.PROJECT_MEMBERS_GROUP_ID = ug.group_id
       AND ug.user_id = r.user_id;

Here's the quick bit of SQL that does this for System Group Participants:

SELECT
  SEC_GROUP.ID GROUP_ID,
  SEC_GROUP.LANGUAGE_CODE,
  SEC_GROUP.GROUP_NAME,
  SEC_GROUP.DESCRIPTION,
  PROJECT.PROJECT_ID,
  GRP_HIER.PARENT_GROUP_ID
FROM (
  SELECT G.ID
    NLS.LANGUAGE_CODE,
    NLS.NAME GROUP_NAME,
    NLS.DESCRIPTION,
  FROM CMN_CAPTIONS_NLS NLS,
  CMN_SEC_GROUPS G,
  CMN_LOOKUPS L,
  WHERE NLS.TABLE_NAME = 'CMN_SEC_GROUPS'
    AND NLS.PK_ID = G.CAPTIONS_PK_ID
    AND G.GROUP_TYPE_ID = L.ID
    AND L.LOOKUP_TYPE = 'SEC_GROUP_TYPE'          
) SEC_GROUP,
CMN_SEC_GROUP_HIERARCHIES GRP_HIER,
CLB_PROJECT_GROUP_KEYS PROJECT
WHERE GRP_HIER.PARENT_GROUP_ID = PROJECT.PROJECT_MEMBERS_GROUP_ID
  AND GRP_HIER.GROUP_ID = SEC_GROUP.ID     
  AND SEC_GROUP.LANGUAGE_CODE = 'en'