View: IGSFV_HIGH_EDU_UNIT_CATEGORIES

Product:	IGS - Student System
Description:	This is a full view, which describes the categories that are applied to a unit. There can be multiple categories for each unit.
Implementation/DBA Data:	APPS.IGSFV_HIGH_EDU_UNIT_CATEGORIES

View Text

SELECT UNA.UNIT_CD UNIT_CODE
, UNA.VERSION_NUMBER UNIT_VERSION_NUMBER
, UNA.UNIT_CAT UNIT_CATEGORY
, UNV.TITLE UNIT_TITLE
, UNC.DESCRIPTION UNIT_CATEGORY_DESCRIPTION
, UNA.CREATED_BY
, UNA.CREATION_DATE
, UNA.LAST_UPDATED_BY
, UNA.LAST_UPDATE_DATE
FROM IGS_PS_UNIT_CATEGORY_ALL UNA
, IGS_PS_UNIT_CAT UNC
, IGS_PS_UNIT_VER_ALL UNV
WHERE UNA.UNIT_CAT = UNC.UNIT_CAT
AND UNA.UNIT_CD = UNV.UNIT_CD
AND UNA.VERSION_NUMBER = UNV.VERSION_NUMBER WITH READ ONLY

Columns