Query SQL:
SELECT A.ACAD_GROUP, A.ACAD_ORG, A.SUBJECT, A.CATALOG_NBR, A.CLASS_SECTION, A.DESCR, A.SSR_COMPONENT, to_char ( A.ENRL_TOT, '99999'), A.SESSION_CODE, ' ', ' ', ' ', ' '
FROM PS_CLASS_TBL A
WHERE ( A.INSTITUTION = :1
AND A.STRM = :2
AND A.ACAD_GROUP = :3
AND ( A.ACAD_ORG = :4
OR :4 IS NULL)
AND ( A.SUBJECT = :5
OR :5 IS NULL)
AND A.ENRL_TOT > 0 )
UNION
SELECT B.ACAD_GROUP, B.ACAD_ORG, B.SUBJECT, B.CATALOG_NBR, B.CLASS_SECTION, 'z Instructor', ' ', ' ', ' ', D.EMPLID, D.LAST_NAME, D.FIRST_NAME, ' '
FROM PS_CLASS_TBL B, PS_CLASS_INSTR_VW5 D
WHERE ( B.INSTITUTION = :1
AND B.STRM = :2
AND B.ACAD_GROUP = :3
AND ( B.ACAD_ORG = :4
OR :4 IS NULL)
AND ( B.SUBJECT = :5
OR :5 IS NULL)
AND B.ENRL_TOT > 0
AND B.CRSE_ID = D.CRSE_ID
AND B.CRSE_OFFER_NBR = D.CRSE_OFFER_NBR
AND B.STRM = D.STRM
AND B.SESSION_CODE = D.SESSION_CODE
AND B.CLASS_SECTION = D.CLASS_SECTION )
UNION
SELECT C.ACAD_GROUP, C.ACAD_ORG, C.SUBJECT, C.CATALOG_NBR, C.CLASS_SECTION, 'z Student', ' ', ' ', ' ', E.EMPLID, F.LAST_NAME, F.FIRST_NAME, E.CRSE_GRADE_OFF
FROM PS_CLASS_TBL C, PS_STDNT_ENRL_VW E, PS_CU_BIO_VW F
WHERE ( C.INSTITUTION = :1
AND C.STRM = :2
AND C.ACAD_GROUP = :3
AND ( C.ACAD_ORG = :4
OR :4 IS NULL)
AND ( C.SUBJECT = :5
OR :5 IS NULL)
AND C.ENRL_TOT > 0
AND C.STRM = E.STRM
AND E.ACAD_CAREER = C.ACAD_CAREER
AND E.INSTITUTION = C.INSTITUTION
AND E.CLASS_NBR = C.CLASS_NBR
AND E.EMPLID = F.EMPLID )
ORDER BY 3, 4, 5, 6, 11, 12