VIEW: APPS.IGS_EN_UNIT_SET_COURSE_TYPE_V

Source

View Text - Preformatted

SELECT usct.course_type, us.unit_set_cd, us.version_number, us.created_by, us.creation_date, us.last_updated_by, us.last_update_date, us.last_update_login from IGS_EN_UNIT_SET us, IGS_EN_UNITSETPSTYPE usct WHERE us.unit_set_cd = usct.unit_set_cd and us.version_number = usct.version_number UNION select cty.course_type, us.unit_set_cd, us.version_number, us.created_by, us.creation_date, us.last_updated_by, us.last_update_date, us.last_update_login from IGS_PS_TYPE cty, IGS_EN_UNIT_SET us where NOT EXISTS ( select usct.unit_set_cd from IGS_EN_UNITSETPSTYPE usct where usct.unit_set_cd = us.unit_set_cd and usct.version_number = us.version_number)

View Text - HTML Formatted

SELECT USCT.COURSE_TYPE
, US.UNIT_SET_CD
, US.VERSION_NUMBER
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
, US.LAST_UPDATE_LOGIN
FROM IGS_EN_UNIT_SET US
, IGS_EN_UNITSETPSTYPE USCT
WHERE US.UNIT_SET_CD = USCT.UNIT_SET_CD
AND US.VERSION_NUMBER = USCT.VERSION_NUMBER UNION SELECT CTY.COURSE_TYPE
, US.UNIT_SET_CD
, US.VERSION_NUMBER
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
, US.LAST_UPDATE_LOGIN
FROM IGS_PS_TYPE CTY
, IGS_EN_UNIT_SET US
WHERE NOT EXISTS ( SELECT USCT.UNIT_SET_CD
FROM IGS_EN_UNITSETPSTYPE USCT
WHERE USCT.UNIT_SET_CD = US.UNIT_SET_CD
AND USCT.VERSION_NUMBER = US.VERSION_NUMBER)