Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT AN.ROWID ROW_ID
, AN.APPL_NOTES_ID APPL_NOTES_ID
, AN.PERSON_ID PERSON_ID
, AN.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, AN.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, AN.SEQUENCE_NUMBER SEQUENCE_NUMBER
, AN.NOTE_TYPE_ID NOTE_TYPE_ID
, AN.REF_NOTES_ID REF_NOTES_ID
, AN.CREATED_BY CREATED_BY
, AN.CREATION_DATE CREATION_DATE
, AN.LAST_UPDATED_BY LAST_UPDATED_BY
, AN.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AN.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NT.NOTES_CATEGORY NOTES_CATEGORY
, NT.NOTE_TYPE NOTE_TYPE
, NT.DESCRIPTION DESCRIPTION
FROM IGS_AD_APPL_NOTES AN
, IGS_AD_NOTE_TYPES NT
WHERE AN.NOTE_TYPE_ID = NT.NOTES_TYPE_ID