VIEW: APPS.IGS_EN_SUSA_PARENT_V

Source

View Text - Preformatted

SELECT susa.person_id, /* Select valid parent IGS_PS_UNIT sets existing in susa. */ susa.course_cd, susa.unit_set_cd, susa.sequence_number, susa.us_version_number, susa.selection_dt, susa.end_dt, sca.coo_id, sca.cal_type, sca.version_number, us.UNIT_SET_STATUS, us.UNIT_SET_CAT, SUBSTR(IGS_EN_GEN_008.ENRP_GET_US_TITLE (us.unit_set_cd,us.version_number,sca.course_cd,sca.version_number,sca.cal_type,susa.person_id,susa.sequence_number),1,90), cousr.sub_unit_set_cd, cousr.sub_us_version_number, 'Y', /* record exists for the student.*/ susa.created_by, susa.creation_date, susa.last_updated_by, susa.last_update_date, susa.last_update_login FROM IGS_AS_SU_SETATMPT susa, IGS_EN_STDNT_PS_ATT sca, IGS_EN_UNIT_SET us, IGS_PS_OF_UNT_SET_RL cousr WHERE sca.person_id = susa.person_id AND sca.course_cd = susa.course_cd AND susa.unit_set_cd = us.unit_set_cd AND susa.us_version_number = us.version_number AND susa.course_cd = cousr.course_cd AND sca.version_number = cousr.crv_version_number AND sca.cal_type = cousr.cal_type AND susa.unit_set_cd = cousr.sup_unit_set_cd AND susa.us_version_number = cousr.sup_us_version_number

View Text - HTML Formatted

SELECT SUSA.PERSON_ID
, /* SELECT VALID PARENT IGS_PS_UNIT SETS EXISTING IN SUSA. */ SUSA.COURSE_CD
, SUSA.UNIT_SET_CD
, SUSA.SEQUENCE_NUMBER
, SUSA.US_VERSION_NUMBER
, SUSA.SELECTION_DT
, SUSA.END_DT
, SCA.COO_ID
, SCA.CAL_TYPE
, SCA.VERSION_NUMBER
, US.UNIT_SET_STATUS
, US.UNIT_SET_CAT
, SUBSTR(IGS_EN_GEN_008.ENRP_GET_US_TITLE (US.UNIT_SET_CD
, US.VERSION_NUMBER
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, SCA.CAL_TYPE
, SUSA.PERSON_ID
, SUSA.SEQUENCE_NUMBER)
, 1
, 90)
, COUSR.SUB_UNIT_SET_CD
, COUSR.SUB_US_VERSION_NUMBER
, 'Y'
, /* RECORD EXISTS FOR THE STUDENT.*/ SUSA.CREATED_BY
, SUSA.CREATION_DATE
, SUSA.LAST_UPDATED_BY
, SUSA.LAST_UPDATE_DATE
, SUSA.LAST_UPDATE_LOGIN
FROM IGS_AS_SU_SETATMPT SUSA
, IGS_EN_STDNT_PS_ATT SCA
, IGS_EN_UNIT_SET US
, IGS_PS_OF_UNT_SET_RL COUSR
WHERE SCA.PERSON_ID = SUSA.PERSON_ID
AND SCA.COURSE_CD = SUSA.COURSE_CD
AND SUSA.UNIT_SET_CD = US.UNIT_SET_CD
AND SUSA.US_VERSION_NUMBER = US.VERSION_NUMBER
AND SUSA.COURSE_CD = COUSR.COURSE_CD
AND SCA.VERSION_NUMBER = COUSR.CRV_VERSION_NUMBER
AND SCA.CAL_TYPE = COUSR.CAL_TYPE
AND SUSA.UNIT_SET_CD = COUSR.SUP_UNIT_SET_CD
AND SUSA.US_VERSION_NUMBER = COUSR.SUP_US_VERSION_NUMBER