SELECT AL2.FISCAL_YEAR, 
AL3.INST_NAME, 
AL3.AAUDE_INST_CODE, 
AL3.UNIT_ID, 
AL1.NSF_LINE_NUMBER, 
AL1.SUBRECIPIENT, 
AL1.FINANCE_TYPE, 
AL4.AMOUNT 
FROM WAREUSER.NSF_RDEXP_SUBRECPNT_TYPE AL1, 
     WAREUSER.FISCAL_YEAR AL2, 
     WAREUSER.INSTITUTION AL3, 
     WAREUSER.NSF_RDEXP_SUBRECIPIENT_DETAIL AL4 
WHERE AL2.FISCAL_YEAR_KEY=AL4.FISCAL_YEAR_KEY 
AND   AL4.INSTITUTION_KEY=AL3.INSTITUTION_KEY 
AND   AL4.NSF_RDEXP_SUBRECPNT_KEY=AL1.NSF_RDEXP_SUBRECPNT_TYPE_KEY  
AND   AL2.FISCAL_YEAR='2000' 
AND   AL3.IS_AAUDE_INSTITUTION='Y'