View: IGS_PE_ACAD_HONORS_V

Product:	IGS - Student System
Description:	Academic Honors View
Implementation/DBA Data:	APPS.IGS_PE_ACAD_HONORS_V

View Text

SELECT AH.ROWID ROW_ID
, AH.PERSON_ID
, AH.ACAD_HONOR_ID
, AH.ACAD_HONOR_TYPE
, LK.DESCRIPTION ACAD_HONOR_DESC
, AH.HONOR_DATE
, AH.COMMENTS
, AH.CREATED_BY
, AH.CREATION_DATE
, AH.LAST_UPDATED_BY
, AH.LAST_UPDATE_DATE
, AH.LAST_UPDATE_LOGIN
, AH.REQUEST_ID
, AH.PROGRAM_APPLICATION_ID
, AH.PROGRAM_ID
, AH.PROGRAM_UPDATE_DATE
FROM IGS_PE_ACAD_HONORS AH
, IGS_LOOKUP_VALUES LK
WHERE LK.LOOKUP_CODE = AH.ACAD_HONOR_TYPE
AND LK.LOOKUP_TYPE ='PE_ACAD_HONORS'

Columns