Query SQL:
SELECT DISTINCT A.INSTITUTION, A.STRM, A.ACAD_CAREER, A.EMPLID, A.CLASS_NBR, A.CRSE_GRADE_OFF, E.UNT_TAKEN_PRGRSS, E.UNT_TAKEN_FA, A.UNT_PRGRSS, F.SUBJECT, F.CATALOG_NBR, F.DESCR, F.CLASS_NBR,F.CRSE_ID,F.CRSE_OFFER_NBR,F.STRM,F.SESSION_CODE,F.CLASS_SECTION
FROM PS_STDNT_ENRL A, PS_ANTICIPATED_AID B, PS_ITEM_TYPE_TBL D, PS_STDNT_CAR_TERM E, PS_CLASS_TBL F
WHERE ( A.INSTITUTION = :1
AND A.STRM = :2
AND A.CRSE_GRADE_OFF = 'WN'
AND A.EMPLID = B.EMPLID
AND A.ACAD_CAREER = B.ACAD_CAREER
AND A.INSTITUTION = B.INSTITUTION
AND A.STRM = B.STRM
AND B.AS_OF_DTTM = (SELECT MAX ( C.AS_OF_DTTM)
FROM PS_ANTICIPATED_AID C
WHERE ( C.EMPLID = B.EMPLID
AND C.INSTITUTION = B.INSTITUTION
AND C.AID_YEAR = B.AID_YEAR
AND C.ITEM_TYPE = B.ITEM_TYPE
AND C.ACAD_CAREER = B.ACAD_CAREER
AND C.DISBURSEMENT_PLAN = B.DISBURSEMENT_PLAN
AND C.DISBURSEMENT_ID = B.DISBURSEMENT_ID
AND C.STRM = B.STRM ))
AND B.NET_AWARD_AMT > 0
AND B.ITEM_TYPE = D.ITEM_TYPE
AND D.EFFDT =
(SELECT MAX(D_ED.EFFDT) FROM PS_ITEM_TYPE_TBL D_ED
WHERE D.SETID = D_ED.SETID
AND D.ITEM_TYPE = D_ED.ITEM_TYPE
AND D_ED.EFFDT <= SYSDATE)
AND B.INSTITUTION = D.SETID
AND A.EMPLID = E.EMPLID
AND A.ACAD_CAREER = E.ACAD_CAREER
AND A.INSTITUTION = E.INSTITUTION
AND A.STRM = E.STRM
AND A.ACAD_CAREER = F.ACAD_CAREER
AND A.INSTITUTION = F.INSTITUTION
AND A.STRM = F.STRM
AND A.CLASS_NBR = F.CLASS_NBR
AND F.SESSION_CODE = A.SESSION_CODE
AND A.STDNT_ENRL_STATUS = 'E' )
ORDER BY 1, 2, 3, 4, 5