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