accounting reviewer role member attributes

SELECT
rm.ROLE_MBR_ID,
rm.MBR_ID,
ad.NM,
rd.ATTR_VAL,
rm.MBR_TYP_CD
FROM KRIM_ROLE_MBR_T rm
inner join KRIM_ROLE_MBR_ATTR_DATA_T rd ON
rm.ROLE_MBR_ID = rd.ROLE_MBR_ID
inner join KRIM_ATTR_DEFN_T ad ON
rd.KIM_ATTR_DEFN_ID = ad.KIM_ATTR_DEFN_ID
WHERE
rm.ROLE_ID='28'
AND
rd.ROLE_MBR_ID IN (
SELECT ROLE_MBR_ID FROM KRIM_ROLE_MBR_ATTR_DATA_T rm2 WHERE rm2.attr_val = (
  SELECT
  org_cd
  FROM
  CA_ACCOUNT_T ac
  WHERE
  ac.fin_coa_cd='&chart'
  AND
  ac.account_nbr='&account'))
AND
rd.ROLE_MBR_ID IN (
SELECT ROLE_MBR_ID FROM KRIM_ROLE_MBR_ATTR_DATA_T rm2 WHERE rm2.attr_val = 'REQS')
GROUP BY rm.ROLE_MBR_ID,
rm.MBR_ID,
ad.NM,
rd.ATTR_VAL,
rm.MBR_TYP_CD

ORDER BY rm.ROLE_MBR_ID,
rm.MBR_ID,
ad.NM,
rd.ATTR_VAL,
rm.MBR_TYP_CD;