VIEW: APPS.IGS_PR_MILESTONE_CRV_ATT_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)