VIEW: APPS.IGSFV_ADVISING_STUDENTS

Source

View Text - Preformatted

SELECT azs.GROUP_STUDENT_ID, azs.GROUP_NAME, azs.STUDENT_PERSON_ID, azs.START_DATE, azs.END_DATE, azs.ADVISING_HOLD_TYPE, azs.HOLD_START_DATE, azs.NOTIFIED_DATE, azs.ACCEPT_ADD_FLAG, '_LA:ACCEPT_ADD_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING', azs.ACCEPT_DELETE_FLAG, '_LA:ACCEPT_DELETE_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING', AZG.GROUP_DESC, PE.PARTY_NUMBER, ENC.DESCRIPTION, azs.CREATED_BY, azs.CREATION_DATE, azs.LAST_UPDATED_BY, azs.LAST_UPDATE_DATE from igs_Az_students azs, IGS_AZ_GROUPS AZG, HZ_PARTIES PE, IGS_FI_ENCMB_TYPE_ALL ENC WHERE azs.GROUP_NAME = AZG.GROUP_NAME AND AZS.STUDENT_PERSON_ID = PE.PARTY_ID AND ENC.ENCUMBRANCE_TYPE = AZS.ADVISING_HOLD_TYPE WITH READ ONLY

View Text - HTML Formatted

SELECT AZS.GROUP_STUDENT_ID
, AZS.GROUP_NAME
, AZS.STUDENT_PERSON_ID
, AZS.START_DATE
, AZS.END_DATE
, AZS.ADVISING_HOLD_TYPE
, AZS.HOLD_START_DATE
, AZS.NOTIFIED_DATE
, AZS.ACCEPT_ADD_FLAG
, '_LA:ACCEPT_ADD_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, AZS.ACCEPT_DELETE_FLAG
, '_LA:ACCEPT_DELETE_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, AZG.GROUP_DESC
, PE.PARTY_NUMBER
, ENC.DESCRIPTION
, AZS.CREATED_BY
, AZS.CREATION_DATE
, AZS.LAST_UPDATED_BY
, AZS.LAST_UPDATE_DATE
FROM IGS_AZ_STUDENTS AZS
, IGS_AZ_GROUPS AZG
, HZ_PARTIES PE
, IGS_FI_ENCMB_TYPE_ALL ENC
WHERE AZS.GROUP_NAME = AZG.GROUP_NAME
AND AZS.STUDENT_PERSON_ID = PE.PARTY_ID
AND ENC.ENCUMBRANCE_TYPE = AZS.ADVISING_HOLD_TYPE WITH READ ONLY