View: IGS_SS_EN_RULE_CART_MAX_V

Product:	IGS - Student System
Description:	The view queries for the sum of credit points of all the Units in the cart.
Implementation/DBA Data:	APPS.IGS_SS_EN_RULE_CART_MAX_V

View Text

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'

Columns