VIEW: APPS.IGSFV_ADVISING_GROUPS

Source

View Text - Preformatted

SELECT azg.GROUP_NAME, azg.GROUP_DESC, azg.ADVISING_CODE, '_LA:ADVISING_CODE:IGS_LOOKUP_VALUES:IGS_AZ_ADVISING_CODE:MEANING', azg.RESP_ORG_UNIT_CD, azg.RESP_PERSON_ID, azg.DELIVERY_METHOD_CODE, '_LA:DELIVERY_METHOD_CODE:IGS_LOOKUP_VALUES:IGS_AZ_DELIV_METHOD:MEANING', azg.ADVISOR_GROUP_ID, azg.STUDENT_GROUP_ID, azg.DEFAULT_ADVISOR_LOAD_NUM, azg.MANDATORY_FLAG, azg.ADVISING_SESSIONS_NUM, azg.ADVISING_HOLD_TYPE, azg.CLOSED_FLAG, azg.COMMENTS_TXT, azg.AUTO_REFRESH_FLAG, azg.LAST_AUTO_REFRESH_DATE, azg.AUTO_STDNT_ADD_FLAG, azg.AUTO_STDNT_REMOVE_FLAG, azg.AUTO_ADVISOR_ADD_FLAG, azg.AUTO_ADVISOR_REMOVE_FLAG, azg.AUTO_MATCH_FLAG, azg.AUTO_APPLY_HOLD_FLAG, azg.LOCATION_CD, '_DF:IGS:IGS_AZ_GROUPS_FLEX:AZG', azg.CREATED_BY, azg.CREATION_DATE, azg.LAST_UPDATED_BY, azg.LAST_UPDATE_DATE, PE.PARTY_NUMBER , OU.PARTY_NAME , LOC.DESCRIPTION , '_LA:MANDATORY_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:CLOSED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:AUTO_REFRESH_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:AUTO_STDNT_ADD_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:AUTO_STDNT_REMOVE_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:AUTO_ADVISOR_ADD_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:AUTO_ADVISOR_REMOVE_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:AUTO_MATCH_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:AUTO_APPLY_HOLD_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING', ENC.DESCRIPTION, GR1.DESCRIPTION , GR2.DESCRIPTION FROM IGS_AZ_GROUPS AZG, HZ_PARTIES PE, HZ_PARTIES OU, IGS_AD_LOCATION_ALL LOC, IGS_FI_ENCMB_TYPE_ALL ENC, IGS_PE_PERSID_GROUP_ALL GR1, IGS_PE_PERSID_GROUP_ALL GR2, igs_pe_hz_parties ipz WHERE AZG.RESP_PERSON_ID = PE.PARTY_ID(+) AND AZG.RESP_ORG_UNIT_CD = ipz.oss_org_unit_cd AND AZG.LOCATION_CD = LOC.LOCATION_CD(+) AND AZG.ADVISING_HOLD_TYPE = ENC.ENCUMBRANCE_TYPE(+) AND GR1.GROUP_ID(+) = AZG.STUDENT_GROUP_ID AND GR2.GROUP_ID(+) = AZG.ADVISOR_GROUP_ID AND ipz.party_id = ou.party_id WITH READ ONLY

View Text - HTML Formatted

SELECT AZG.GROUP_NAME
, AZG.GROUP_DESC
, AZG.ADVISING_CODE
, '_LA:ADVISING_CODE:IGS_LOOKUP_VALUES:IGS_AZ_ADVISING_CODE:MEANING'
, AZG.RESP_ORG_UNIT_CD
, AZG.RESP_PERSON_ID
, AZG.DELIVERY_METHOD_CODE
, '_LA:DELIVERY_METHOD_CODE:IGS_LOOKUP_VALUES:IGS_AZ_DELIV_METHOD:MEANING'
, AZG.ADVISOR_GROUP_ID
, AZG.STUDENT_GROUP_ID
, AZG.DEFAULT_ADVISOR_LOAD_NUM
, AZG.MANDATORY_FLAG
, AZG.ADVISING_SESSIONS_NUM
, AZG.ADVISING_HOLD_TYPE
, AZG.CLOSED_FLAG
, AZG.COMMENTS_TXT
, AZG.AUTO_REFRESH_FLAG
, AZG.LAST_AUTO_REFRESH_DATE
, AZG.AUTO_STDNT_ADD_FLAG
, AZG.AUTO_STDNT_REMOVE_FLAG
, AZG.AUTO_ADVISOR_ADD_FLAG
, AZG.AUTO_ADVISOR_REMOVE_FLAG
, AZG.AUTO_MATCH_FLAG
, AZG.AUTO_APPLY_HOLD_FLAG
, AZG.LOCATION_CD
, '_DF:IGS:IGS_AZ_GROUPS_FLEX:AZG'
, AZG.CREATED_BY
, AZG.CREATION_DATE
, AZG.LAST_UPDATED_BY
, AZG.LAST_UPDATE_DATE
, PE.PARTY_NUMBER
, OU.PARTY_NAME
, LOC.DESCRIPTION
, '_LA:MANDATORY_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:CLOSED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AUTO_REFRESH_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AUTO_STDNT_ADD_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AUTO_STDNT_REMOVE_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AUTO_ADVISOR_ADD_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AUTO_ADVISOR_REMOVE_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AUTO_MATCH_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:AUTO_APPLY_HOLD_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, ENC.DESCRIPTION
, GR1.DESCRIPTION
, GR2.DESCRIPTION
FROM IGS_AZ_GROUPS AZG
, HZ_PARTIES PE
, HZ_PARTIES OU
, IGS_AD_LOCATION_ALL LOC
, IGS_FI_ENCMB_TYPE_ALL ENC
, IGS_PE_PERSID_GROUP_ALL GR1
, IGS_PE_PERSID_GROUP_ALL GR2
, IGS_PE_HZ_PARTIES IPZ
WHERE AZG.RESP_PERSON_ID = PE.PARTY_ID(+)
AND AZG.RESP_ORG_UNIT_CD = IPZ.OSS_ORG_UNIT_CD
AND AZG.LOCATION_CD = LOC.LOCATION_CD(+)
AND AZG.ADVISING_HOLD_TYPE = ENC.ENCUMBRANCE_TYPE(+)
AND GR1.GROUP_ID(+) = AZG.STUDENT_GROUP_ID
AND GR2.GROUP_ID(+) = AZG.ADVISOR_GROUP_ID
AND IPZ.PARTY_ID = OU.PARTY_ID WITH READ ONLY