SELECT COO.COURSE_CD , COO.VERSION_NUMBER , COO.ATTENDANCE_TYPE , COO.ATTENDANCE_MODE , ATT.DESCRIPTION , COO.CREATED_BY , COO.CREATION_DATE , COO.LAST_UPDATED_BY , COO.LAST_UPDATE_DATE , COO.LAST_UPDATE_LOGIN FROM IGS_PS_OFR_OPT COO , IGS_EN_ATD_TYPE ATT WHERE ATT.ATTENDANCE_TYPE = COO.ATTENDANCE_TYPE AND COO.DELETE_FLAG='N' AND COO.ROWID = (SELECT MAX(ROWID) FROM IGS_PS_OFR_OPT COO1 WHERE COO1.COURSE_CD=COO.COURSE_CD AND COO1.VERSION_NUMBER=COO.VERSION_NUMBER AND COO1.ATTENDANCE_TYPE=COO.ATTENDANCE_TYPE AND COO1.ATTENDANCE_MODE=COO.ATTENDANCE_MODE AND COO1.DELETE_FLAG='N') UNION SELECT DISTINCT DMS.COURSE_CD , DMS.VERSION_NUMBER , DMS.ATTENDANCE_TYPE , DMS.ATTENDANCE_MODE , ATT.DESCRIPTION , DMS.CREATED_BY , DMS.CREATION_DATE , DMS.LAST_UPDATED_BY , DMS.LAST_UPDATE_DATE , DMS.LAST_UPDATE_LOGIN FROM IGS_RE_DFLT_MS_SET DMS , IGS_EN_ATD_TYPE ATT WHERE ATT.ATTENDANCE_TYPE = DMS.ATTENDANCE_TYPE AND NOT EXISTS (SELECT 'X' FROM IGS_PS_OFR_OPT COO WHERE COO.COURSE_CD = DMS.COURSE_CD AND COO.VERSION_NUMBER = DMS.VERSION_NUMBER AND COO.ATTENDANCE_TYPE = DMS.ATTENDANCE_TYPE AND COO.ATTENDANCE_MODE = DMS.ATTENDANCE_MODE AND COO.DELETE_FLAG ='N') AND DMS.ROWID = (SELECT MAX(ROWID) FROM IGS_RE_DFLT_MS_SET DMS1 WHERE DMS1.COURSE_CD=DMS.COURSE_CD AND DMS1.VERSION_NUMBER=DMS.VERSION_NUMBER AND DMS1.ATTENDANCE_TYPE=DMS.ATTENDANCE_TYPE AND DMS1.ATTENDANCE_MODE=DMS.ATTENDANCE_MODE)
[Home] [Help]