Query SQL:
SELECT E.LAST_NAME, E.FIRST_NAME, E.MIDDLE_NAME, A.EMPLID, C.UNT_TAKEN_FA, A.NET_AWARD_AMT, B.ITEM_TYPE, B.DESCR, E.EMAIL_ADDR, E.PHONE,B.SETID,TO_CHAR(B.EFFDT,'YYYY-MM-DD')
FROM PS_ANTICIPATED_AID A, PS_ITEM_TYPE_TBL B, PS_STDNT_CAR_TERM C, PS_CU_BIO_VW E
WHERE A.ITEM_TYPE = B.ITEM_TYPE
AND B.EFFDT =
(SELECT MAX(B_ED.EFFDT) FROM PS_ITEM_TYPE_TBL B_ED
WHERE B.SETID = B_ED.SETID
AND B.ITEM_TYPE = B_ED.ITEM_TYPE
AND B_ED.EFFDT <= SYSDATE)
AND A.INSTITUTION = B.SETID
AND B.DESCR LIKE '%Direct Loan%'
AND A.INSTITUTION = :1
AND A.EMPLID = C.EMPLID
AND A.INSTITUTION = C.INSTITUTION
AND A.ACAD_CAREER = C.ACAD_CAREER
AND C.STRM = A.STRM
AND C.ACAD_CAREER = :2
AND A.STRM = :3
AND C.UNT_TAKEN_FA < 6
AND A.NET_AWARD_AMT > 0
AND A.AS_OF_DTTM = (SELECT max ( D.AS_OF_DTTM)
FROM PS_ANTICIPATED_AID D
WHERE D.EMPLID = A.EMPLID
AND D.INSTITUTION = A.INSTITUTION
AND D.AID_YEAR = A.AID_YEAR
AND D.ITEM_TYPE = A.ITEM_TYPE
AND D.ACAD_CAREER = A.ACAD_CAREER
AND D.DISBURSEMENT_PLAN = A.DISBURSEMENT_PLAN
AND D.DISBURSEMENT_ID = A.DISBURSEMENT_ID
AND D.STRM = A.STRM)
AND A.EMPLID = E.EMPLID
ORDER BY 1, 2, 3, 7