Query SQL:
SELECT A.ACAD_GROUP, A.ACAD_ORG, A.SUBJECT, A.CATALOG_NBR, A.DESCR, A.SESSION_CODE, A.CLASS_NBR, A.CLASS_SECTION, A.CLASS_STAT, A.INSTRUCTION_MODE, TO_CHAR(A.START_DT,'YYYY-MM-DD'), TO_CHAR(A.END_DT,'YYYY-MM-DD'), A.ROOM_CAP_REQUEST, A.ENRL_CAP, A.ENRL_TOT, A.ENRL_CAP - A.ENRL_TOT, D.DESCRFORMAL, A.ACAD_CAREER, C.UNITS_ACAD_PROG, C.CRSE_CONTACT_HRS, E.CLASS_MTG_NBR, E.FACILITY_ID, TO_CHAR(CAST((E.MEETING_TIME_START) AS TIMESTAMP),'HH24.MI.SS.FF'), TO_CHAR(CAST((E.MEETING_TIME_END) AS TIMESTAMP),'HH24.MI.SS.FF'), decode ( E.MON, 'Y', 'Mo') || decode ( E.TUES, 'Y', 'Tu') || decode ( E.WED, 'Y', 'We') || decode ( E.THURS, 'Y', 'Th') || decode ( E.FRI, 'Y', 'Fr') || decode ( E.SAT, 'Y', 'Sa') || decode ( E.SUN, 'Y', 'Su'), case
when substr ( B.LAST_NAME, 1, 1) <> ' '
then B.LAST_NAME || ', ' || B.FIRST_NAME
else ' '
end, ' ', ' ', ' ', ' ', ' '
FROM PS_CLASS_TBL A, PS_CLASS_ASSOC C, PS_RQMNT_DESIG_TBL D, PS_CLASS_MTG_PAT E, PS_CLASS_INSTR_VW5 B
WHERE ( A.INSTITUTION = :1
AND A.STRM = :2
AND A.ACAD_GROUP = :3
AND ( A.ACAD_ORG = :4
OR :4 IS NULL)
AND ( A.SESSION_CODE = :5
OR :5 IS NULL)
AND A.CRSE_ID = C.CRSE_ID
AND A.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR
AND A.STRM = C.STRM
AND A.SESSION_CODE = C.SESSION_CODE
AND A.ASSOCIATED_CLASS = C.ASSOCIATED_CLASS
AND D.RQMNT_DESIGNTN = C.RQMNT_DESIGNTN
AND D.EFFDT =
(SELECT MAX(D_ED.EFFDT) FROM PS_RQMNT_DESIG_TBL D_ED
WHERE D.RQMNT_DESIGNTN = D_ED.RQMNT_DESIGNTN
AND D_ED.EFFDT <= SYSDATE)
AND A.CRSE_ID = E.CRSE_ID (+)
AND A.CRSE_OFFER_NBR = E.CRSE_OFFER_NBR (+)
AND A.STRM = E.STRM (+)
AND A.SESSION_CODE = E.SESSION_CODE (+)
AND A.CLASS_SECTION = E.CLASS_SECTION (+)
AND E.CRSE_ID = B.CRSE_ID (+)
AND E.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR (+)
AND E.STRM = B.STRM (+)
AND E.SESSION_CODE = B.SESSION_CODE (+)
AND E.CLASS_SECTION = B.CLASS_SECTION (+)
AND E.CLASS_MTG_NBR = B.CLASS_MTG_NBR (+) )
UNION
SELECT F.ACAD_GROUP, F.ACAD_ORG, F.SUBJECT, F.CATALOG_NBR, ' ', ' ', F.CLASS_NBR, F.CLASS_SECTION, ' ', ' ', ' ', ' ', 0, 0, 0, 0, ' ', ' ', 0, 0, 0, ' ', ' ', ' ', ' ', ' ', G.EMPLID, H.LAST_NAME, H.FIRST_NAME, H.MIDDLE_NAME, H.EMAIL_ADDR
FROM PS_CLASS_TBL F, PS_STDNT_ENRL G, PS_CU_BIO_VW H
WHERE ( F.STRM = G.STRM
AND F.SESSION_CODE = G.SESSION_CODE
AND G.ACAD_CAREER = F.ACAD_CAREER
AND G.INSTITUTION = F.INSTITUTION
AND G.CLASS_NBR = F.CLASS_NBR
AND G.EMPLID = H.EMPLID
AND F.INSTITUTION = :1
AND F.STRM = :2
AND ( F.ACAD_GROUP = :3
OR :3 IS NULL)
AND ( F.ACAD_ORG = :4
OR :4 IS NULL)
AND ( F.SESSION_CODE = :5
OR :5 IS NULL)
AND G.STDNT_ENRL_STATUS = 'E' )
ORDER BY 1, 2, 3, 4, 8, 28, 29, 30
when substr ( B.LAST_NAME, 1, 1) <> ' '
then B.LAST_NAME || ', ' || B.FIRST_NAME
else ' '
end, ' ', ' ', ' ', ' ', ' '
FROM PS_CLASS_TBL A, PS_CLASS_ASSOC C, PS_RQMNT_DESIG_TBL D, PS_CLASS_MTG_PAT E, PS_CLASS_INSTR_VW5 B
WHERE ( A.INSTITUTION = :1
AND A.STRM = :2
AND A.ACAD_GROUP = :3
AND ( A.ACAD_ORG = :4
OR :4 IS NULL)
AND ( A.SESSION_CODE = :5
OR :5 IS NULL)
AND A.CRSE_ID = C.CRSE_ID
AND A.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR
AND A.STRM = C.STRM
AND A.SESSION_CODE = C.SESSION_CODE
AND A.ASSOCIATED_CLASS = C.ASSOCIATED_CLASS
AND D.RQMNT_DESIGNTN = C.RQMNT_DESIGNTN
AND D.EFFDT =
(SELECT MAX(D_ED.EFFDT) FROM PS_RQMNT_DESIG_TBL D_ED
WHERE D.RQMNT_DESIGNTN = D_ED.RQMNT_DESIGNTN
AND D_ED.EFFDT <= SYSDATE)
AND A.CRSE_ID = E.CRSE_ID (+)
AND A.CRSE_OFFER_NBR = E.CRSE_OFFER_NBR (+)
AND A.STRM = E.STRM (+)
AND A.SESSION_CODE = E.SESSION_CODE (+)
AND A.CLASS_SECTION = E.CLASS_SECTION (+)
AND E.CRSE_ID = B.CRSE_ID (+)
AND E.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR (+)
AND E.STRM = B.STRM (+)
AND E.SESSION_CODE = B.SESSION_CODE (+)
AND E.CLASS_SECTION = B.CLASS_SECTION (+)
AND E.CLASS_MTG_NBR = B.CLASS_MTG_NBR (+) )
UNION
SELECT F.ACAD_GROUP, F.ACAD_ORG, F.SUBJECT, F.CATALOG_NBR, ' ', ' ', F.CLASS_NBR, F.CLASS_SECTION, ' ', ' ', ' ', ' ', 0, 0, 0, 0, ' ', ' ', 0, 0, 0, ' ', ' ', ' ', ' ', ' ', G.EMPLID, H.LAST_NAME, H.FIRST_NAME, H.MIDDLE_NAME, H.EMAIL_ADDR
FROM PS_CLASS_TBL F, PS_STDNT_ENRL G, PS_CU_BIO_VW H
WHERE ( F.STRM = G.STRM
AND F.SESSION_CODE = G.SESSION_CODE
AND G.ACAD_CAREER = F.ACAD_CAREER
AND G.INSTITUTION = F.INSTITUTION
AND G.CLASS_NBR = F.CLASS_NBR
AND G.EMPLID = H.EMPLID
AND F.INSTITUTION = :1
AND F.STRM = :2
AND ( F.ACAD_GROUP = :3
OR :3 IS NULL)
AND ( F.ACAD_ORG = :4
OR :4 IS NULL)
AND ( F.SESSION_CODE = :5
OR :5 IS NULL)
AND G.STDNT_ENRL_STATUS = 'E' )
ORDER BY 1, 2, 3, 4, 8, 28, 29, 30