VIEW: APPS.IGS_AZ_ADVISORS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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