SELECT AL2.ACADEMIC_YEAR, 
       AL4.CIP_4_DIGIT_CODE, 
       AL4.CIP_4_DIGIT_DESC, 
       AL1.DEGREES_AWARDED, 
       AL1.NUM_BACHELOR_AWARDED, 
       AL1.NUM_MASTER_AWARDED, 
       AL1.NUM_DOCTORATE_AWARDED, 
       AL1.NUM_PROF_AWARDED, 
       AL1.UG_CREDIT_HOURS, 
       AL1.GRAD_CREDIT_HOURS, 
       AL1.SALARY_EXPENDITURE, 
       AL1.BENEFITS_EXPENDITURE, 
       AL1.OTHER_EXPENDITURE, 
       AL1.RESEARCH_EXPENDITURE, 
       AL1.PUBLIC_SVC_EXPENDITURE 
FROM WAREUSER.DELW_EXPENDITURE_DETAIL AL1, 
     WAREUSER.ACADEMIC_YEAR AL2, 
     WAREUSER.INSTITUTION AL3, 
     WAREUSER.DELW_CIP_4_DIGIT AL4 
WHERE AL1.ACADEMIC_YEAR_KEY=AL2.ACADEMIC_YEAR_KEY 
AND AL3.INSTITUTION_KEY=AL1.INSTITUTION_KEY 
AND AL1.DELW_CIP_4_DIGIT_KEY=AL4.DELW_CIP_4_DIGIT_KEY 
AND AL2.ACADEMIC_YEAR='2000-2001' 
AND AL3.INST_NAME='Oregon'