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
  • No labels