VIEW: APPS.IGS_SS_EN_RULE_CART_MAX_V

Source

View Text - Preformatted

SELECT nvl(sua.override_enrolled_cp , nvl( cps.enrolled_credit_points,uv.enrolled_credit_points)) credit_points, ltl.load_cal_type load_cal_type, ltl.load_ci_sequence_number load_ci_sequence_number, sua.person_id person_id, sua.course_cd course_cd , sua.uoo_id uoo_id , sua.cal_type teach_cal_type, sua.ci_sequence_number teach_ci_sequence_number FROM IGS_EN_SU_ATTEMPT sua , IGS_PS_UNIT_VER uv, IGS_PS_UNIT_OFR_OPT uoo, IGS_PS_USEC_CPS cps, IGS_CA_TEACH_TO_LOAD_V ltl WHERE uv.unit_cd = sua.unit_cd AND uv.version_number = sua.version_number AND sua.uoo_id =uoo.uoo_id AND uoo.uoo_id =cps.uoo_id (+) AND ltl.teach_cal_type= sua.cal_type AND ltl.teach_ci_sequence_number = sua.ci_sequence_number AND sua.unit_attempt_status ='UNCONFIRM'

View Text - HTML Formatted

SELECT NVL(SUA.OVERRIDE_ENROLLED_CP
, NVL( CPS.ENROLLED_CREDIT_POINTS
, UV.ENROLLED_CREDIT_POINTS)) CREDIT_POINTS
, LTL.LOAD_CAL_TYPE LOAD_CAL_TYPE
, LTL.LOAD_CI_SEQUENCE_NUMBER LOAD_CI_SEQUENCE_NUMBER
, SUA.PERSON_ID PERSON_ID
, SUA.COURSE_CD COURSE_CD
, SUA.UOO_ID UOO_ID
, SUA.CAL_TYPE TEACH_CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER TEACH_CI_SEQUENCE_NUMBER
FROM IGS_EN_SU_ATTEMPT SUA
, IGS_PS_UNIT_VER UV
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_PS_USEC_CPS CPS
, IGS_CA_TEACH_TO_LOAD_V LTL
WHERE UV.UNIT_CD = SUA.UNIT_CD
AND UV.VERSION_NUMBER = SUA.VERSION_NUMBER
AND SUA.UOO_ID =UOO.UOO_ID
AND UOO.UOO_ID =CPS.UOO_ID (+)
AND LTL.TEACH_CAL_TYPE= SUA.CAL_TYPE
AND LTL.TEACH_CI_SEQUENCE_NUMBER = SUA.CI_SEQUENCE_NUMBER
AND SUA.UNIT_ATTEMPT_STATUS ='UNCONFIRM'