SELECT DISTINCT C.LAST_NAME, C.FIRST_NAME, C.MIDDLE_NAME, B.EMPLID, D.SUBJECT, D.CATALOG_NBR, D.DESCR, D.CLASS_SECTION, D.SESSION_CODE, D.CRSE_GRADE_OFF,D.EMPLID,D.ACAD_CAREER,D.INSTITUTION,D.STRM,D.CLASS_NBR
FROM PS_TERM_TBL A, PS_STDNT_GRPS_HIST B, PS_CU_BIO_VW C, PS_CLASS_TBL_SE_VW D
WHERE A.INSTITUTION = :1
AND A.ACAD_CAREER = :2
AND A.STRM = :3
AND B.INSTITUTION = A.INSTITUTION
AND B.EFFDT =
(SELECT MAX(B_ED.EFFDT) FROM PS_STDNT_GRPS_HIST B_ED
WHERE B.EMPLID = B_ED.EMPLID
AND B.INSTITUTION = B_ED.INSTITUTION
AND B.STDNT_GROUP = B_ED.STDNT_GROUP
AND B_ED.EFFDT <= A.TERM_BEGIN_DT)
AND B.EFF_STATUS = 'A'
AND B.STDNT_GROUP = :4
AND B.EMPLID = C.EMPLID
AND B.EMPLID = D.EMPLID
AND B.INSTITUTION = D.INSTITUTION
AND D.STDNT_ENRL_STATUS = 'E'
AND D.STRM = A.STRM
AND ( D.SUBJECT = :5
OR :5 IS NULL)
AND ( D.CATALOG_NBR = :6
OR :6 IS NULL)
ORDER BY 1, 2, 3, 5, 6, 8
  • No labels