Query SQL:
SELECT A.ACAD_GROUP, A.ACAD_ORG, A.SUBJECT, A.CATALOG_NBR, A.DESCR, A.CLASS_SECTION, A.SESSION_CODE, A.CLASS_NBR, A.SSR_COMPONENT, '1', to_char ( A.ENRL_TOT, '9999'), ' ', ' ', ' ', ' ', ' '
FROM PS_CLASS_TBL A
WHERE A.INSTITUTION = :1
AND A.ACAD_CAREER = :2
AND A.STRM = :3
AND ( A.ACAD_GROUP = :4
OR :4 IS NULL)
AND ( A.ACAD_ORG = :5
OR :5 IS NULL)
AND ( A.SUBJECT = :6
OR :6 IS NULL)
AND ( A.CATALOG_NBR = :7
OR :7 IS NULL)
UNION
SELECT D.ACAD_GROUP, D.ACAD_ORG, D.SUBJECT, D.CATALOG_NBR, D.DESCR, D.CLASS_SECTION, D.SESSION_CODE, D.CLASS_NBR, D.SSR_COMPONENT, '2', ' ', B.EMPLID, E.LAST_NAME, E.FIRST_NAME, E.MIDDLE_NAME, C.EMAIL_ADDR
FROM PS_CLASS_TBL_SE_VW B, PS_CU_BIO_VW E, PS_EMAIL_FERPA_VW C, PS_CLASS_TBL D
WHERE B.INSTITUTION = :1
AND B.ACAD_CAREER = :2
AND B.STRM = :3
AND B.STDNT_ENRL_STATUS = 'E'
AND B.EMPLID = E.EMPLID
AND B.EMPLID = C.EMPLID (+)
AND 'CAMP' = C.E_ADDR_TYPE (+)
AND B.ACAD_CAREER = D.ACAD_CAREER
AND B.INSTITUTION = D.INSTITUTION
AND B.STRM = D.STRM
AND B.CLASS_NBR = D.CLASS_NBR
AND D.CRSE_ID = B.CRSE_ID
AND D.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR
AND D.SESSION_CODE = B.SESSION_CODE
AND D.CLASS_SECTION = B.CLASS_SECTION
AND ( D.ACAD_GROUP = :4
OR :4 IS NULL)
AND ( D.ACAD_ORG = :5
OR :5 IS NULL)
AND ( D.SUBJECT = :6
OR :6 IS NULL)
AND ( D.CATALOG_NBR = :7
OR :7 IS NULL)
ORDER BY 1, 2, 3, 4, 6, 13, 14, 15