SELECT A.EMPLID, B.LAST_NAME, B.FIRST_NAME, B.MIDDLE_NAME, A.ACAD_CAREER, A.CLASS_NBR, A.SUBJECT, A.CATALOG_NBR, A.CLASS_SECTION, A.SESSION_CODE, TO_CHAR(CAST((A.MEETING_TIME_START) AS TIMESTAMP),'HH24.MI.SS.FF'), TO_CHAR(CAST((A.MEETING_TIME_END) AS TIMESTAMP),'HH24.MI.SS.FF'), decode ( A.MON, 'Y', 'Mo') || decode ( A.TUES, 'Y', 'Tu') || decode ( A.WED, 'Y', 'We') || decode ( A.THURS, 'Y', 'Th') || decode ( A.FRI, 'Y', 'Fr') || decode ( A.SAT, 'Y', 'Sa') || decode ( A.SUN, 'Y', 'Su'), C.CLASS_NBR, C.SUBJECT, C.CATALOG_NBR, C.CLASS_SECTION, C.SESSION_CODE, 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') FROM PS_CLASS_MTG_VW2 A, PS_CU_BIO_VW B, PS_CLASS_MTG_VW2 C WHERE ( A.INSTITUTION = :1 AND A.STRM = :2 AND A.STDNT_ENRL_STATUS = 'E' AND A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND A.ACAD_CAREER = C.ACAD_CAREER AND A.INSTITUTION = C.INSTITUTION AND A.STRM = C.STRM AND A.CLASS_NBR < C.CLASS_NBR AND C.STDNT_ENRL_STATUS = 'E' AND A.SESSION_CODE = C.SESSION_CODE AND (( A.MON = C.MON AND A.MON = 'Y') OR ( A.TUES = C.TUES AND A.TUES = 'Y') OR ( A.WED = C.WED AND A.WED = 'Y') OR ( A.THURS = C.THURS AND A.THURS = 'Y') OR ( A.FRI = C.FRI AND A.FRI = 'Y') OR ( A.SAT = C.SAT AND A.SAT = 'Y') OR ( A.SUN = C.SUN AND A.SUN = 'Y')) AND (( A.MEETING_TIME_START > C.MEETING_TIME_START AND A.MEETING_TIME_START < C.MEETING_TIME_END) OR ( A.MEETING_TIME_END > C.MEETING_TIME_START AND A.MEETING_TIME_END < C.MEETING_TIME_END)) ) ORDER BY 2, 3, 4, 6 |