VIEW: APPS.IGSBV_STU_PRG_CNCTRN_ATTEMPT

Source

View Text - Preformatted

SELECT susa.person_id, susa.course_cd, susa.unit_set_cd, susa.us_version_number, susa.sequence_number, susa.selection_dt, susa.student_confirmed_ind, susa.end_dt, susa.parent_unit_set_cd, susa.parent_sequence_number, susa.primary_set_ind, susa.voluntary_end_ind, susa.authorised_on, susa.authorised_person_id, susa.override_title, susa.rqrmnts_complete_ind, susa.rqrmnts_complete_dt, susa.s_completed_source_type, susa.catalog_cal_type, susa.catalog_seq_num, hp.party_number, psv.title, us.title, susa.created_by, susa.creation_date, susa.last_updated_by, susa.last_update_date FROM igs_as_su_setatmpt susa, hz_parties hp, igs_en_stdnt_ps_att_all sca, igs_ps_ver_all psv, igs_en_unit_set_all us WHERE susa.person_id = hp.party_id AND susa.person_id = sca.person_id AND susa.course_cd = sca.course_cd AND sca.course_cd = psv.course_cd AND sca.version_number = psv.version_number AND susa.unit_set_cd = us.unit_set_cd AND susa.us_version_number = us.version_number WITH READ ONLY

View Text - HTML Formatted

SELECT SUSA.PERSON_ID
, SUSA.COURSE_CD
, SUSA.UNIT_SET_CD
, SUSA.US_VERSION_NUMBER
, SUSA.SEQUENCE_NUMBER
, SUSA.SELECTION_DT
, SUSA.STUDENT_CONFIRMED_IND
, SUSA.END_DT
, SUSA.PARENT_UNIT_SET_CD
, SUSA.PARENT_SEQUENCE_NUMBER
, SUSA.PRIMARY_SET_IND
, SUSA.VOLUNTARY_END_IND
, SUSA.AUTHORISED_ON
, SUSA.AUTHORISED_PERSON_ID
, SUSA.OVERRIDE_TITLE
, SUSA.RQRMNTS_COMPLETE_IND
, SUSA.RQRMNTS_COMPLETE_DT
, SUSA.S_COMPLETED_SOURCE_TYPE
, SUSA.CATALOG_CAL_TYPE
, SUSA.CATALOG_SEQ_NUM
, HP.PARTY_NUMBER
, PSV.TITLE
, US.TITLE
, SUSA.CREATED_BY
, SUSA.CREATION_DATE
, SUSA.LAST_UPDATED_BY
, SUSA.LAST_UPDATE_DATE
FROM IGS_AS_SU_SETATMPT SUSA
, HZ_PARTIES HP
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_PS_VER_ALL PSV
, IGS_EN_UNIT_SET_ALL US
WHERE SUSA.PERSON_ID = HP.PARTY_ID
AND SUSA.PERSON_ID = SCA.PERSON_ID
AND SUSA.COURSE_CD = SCA.COURSE_CD
AND SCA.COURSE_CD = PSV.COURSE_CD
AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER
AND SUSA.UNIT_SET_CD = US.UNIT_SET_CD
AND SUSA.US_VERSION_NUMBER = US.VERSION_NUMBER WITH READ ONLY