eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_SS_EN_RULE_CART_MAX_V

Product:	IGS - Student System (Obsolete)
Description:	The view queries for the sum of credit points of all the Units in the cart.
Implementation/DBA Data:	Not implemented in this database

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

Name
CREDIT_POINTS
LOAD_CAL_TYPE
LOAD_CI_SEQUENCE_NUMBER
PERSON_ID
COURSE_CD
UOO_ID
TEACH_CAL_TYPE
TEACH_CI_SEQUENCE_NUMBER