VIEW: APPS.IGSBV_ADVISING_GROUPS

Source

View Text - Preformatted

SELECT GROUP_NAME, GROUP_DESC, ADVISING_CODE, '_LA:ADVISING_CODE:IGS_LOOKUP_VALUES:IGS_AZ_ADVISING_CODE:MEANING', RESP_ORG_UNIT_CD, RESP_PERSON_ID, DELIVERY_METHOD_CODE, '_LA:DELIVERY_METHOD_CODE:IGS_LOOKUP_VALUES:IGS_AZ_DELIV_METHOD:MEANING', ADVISOR_GROUP_ID, STUDENT_GROUP_ID, DEFAULT_ADVISOR_LOAD_NUM, MANDATORY_FLAG, ADVISING_SESSIONS_NUM, ADVISING_HOLD_TYPE, CLOSED_FLAG, COMMENTS_TXT, AUTO_REFRESH_FLAG, LAST_AUTO_REFRESH_DATE, AUTO_STDNT_ADD_FLAG, AUTO_STDNT_REMOVE_FLAG, AUTO_ADVISOR_ADD_FLAG, AUTO_ADVISOR_REMOVE_FLAG, AUTO_MATCH_FLAG, AUTO_APPLY_HOLD_FLAG, LOCATION_CD,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGS_AZ_GROUPS WITH READ ONLY

View Text - HTML Formatted

SELECT GROUP_NAME
, GROUP_DESC
, ADVISING_CODE
, '_LA:ADVISING_CODE:IGS_LOOKUP_VALUES:IGS_AZ_ADVISING_CODE:MEANING'
, RESP_ORG_UNIT_CD
, RESP_PERSON_ID
, DELIVERY_METHOD_CODE
, '_LA:DELIVERY_METHOD_CODE:IGS_LOOKUP_VALUES:IGS_AZ_DELIV_METHOD:MEANING'
, ADVISOR_GROUP_ID
, STUDENT_GROUP_ID
, DEFAULT_ADVISOR_LOAD_NUM
, MANDATORY_FLAG
, ADVISING_SESSIONS_NUM
, ADVISING_HOLD_TYPE
, CLOSED_FLAG
, COMMENTS_TXT
, AUTO_REFRESH_FLAG
, LAST_AUTO_REFRESH_DATE
, AUTO_STDNT_ADD_FLAG
, AUTO_STDNT_REMOVE_FLAG
, AUTO_ADVISOR_ADD_FLAG
, AUTO_ADVISOR_REMOVE_FLAG
, AUTO_MATCH_FLAG
, AUTO_APPLY_HOLD_FLAG
, LOCATION_CD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGS_AZ_GROUPS WITH READ ONLY