SELECT sa.FSTUDENTBUSENTID,
  sa.KAPPLICATIONID,
  ade.KACADPROGDETAILID,
  ade.FSITEORGUNITNUMBER,
  sa.APPLYEAR,
  (SELECT astt.FACADPROGAPPLSTATUSCODEID
  FROM ACADPROGAPPLSTATUS astt
  WHERE astt.KACADPROGAPPLSTATUSID =
    (SELECT MAX(ast.KACADPROGAPPLSTATUSID)
    FROM ACADPROGAPPLSTATUS ast
    WHERE ast.FACADPROGDETAILID = ade.KACADPROGDETAILID
    )
  ) FACADPROGAPPLSTATUSCODEID,
  (SELECT astt.KACADPROGAPPLSTATUSID
  FROM ACADPROGAPPLSTATUS astt
  WHERE astt.KACADPROGAPPLSTATUSID =
    (SELECT MAX(ast.KACADPROGAPPLSTATUSID)
    FROM ACADPROGAPPLSTATUS ast
    WHERE ast.FACADPROGDETAILID = ade.KACADPROGDETAILID
    )
  ) KACADPROGAPPLSTATUSID,
  (SELECT astt.FSTATUSREASONCODEID
  FROM ACADPROGAPPLSTATUS astt
  WHERE astt.KACADPROGAPPLSTATUSID =
    (SELECT MAX(ast.KACADPROGAPPLSTATUSID)
    FROM ACADPROGAPPLSTATUS ast
    WHERE ast.FACADPROGDETAILID = ade.KACADPROGDETAILID
    )
  ) FSTATUSREASONCODEID,
  (SELECT astt.FSTATUSADDREASONCODEID
  FROM ACADPROGAPPLSTATUS astt
  WHERE astt.KACADPROGAPPLSTATUSID =
    (SELECT MAX(ast.KACADPROGAPPLSTATUSID)
    FROM ACADPROGAPPLSTATUS ast
    WHERE ast.FACADPROGDETAILID = ade.KACADPROGDETAILID
    )
  ) FSTATUSADDREASONCODEID,
  ade.FQUALLEVELAPID,
  ade.FPROGRAMAPID,
  q.QUALIFICATIONCODE,
  q.KACADEMICPROGRAMID AS QUALAPID,
  fos.FQUALIFICATIONAPID,
  fos.QUALIFICATIONFIELDOFSTUDY,
  fos.KACADEMICPROGRAMID AS FOSAPID,
  ql.FFIELDOFSTUDYAPID,
  ql.QUALIFICATIONLEVEL,
  ql.KACADEMICPROGRAMID AS QLAPID,
  q.FQUALIFICATIONTYPECODEID,
  ade.FENROLMENTCATEGORYCODEID,
  ade.FPRESENTCATCODEID,
  ade.FENROLMENTPRESENTATIONID,
  ade.CHOICENO,
  p.PROGRAMCODE
FROM STUDYAPPLICATION sa,
  ACADEMICPROGRAMDETAIL ade,
  QualificationLevel ql,
  FIELDOFSTUDY fos,
  QUalification q,
  Program p
WHERE sa.FSTUDENTBUSENTID       = 21269777
AND sa.KAPPLICATIONID           = ade.FAPPLICATIONID
AND ade.FQUALLEVELAPID          = ql.KACADEMICPROGRAMID
AND ade.FPROGRAMAPID            = p.KACADEMICPROGRAMID
AND ql.FFIELDOFSTUDYAPID        = fos.KACADEMICPROGRAMID
AND fos.FQUALIFICATIONAPID      = q.KACADEMICPROGRAMID
AND q.FQUALIFICATIONTYPECODEID <> 1869
AND sa.APPLYEAR                 = 2012
AND ql.STARTDATE               <= '1-Jan-2012'
AND (ql.ENDDATE                >= '31-Dec-2012'
OR ql.ENDDATE                  IS NULL)
AND fos.STARTDATE              <= '1-Jan-2012'
AND (fos.ENDDATE               >= '31-Dec-2012'
OR fos.ENDDATE                 IS NULL)
AND q.STARTDATE                <= '1-Jan-2012'
AND (q.ENDDATE                 >= '31-Dec-2012'
OR q.ENDDATE                   IS NULL)
ORDER BY ade.CHOICENO