VIEW: APPS.IGSBV_AS_ANONYMOUS_ID_UNITS

Source

View Text - Preformatted

SELECT HP.PARTY_NAME, HP.PARTY_NUMBER, ASEC.ANONYMOUS_ID, '_LA:ASEC.SYSTEM_GENERATED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', ASEC.COURSE_CD, CRV.TITLE, ASEC.UNIT_CD, UV.TITLE, UOO.LOCATION_CD, LOC.DESCRIPTION, ASEC.TEACH_CAL_TYPE, ASEC.TEACH_CI_SEQUENCE_NUMBER, CI.DESCRIPTION, UOO.UNIT_CLASS, UC.DESCRIPTION, ASEC.LOAD_CAL_TYPE, ASEC.LOAD_CI_SEQUENCE_NUMBER, ASEC.PERSON_ID, uoo.uoo_id, ASEC.CREATED_BY, ASEC.CREATION_DATE, ASEC.LAST_UPDATED_BY, ASEC.LAST_UPDATE_DATE FROM HZ_PARTIES HP, IGS_AS_ANON_ID_US ASEC, IGS_PS_VER_ALL CRV, IGS_PS_UNIT_VER_ALL UV, IGS_CA_INST_ALL CI, IGS_PS_UNIT_OFR_OPT_ALL UOO, IGS_AD_LOCATION_ALL LOC, IGS_AS_UNIT_CLASS_ALL UC, IGS_EN_STDNT_PS_ATT_ALL SPA WHERE ASEC.PERSON_ID = HP.PARTY_ID AND ASEC.TEACH_CAL_TYPE = CI.CAL_TYPE AND ASEC.TEACH_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND ASEC.UOO_ID = UOO.UOO_ID AND UOO.UNIT_CD = UV.UNIT_CD AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER AND UOO.LOCATION_CD = LOC.LOCATION_CD AND UOO.UNIT_CLASS = UC.UNIT_CLASS AND ASEC.PERSON_ID = SPA.PERSON_ID AND ASEC.COURSE_CD = SPA.COURSE_CD AND SPA.COURSE_CD = CRV.COURSE_CD AND SPA.VERSION_NUMBER = CRV.VERSION_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, ASEC.ANONYMOUS_ID
, '_LA:ASEC.SYSTEM_GENERATED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, ASEC.COURSE_CD
, CRV.TITLE
, ASEC.UNIT_CD
, UV.TITLE
, UOO.LOCATION_CD
, LOC.DESCRIPTION
, ASEC.TEACH_CAL_TYPE
, ASEC.TEACH_CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, UOO.UNIT_CLASS
, UC.DESCRIPTION
, ASEC.LOAD_CAL_TYPE
, ASEC.LOAD_CI_SEQUENCE_NUMBER
, ASEC.PERSON_ID
, UOO.UOO_ID
, ASEC.CREATED_BY
, ASEC.CREATION_DATE
, ASEC.LAST_UPDATED_BY
, ASEC.LAST_UPDATE_DATE
FROM HZ_PARTIES HP
, IGS_AS_ANON_ID_US ASEC
, IGS_PS_VER_ALL CRV
, IGS_PS_UNIT_VER_ALL UV
, IGS_CA_INST_ALL CI
, IGS_PS_UNIT_OFR_OPT_ALL UOO
, IGS_AD_LOCATION_ALL LOC
, IGS_AS_UNIT_CLASS_ALL UC
, IGS_EN_STDNT_PS_ATT_ALL SPA
WHERE ASEC.PERSON_ID = HP.PARTY_ID
AND ASEC.TEACH_CAL_TYPE = CI.CAL_TYPE
AND ASEC.TEACH_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND ASEC.UOO_ID = UOO.UOO_ID
AND UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOO.LOCATION_CD = LOC.LOCATION_CD
AND UOO.UNIT_CLASS = UC.UNIT_CLASS
AND ASEC.PERSON_ID = SPA.PERSON_ID
AND ASEC.COURSE_CD = SPA.COURSE_CD
AND SPA.COURSE_CD = CRV.COURSE_CD
AND SPA.VERSION_NUMBER = CRV.VERSION_NUMBER WITH READ ONLY