VIEW: APPS.IGS_AZ_GROUPS_V

Source

View Text - Preformatted

SELECT ROWID, GROUP_NAME, GROUP_DESC , ADVISING_CODE , RESP_ORG_UNIT_CD , (SELECT party_name from hz_parties hz, igs_pe_hz_parties ipz WHERE ipz.oss_org_unit_cd = resp_org_unit_cd and ipz.party_id = hz.party_id), RESP_PERSON_ID , (SELECT hz.person_Last_name ||', '|| hz.Person_first_name||decode(hz.person_middle_name ,null,'',' ') || hz.person_middle_name from hz_parties hz WHERE hz.party_id = RESP_PERSON_ID), LOCATION_CD , DELIVERY_METHOD_CODE , (SELECT meaning FROM igs_lookup_values WHERE lookup_type = 'IGS_AZ_DELIV_METHOD' AND lookup_Code = DELIVERY_METHOD_CODE), ADVISOR_GROUP_ID , (SELECT description FROM IGS_PE_PERSID_GROUP WHERE group_id = ADVISOR_GROUP_ID), STUDENT_GROUP_ID , (SELECT description FROM IGS_PE_PERSID_GROUP WHERE 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 , ATTRIBUTE_CATEGORY , ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE20 , CREATED_BY, CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN from igs_az_groups

View Text - HTML Formatted

SELECT ROWID
, GROUP_NAME
, GROUP_DESC
, ADVISING_CODE
, RESP_ORG_UNIT_CD
, (SELECT PARTY_NAME
FROM HZ_PARTIES HZ
, IGS_PE_HZ_PARTIES IPZ
WHERE IPZ.OSS_ORG_UNIT_CD = RESP_ORG_UNIT_CD
AND IPZ.PARTY_ID = HZ.PARTY_ID)
, RESP_PERSON_ID
, (SELECT HZ.PERSON_LAST_NAME ||'
, '|| HZ.PERSON_FIRST_NAME||DECODE(HZ.PERSON_MIDDLE_NAME
, NULL
, ''
, ' ') || HZ.PERSON_MIDDLE_NAME
FROM HZ_PARTIES HZ
WHERE HZ.PARTY_ID = RESP_PERSON_ID)
, LOCATION_CD
, DELIVERY_METHOD_CODE
, (SELECT MEANING
FROM IGS_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'IGS_AZ_DELIV_METHOD'
AND LOOKUP_CODE = DELIVERY_METHOD_CODE)
, ADVISOR_GROUP_ID
, (SELECT DESCRIPTION
FROM IGS_PE_PERSID_GROUP
WHERE GROUP_ID = ADVISOR_GROUP_ID)
, STUDENT_GROUP_ID
, (SELECT DESCRIPTION
FROM IGS_PE_PERSID_GROUP
WHERE 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
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS_AZ_GROUPS