role member attrs for role, from-amount, doc-type

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 = '&role_id'
AND

-- where a fromAmount is defined
rd.ROLE_MBR_ID IN (
SELECT
ROLE_MBR_ID
FROM
KRIM_ROLE_MBR_ATTR_DATA_T rm2
WHERE
rm2.KIM_ATTR_DEFN_ID = '26'
AND
rm2.attr_val = '&from_amount'
  )
AND
rd.ROLE_MBR_ID IN (
SELECT ROLE_MBR_ID FROM KRIM_ROLE_MBR_ATTR_DATA_T rm2 WHERE rm2.attr_val = '&document_type')
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;