View: IGS_PS_UNIT_UNIT_VERSION_V

Product:	IGS - Student System
Description:	This view includes the title of the latest active version of a unit
Implementation/DBA Data:	APPS.IGS_PS_UNIT_UNIT_VERSION_V

View Text

SELECT UNIQUE UN.UNIT_CD
, UV.TITLE
, UN.CREATED_BY
, UN.CREATION_DATE
, UN.LAST_UPDATED_BY
, UN.LAST_UPDATE_DATE
, UN.LAST_UPDATE_LOGIN FROM IGS_PS_UNIT_STAT US
, IGS_PS_UNIT_VER UV
, IGS_PS_UNIT UN
WHERE UN.UNIT_CD = UV.UNIT_CD AND UV.EXPIRY_DT IS NULL AND UV.UNIT_STATUS = US.UNIT_STATUS AND US.S_UNIT_STATUS != 'INACTIVE'

Columns