VIEW: APPS.IGS_PS_OFR_VERSION_V

Source

View Text - Preformatted

SELECT crv.course_type, co.course_cd, co.version_number, co.CAL_TYPE, crv.course_status, crv.responsible_org_unit_cd, co.created_by, co.creation_date, co.last_updated_by, co.last_update_date, co.last_update_login FROM IGS_PS_OFR co, IGS_PS_VER crv, IGS_PS_STAT crst, IGS_CA_TYPE cat WHERE (co.course_cd = crv.course_cd AND co.version_number = crv.version_number AND crv.course_status = crst.course_status AND crst.s_course_status != 'INACTIVE') AND (co.CAL_TYPE = cat.CAL_TYPE AND cat.s_cal_cat = 'ACADEMIC')

View Text - HTML Formatted

SELECT CRV.COURSE_TYPE
, CO.COURSE_CD
, CO.VERSION_NUMBER
, CO.CAL_TYPE
, CRV.COURSE_STATUS
, CRV.RESPONSIBLE_ORG_UNIT_CD
, CO.CREATED_BY
, CO.CREATION_DATE
, CO.LAST_UPDATED_BY
, CO.LAST_UPDATE_DATE
, CO.LAST_UPDATE_LOGIN
FROM IGS_PS_OFR CO
, IGS_PS_VER CRV
, IGS_PS_STAT CRST
, IGS_CA_TYPE CAT
WHERE (CO.COURSE_CD = CRV.COURSE_CD
AND CO.VERSION_NUMBER = CRV.VERSION_NUMBER
AND CRV.COURSE_STATUS = CRST.COURSE_STATUS
AND CRST.S_COURSE_STATUS != 'INACTIVE')
AND (CO.CAL_TYPE = CAT.CAL_TYPE
AND CAT.S_CAL_CAT = 'ACADEMIC')