VIEW: APPS.IGS_AZ_ADVISING_RELS_V

Source

View Text - Preformatted

SELECT azrel.rowid, azrel.group_name, hp1.person_last_name ||', '||hp1.person_first_name||' '||hp1.person_middle_name , hp1.party_number , hp2.person_last_name ||', '||hp2.person_first_name||' '||hp2.person_middle_name , hp2.party_number, azrel.start_date , azrel.end_date , azrel.GROUP_ADVISING_REL_ID , azrel.GROUP_ADVISOR_ID , azrel.GROUP_STUDENT_ID , azstu.STUDENT_PERSON_ID, azadv.ADVISOR_PERSON_ID, azrel.CREATED_BY, azrel.CREATION_DATE, azrel.LAST_UPDATED_BY, azrel.LAST_UPDATE_DATE, azrel.LAST_UPDATE_LOGIN FROM igs_az_advising_rels azrel, igs_az_students azstu, igs_az_advisors azadv, hz_parties hp1, hz_parties hp2 WHERE azrel.GROUP_STUDENT_ID = azstu.GROUP_STUDENT_ID AND azrel.GROUP_NAME = azstu.GROUP_NAME AND azrel.GROUP_ADVISOR_ID = azadv.GROUP_ADVISOR_ID AND azrel.GROUP_NAME = azadv.GROUP_NAME AND azstu.student_person_id = hp1.party_id AND azadv.advisor_person_id = hp2.party_id

View Text - HTML Formatted

SELECT AZREL.ROWID
, AZREL.GROUP_NAME
, HP1.PERSON_LAST_NAME ||'
, '||HP1.PERSON_FIRST_NAME||' '||HP1.PERSON_MIDDLE_NAME
, HP1.PARTY_NUMBER
, HP2.PERSON_LAST_NAME ||'
, '||HP2.PERSON_FIRST_NAME||' '||HP2.PERSON_MIDDLE_NAME
, HP2.PARTY_NUMBER
, AZREL.START_DATE
, AZREL.END_DATE
, AZREL.GROUP_ADVISING_REL_ID
, AZREL.GROUP_ADVISOR_ID
, AZREL.GROUP_STUDENT_ID
, AZSTU.STUDENT_PERSON_ID
, AZADV.ADVISOR_PERSON_ID
, AZREL.CREATED_BY
, AZREL.CREATION_DATE
, AZREL.LAST_UPDATED_BY
, AZREL.LAST_UPDATE_DATE
, AZREL.LAST_UPDATE_LOGIN
FROM IGS_AZ_ADVISING_RELS AZREL
, IGS_AZ_STUDENTS AZSTU
, IGS_AZ_ADVISORS AZADV
, HZ_PARTIES HP1
, HZ_PARTIES HP2
WHERE AZREL.GROUP_STUDENT_ID = AZSTU.GROUP_STUDENT_ID
AND AZREL.GROUP_NAME = AZSTU.GROUP_NAME
AND AZREL.GROUP_ADVISOR_ID = AZADV.GROUP_ADVISOR_ID
AND AZREL.GROUP_NAME = AZADV.GROUP_NAME
AND AZSTU.STUDENT_PERSON_ID = HP1.PARTY_ID
AND AZADV.ADVISOR_PERSON_ID = HP2.PARTY_ID