VIEW: APPS.IGS_AZ_STUDENTS_V

Source

View Text - Preformatted

SELECT azs.rowid row_id , azs.group_student_id , azs.group_name, ag.group_desc, azs.student_person_id , hz.party_number , hz.person_Last_name ||', '|| hz.Person_first_name||decode(hz.person_middle_name ,null,'',' ') || hz.person_middle_name, azs.start_DATE , azs.end_DATE , azs.advising_hold_type , azs.hold_start_DATE , (SELECT pe.expiry_dt FROM igs_pe_pers_encumb pe WHERE pe.person_id = azs.student_person_id AND pe.encumbrance_type = azs.advising_hold_type AND pe.start_dt = azs.hold_start_DATE) HOLD_END_DATE , azs.notified_DATE , azs.accept_add_FLAG , azs.accept_delete_FLAG , azs.created_by, azs.creation_date , azs.last_updated_by , azs.last_update_date , azs.last_update_login , ag.student_group_id , pg.group_cd STUDENT_GROUP_CD, pg.description STUDENT_GROUP_DESC, ag.delivery_method_code FROM igs_az_students azs, igs_az_groups ag, hz_parties hz, igs_pe_persid_group_all pg WHERE azs.group_name = ag.group_name AND azs.student_person_id = hz.party_id and pg.group_id(+) = ag.student_group_id

View Text - HTML Formatted

SELECT AZS.ROWID ROW_ID
, AZS.GROUP_STUDENT_ID
, AZS.GROUP_NAME
, AG.GROUP_DESC
, AZS.STUDENT_PERSON_ID
, HZ.PARTY_NUMBER
, HZ.PERSON_LAST_NAME ||'
, '|| HZ.PERSON_FIRST_NAME||DECODE(HZ.PERSON_MIDDLE_NAME
, NULL
, ''
, ' ') || HZ.PERSON_MIDDLE_NAME
, AZS.START_DATE
, AZS.END_DATE
, AZS.ADVISING_HOLD_TYPE
, AZS.HOLD_START_DATE
, (SELECT PE.EXPIRY_DT
FROM IGS_PE_PERS_ENCUMB PE
WHERE PE.PERSON_ID = AZS.STUDENT_PERSON_ID
AND PE.ENCUMBRANCE_TYPE = AZS.ADVISING_HOLD_TYPE
AND PE.START_DT = AZS.HOLD_START_DATE) HOLD_END_DATE
, AZS.NOTIFIED_DATE
, AZS.ACCEPT_ADD_FLAG
, AZS.ACCEPT_DELETE_FLAG
, AZS.CREATED_BY
, AZS.CREATION_DATE
, AZS.LAST_UPDATED_BY
, AZS.LAST_UPDATE_DATE
, AZS.LAST_UPDATE_LOGIN
, AG.STUDENT_GROUP_ID
, PG.GROUP_CD STUDENT_GROUP_CD
, PG.DESCRIPTION STUDENT_GROUP_DESC
, AG.DELIVERY_METHOD_CODE
FROM IGS_AZ_STUDENTS AZS
, IGS_AZ_GROUPS AG
, HZ_PARTIES HZ
, IGS_PE_PERSID_GROUP_ALL PG
WHERE AZS.GROUP_NAME = AG.GROUP_NAME
AND AZS.STUDENT_PERSON_ID = HZ.PARTY_ID
AND PG.GROUP_ID(+) = AG.STUDENT_GROUP_ID