all org review routing attributes for doctype

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

-- 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
rd.ROLE_MBR_ID IN (
SELECT ROLE_MBR_ID FROM KRIM_ROLE_MBR_ATTR_DATA_T rm2 WHERE rm2.attr_val = 'DV')
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;