View: IGS_AZ_ADVISORS_V

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

View Text

SELECT AZA.ROWID ROW_ID
, AZA.GROUP_ADVISOR_ID
, AZA.GROUP_NAME
, AG.GROUP_DESC
, AZA.ADVISOR_PERSON_ID
, HZ.PARTY_NUMBER
, HZ.PERSON_LAST_NAME ||'
, '|| HZ.PERSON_FIRST_NAME||DECODE(HZ.PERSON_MIDDLE_NAME
, NULL
, ''
, ' ') || HZ.PERSON_MIDDLE_NAME
, AZA.START_DATE
, AZA.END_DATE
, AZA.MAX_STUDENTS_NUM
, AZA.NOTIFIED_DATE
, AZA.ACCEPT_ADD_FLAG
, AZA.ACCEPT_DELETE_FLAG
, AG.ADVISOR_GROUP_ID
, PG.GROUP_CD
, PG.DESCRIPTION
, AG.DELIVERY_METHOD_CODE
, AZA.CREATED_BY
, AZA.CREATION_DATE
, AZA.LAST_UPDATED_BY
, AZA.LAST_UPDATE_DATE
, AZA.LAST_UPDATE_LOGIN
FROM IGS_AZ_ADVISORS AZA
, IGS_AZ_GROUPS AG
, HZ_PARTIES HZ
, IGS_PE_PERSID_GROUP_ALL PG
WHERE AZA.GROUP_NAME = AG.GROUP_NAME
AND AZA.ADVISOR_PERSON_ID = HZ.PARTY_ID
AND PG.GROUP_ID(+) = AG.ADVISOR_GROUP_ID

Columns