View: IGSFV_ADVISING_ADVISORS

Product:	IGS - Student System
Description:	View to display the advisor information for the advising functionality.
Implementation/DBA Data:	APPS.IGSFV_ADVISING_ADVISORS

View Text

SELECT AZA.GROUP_ADVISOR_ID
, AZA.GROUP_NAME
, AZA.ADVISOR_PERSON_ID
, AZA.START_DATE
, AZA.END_DATE
, AZA.MAX_STUDENTS_NUM
, AZA.NOTIFIED_DATE
, AZA.ACCEPT_ADD_FLAG
, '_LA:ACCEPT_ADD_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, AZA.ACCEPT_DELETE_FLAG
, '_LA:ACCEPT_DELETE_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, AZG.GROUP_DESC
, PE.PARTY_NUMBER
, AZA.CREATED_BY
, AZA.CREATION_DATE
, AZA.LAST_UPDATED_BY
, AZA.LAST_UPDATE_DATE
FROM IGS_AZ_ADVISORS AZA
, IGS_AZ_GROUPS AZG
, HZ_PARTIES PE
WHERE AZA.GROUP_NAME = AZG.GROUP_NAME
AND AZA.ADVISOR_PERSON_ID = PE.PARTY_ID WITH READ ONLY

Columns