View: IGSFV_ADVISING_RELATIONS

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

View Text

SELECT AZR.GROUP_ADVISING_REL_ID
, AZR.GROUP_NAME
, AZR.GROUP_ADVISOR_ID
, AZR.GROUP_STUDENT_ID
, AZR.START_DATE
, AZR.END_DATE
, AZS.STUDENT_PERSON_ID
, PE1.PARTY_NUMBER
, AZA.ADVISOR_PERSON_ID
, PE2.PARTY_NUMBER
, AZG.GROUP_DESC
, AZR.CREATED_BY
, AZR.CREATION_DATE
, AZR.LAST_UPDATED_BY
, AZR.LAST_UPDATE_DATE
FROM IGS_AZ_ADVISING_RELS AZR
, IGS_AZ_GROUPS AZG
, IGS_AZ_STUDENTS AZS
, IGS_AZ_ADVISORS AZA
, HZ_PARTIES PE1
, HZ_PARTIES PE2
WHERE AZR.GROUP_NAME = AZG.GROUP_NAME
AND AZR.GROUP_STUDENT_ID = AZS.GROUP_STUDENT_ID
AND AZR. GROUP_NAME = AZS. GROUP_NAME
AND PE1.PARTY_ID = AZS.STUDENT_PERSON_ID
AND AZR.GROUP_ADVISOR_ID = AZA.GROUP_ADVISOR_ID
AND AZR. GROUP_NAME = AZA. GROUP_NAME
AND PE2.PARTY_ID = AZA.ADVISOR_PERSON_ID WITH READ ONLY

Columns