SELECT A.STRM, A.SESSION_CODE, A.INSTITUTION, A.ACAD_CAREER, A.SUBJECT, A.CATALOG_NBR, A.CLASS_SECTION, A.CLASS_NBR, A.DESCR, A.ENRL_TOT, A.ENRL_STAT, A.CLASS_STAT, A.CLASS_TYPE, A.ENRL_CAP, A.WAIT_CAP, A.WAIT_TOT, A.MIN_ENRL, A.SSR_COMPONENT, A.CRSE_ID, A.CRSE_OFFER_NBR, C.LAST_NAME, C.FIRST_NAME, TO_CHAR(A.START_DT,'YYYY-MM-DD'), TO_CHAR(A.END_DT,'YYYY-MM-DD') FROM PS_CLASS_TBL A, PS_CLASS_INSTR B, PS_CU_BIO_VW C WHERE ( A.INSTITUTION = :1 AND A.STRM = :2 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 B.EMPLID = C.EMPLID (+) ) ORDER BY 1, 2, 3, 4, 5, 6, 7 |