View: IGSFV_FIELDS_OF_STUDY

Product:	IGS - Student System
Description:	This is the full view which describes university set of fields of study.
Implementation/DBA Data:	APPS.IGSFV_FIELDS_OF_STUDY

View Text

SELECT FOS.FIELD_OF_STUDY
, FOS.DESCRIPTION
, FOS.GOVT_FIELD_OF_STUDY
, FOS.CLOSED_IND
, RE.DESCRIPTION
, FOS.CREATED_BY
, FOS.CREATION_DATE
, FOS.LAST_UPDATED_BY
, FOS.LAST_UPDATE_DATE
FROM IGS_PS_FLD_OF_STUDY_ALL FOS
, IGS_RE_GV_FLD_OF_SDY RE
WHERE FOS.GOVT_FIELD_OF_STUDY = RE.GOVT_FIELD_OF_STUDY WITH READ ONLY

Columns