Product: | IGS - Student System |
---|---|
Description: | Academic Honors View |
Implementation/DBA Data: | APPS.IGS_PE_ACAD_HONORS_V |
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'