Query SQL:
SELECT DISTINCT A.SUBJECT, A.CATALOG_NBR, A.DESCR, A.CLASS_SECTION, A.SESSION_CODE, A.ACAD_CAREER, A.CLASS_STAT, A.ENRL_CAP, A.ENRL_TOT, TO_CHAR(A.START_DT,'YYYY-MM-DD'), TO_CHAR(A.END_DT,'YYYY-MM-DD'), B.SSR_CRSEMAT_TYPE, B.SSR_TXBDTL_STATUS, B.SSR_TXBDTL_TITLE, B.SSR_TXBDTL_ISBN, B.SSR_TXBDTL_AUTHOR, B.SSR_TXBDTL_PUBLISH, B.SSR_TXBDTL_EDITION, B.SSR_TXBDTL_PUBYEAR, B.SSR_TXBDTL_PRICE, C.FACILITY_ID, 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'), 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'), D.LAST_NAME, D.FIRST_NAME, E.EMAIL_ADDR, TO_CHAR(SYSDATE,'YYYY-MM-DD'), TO_CHAR(SYSDATE,'YYYY-MM-DD'),A.CRSE_ID,A.CRSE_OFFER_NBR,A.STRM
FROM PS_CLASS_TBL A, PS_SSR_CLS_TXB_DTL B, PS_CLASS_MTG_PAT C, PS_CLASS_INSTR_VW5 D, (SELECT TE.EMAIL_ADDR, TE.EMPLID, TE.E_ADDR_TYPE
FROM PS_EMAIL_ADDRESSES TE,PS_PERALL_SEC_QRY E1 WHERE TE.EMPLID = E1.EMPLID AND E1.OPRID = '11002650' ) E
WHERE ( A.INSTITUTION = :1
AND A.STRM = :2
AND ( A.SESSION_CODE = :3
OR :3 IS NULL)
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 (+)
AND A.CRSE_ID = D.CRSE_ID (+)
AND A.CRSE_OFFER_NBR = D.CRSE_OFFER_NBR (+)
AND A.STRM = D.STRM (+)
AND A.SESSION_CODE = D.SESSION_CODE (+)
AND A.CLASS_SECTION = D.CLASS_SECTION (+)
AND D.EMPLID = E.EMPLID (+)
AND 'BUSN' = E.E_ADDR_TYPE (+) )
ORDER BY 1, 2, 4