Query SQL:
SELECT B.LAST_NAME, B.FIRST_NAME, B.EMPLID, A.SUBJECT, A.CATALOG_NBR, A.CLASS_SECTION, A.DESCR, A.SSR_COMPONENT, A.INSTRUCTION_MODE, A.SESSION_CODE, A.ACAD_GROUP, A.ACAD_ORG, A.ACAD_CAREER, A.ROOM_CAP_REQUEST, A.ENRL_CAP, A.ENRL_TOT, TO_CHAR(A.START_DT,'YYYY-MM-DD'), TO_CHAR(A.END_DT,'YYYY-MM-DD'), decode ( C.MON, 'Y', 'Mo') || decode ( C.TUES, 'Y', 'Tu') ||
decode ( C.WED, 'Y', 'We') || decode ( C.THURS, 'Y', 'Th') ||
decode ( C.FRI, 'Y', 'Fr') || decode ( C.SAT, 'Y', 'Sa') ||
decode ( C.SUN, 'Y', 'Su'), TO_CHAR(CAST((C.MEETING_TIME_START) AS TIMESTAMP),'HH24.MI.SS.FF'), TO_CHAR(CAST((C.MEETING_TIME_END) AS TIMESTAMP),'HH24.MI.SS.FF'),A.CRSE_ID,A.CRSE_OFFER_NBR,A.STRM
FROM PS_CLASS_TBL A, PS_CLASS_INSTR_VW5 B, PS_CLASS_MTG_VW C
WHERE A.INSTITUTION = :1
AND A.STRM = :2
AND A.CLASS_STAT = 'A'
AND A.ENRL_TOT < 5
AND A.CRSE_ID = B.CRSE_ID (+)
AND A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR (+)
AND A.STRM = B.STRM (+)
AND A.SESSION_CODE = B.SESSION_CODE (+)
AND A.CLASS_SECTION = B.CLASS_SECTION (+)
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.CLASS_SECTION = C.CLASS_SECTION (+)
ORDER BY 1, 2, 4, 5, 6
decode ( C.WED, 'Y', 'We') || decode ( C.THURS, 'Y', 'Th') ||
decode ( C.FRI, 'Y', 'Fr') || decode ( C.SAT, 'Y', 'Sa') ||
decode ( C.SUN, 'Y', 'Su'), TO_CHAR(CAST((C.MEETING_TIME_START) AS TIMESTAMP),'HH24.MI.SS.FF'), TO_CHAR(CAST((C.MEETING_TIME_END) AS TIMESTAMP),'HH24.MI.SS.FF'),A.CRSE_ID,A.CRSE_OFFER_NBR,A.STRM
FROM PS_CLASS_TBL A, PS_CLASS_INSTR_VW5 B, PS_CLASS_MTG_VW C
WHERE A.INSTITUTION = :1
AND A.STRM = :2
AND A.CLASS_STAT = 'A'
AND A.ENRL_TOT < 5
AND A.CRSE_ID = B.CRSE_ID (+)
AND A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR (+)
AND A.STRM = B.STRM (+)
AND A.SESSION_CODE = B.SESSION_CODE (+)
AND A.CLASS_SECTION = B.CLASS_SECTION (+)
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.CLASS_SECTION = C.CLASS_SECTION (+)
ORDER BY 1, 2, 4, 5, 6