VIEW: APPS.IGS_AV_STND_UNIT_CREDIT_V

Source

View Text - Preformatted

SELECT asu.person_id, asu.as_course_cd, asu.as_version_number, asu.s_adv_stnd_type, asu.exemption_institution_cd, sum(uv.achievable_credit_points) credit, asu.CREATED_BY, asu.CREATION_DATE, asu.LAST_UPDATED_BY, asu.LAST_UPDATE_DATE, asu.LAST_UPDATE_LOGIN ,asu.deg_aud_detail_id from IGS_AV_STND_UNIT asu, IGS_PS_UNIT_VER uv WHERE asu.unit_cd = uv.unit_cd and asu.version_number = uv.version_number and asu.s_adv_stnd_recognition_type = 'CREDIT' /* and asu.credit_percentage = 100 */ and asu.s_adv_stnd_granting_status = 'GRANTED' group by asu.person_id, asu.as_course_cd, asu.as_version_number, asu.s_adv_stnd_type, asu.exemption_institution_cd, asu.CREATED_BY, asu.CREATION_DATE, asu.LAST_UPDATED_BY,asu.LAST_UPDATE_DATE, asu.LAST_UPDATE_LOGIN , asu.deg_aud_detail_Id union select asule.person_id, asule.as_course_cd, asule.as_version_number, asule.s_adv_stnd_type, asule.exemption_institution_cd, sum(asule.credit_points), TO_NUMBER(asule.CREATED_BY), asule.CREATION_DATE, TO_NUMBER(asule.LAST_UPDATED_BY), asule.LAST_UPDATE_DATE, TO_NUMBER(asule.LAST_UPDATE_LOGIN), asule.deg_aud_detail_id from IGS_AV_STND_UNIT_LVL asule where asule.s_adv_stnd_granting_status = 'GRANTED' group by asule.person_id, asule.as_course_cd, asule.as_version_number, asule.s_adv_stnd_type,asule.exemption_institution_cd ,asule.CREATED_BY, asule.CREATION_DATE, asule.LAST_UPDATED_BY, asule.LAST_UPDATE_DATE, asule.LAST_UPDATE_LOGIN , asule.deg_aud_detail_id

View Text - HTML Formatted

SELECT ASU.PERSON_ID
, ASU.AS_COURSE_CD
, ASU.AS_VERSION_NUMBER
, ASU.S_ADV_STND_TYPE
, ASU.EXEMPTION_INSTITUTION_CD
, SUM(UV.ACHIEVABLE_CREDIT_POINTS) CREDIT
, ASU.CREATED_BY
, ASU.CREATION_DATE
, ASU.LAST_UPDATED_BY
, ASU.LAST_UPDATE_DATE
, ASU.LAST_UPDATE_LOGIN
, ASU.DEG_AUD_DETAIL_ID
FROM IGS_AV_STND_UNIT ASU
, IGS_PS_UNIT_VER UV
WHERE ASU.UNIT_CD = UV.UNIT_CD
AND ASU.VERSION_NUMBER = UV.VERSION_NUMBER
AND ASU.S_ADV_STND_RECOGNITION_TYPE = 'CREDIT' /*
AND ASU.CREDIT_PERCENTAGE = 100 */
AND ASU.S_ADV_STND_GRANTING_STATUS = 'GRANTED' GROUP BY ASU.PERSON_ID
, ASU.AS_COURSE_CD
, ASU.AS_VERSION_NUMBER
, ASU.S_ADV_STND_TYPE
, ASU.EXEMPTION_INSTITUTION_CD
, ASU.CREATED_BY
, ASU.CREATION_DATE
, ASU.LAST_UPDATED_BY
, ASU.LAST_UPDATE_DATE
, ASU.LAST_UPDATE_LOGIN
, ASU.DEG_AUD_DETAIL_ID UNION SELECT ASULE.PERSON_ID
, ASULE.AS_COURSE_CD
, ASULE.AS_VERSION_NUMBER
, ASULE.S_ADV_STND_TYPE
, ASULE.EXEMPTION_INSTITUTION_CD
, SUM(ASULE.CREDIT_POINTS)
, TO_NUMBER(ASULE.CREATED_BY)
, ASULE.CREATION_DATE
, TO_NUMBER(ASULE.LAST_UPDATED_BY)
, ASULE.LAST_UPDATE_DATE
, TO_NUMBER(ASULE.LAST_UPDATE_LOGIN)
, ASULE.DEG_AUD_DETAIL_ID
FROM IGS_AV_STND_UNIT_LVL ASULE
WHERE ASULE.S_ADV_STND_GRANTING_STATUS = 'GRANTED' GROUP BY ASULE.PERSON_ID
, ASULE.AS_COURSE_CD
, ASULE.AS_VERSION_NUMBER
, ASULE.S_ADV_STND_TYPE
, ASULE.EXEMPTION_INSTITUTION_CD
, ASULE.CREATED_BY
, ASULE.CREATION_DATE
, ASULE.LAST_UPDATED_BY
, ASULE.LAST_UPDATE_DATE
, ASULE.LAST_UPDATE_LOGIN
, ASULE.DEG_AUD_DETAIL_ID