VIEW: APPS.IGS_EN_SCA_STATUS_V

Source

View Text - Preformatted

SELECT pdv.person_id, pdv.person_number, pdv.TITLE, pdv.surname, pdv.given_names, pdv.preferred_given_name, pdv.sex, pdv.birth_dt, pdv.email_addr, pdv.oracle_username, pdv.staff_member_ind, pdv.deceased_ind, pdv.context_block_name, sca.course_cd, sca.version_number, sca.course_cd||'.'|| TO_CHAR(sca.version_number), sca.course_attempt_status, sca.location_cd, sca.ATTENDANCE_MODE, sca.ATTENDANCE_TYPE, sca.created_by, sca.creation_date, sca.last_updated_by, sca.last_update_date, sca.last_update_login, pdv.api_person_id, pdv.pre_name_adjunct_meaning, pdv.suffix, pdv.middle_name FROM IGS_PE_PERSON_V pdv, IGS_EN_STDNT_PS_ATT sca WHERE pdv.person_id = sca.person_id (+)

View Text - HTML Formatted

SELECT PDV.PERSON_ID
, PDV.PERSON_NUMBER
, PDV.TITLE
, PDV.SURNAME
, PDV.GIVEN_NAMES
, PDV.PREFERRED_GIVEN_NAME
, PDV.SEX
, PDV.BIRTH_DT
, PDV.EMAIL_ADDR
, PDV.ORACLE_USERNAME
, PDV.STAFF_MEMBER_IND
, PDV.DECEASED_IND
, PDV.CONTEXT_BLOCK_NAME
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, SCA.COURSE_CD||'.'|| TO_CHAR(SCA.VERSION_NUMBER)
, SCA.COURSE_ATTEMPT_STATUS
, SCA.LOCATION_CD
, SCA.ATTENDANCE_MODE
, SCA.ATTENDANCE_TYPE
, SCA.CREATED_BY
, SCA.CREATION_DATE
, SCA.LAST_UPDATED_BY
, SCA.LAST_UPDATE_DATE
, SCA.LAST_UPDATE_LOGIN
, PDV.API_PERSON_ID
, PDV.PRE_NAME_ADJUNCT_MEANING
, PDV.SUFFIX
, PDV.MIDDLE_NAME
FROM IGS_PE_PERSON_V PDV
, IGS_EN_STDNT_PS_ATT SCA
WHERE PDV.PERSON_ID = SCA.PERSON_ID (+)