VIEW: APPS.IGSFV_ADVISING_RELATIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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