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_PS_VER_RU_V

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CVR.COURSE_CD
, CVR.VERSION_NUMBER
, CVR.S_RULE_CALL_CD
, CVR.RUL_SEQUENCE_NUMBER
, SRC.RUD_SEQUENCE_NUMBER
, SRC.SELECT_GROUP
, RUD.S_RETURN_TYPE
, RUD.RULE_DESCRIPTION
, IGS_RU_GEN_003.RULP_GET_RULE(CVR.RUL_SEQUENCE_NUMBER)
, ''
, CVR.CREATED_BY
, CVR.CREATION_DATE
, CVR.LAST_UPDATED_BY
, CVR.LAST_UPDATE_DATE
, CVR.LAST_UPDATE_LOGIN
FROM IGS_RU_DESCRIPTION RUD
, IGS_RU_CALL SRC
, IGS_PS_VER_RU CVR
WHERE CVR.S_RULE_CALL_CD = SRC.S_RULE_CALL_CD AND SRC.S_RULE_TYPE_CD = 'COURSE' AND RUD.SEQUENCE_NUMBER = SRC.RUD_SEQUENCE_NUMBER UNION SELECT CRV.COURSE_CD
, CRV.VERSION_NUMBER
, SRC.S_RULE_CALL_CD
, TO_NUMBER(NULL)
, SRC.RUD_SEQUENCE_NUMBER
, SRC.SELECT_GROUP
, RUD.S_RETURN_TYPE
, RUD.RULE_DESCRIPTION
, ''
, 'UNDEFINED'
, CRV.CREATED_BY
, CRV.CREATION_DATE
, CRV.LAST_UPDATED_BY
, CRV.LAST_UPDATE_DATE
, CRV.LAST_UPDATE_LOGIN
FROM IGS_RU_CALL SRC
, IGS_RU_DESCRIPTION RUD
, IGS_PS_VER CRV WHERE SRC.S_RULE_TYPE_CD = 'COURSE' AND RUD.SEQUENCE_NUMBER = SRC.RUD_SEQUENCE_NUMBER
AND NOT EXISTS ( SELECT 'X' FROM IGS_PS_VER_RU CVR WHERE CVR.COURSE_CD = CRV.COURSE_CD AND CVR.VERSION_NUMBER = CRV.VERSION_NUMBER AND CVR.S_RULE_CALL_CD = SRC.S_RULE_CALL_CD)

Columns

Name
COURSE_CD
VERSION_NUMBER
S_RULE_CALL_CD
RUL_SEQUENCE_NUMBER
RUD_SEQUENCE_NUMBER
SELECT_GROUP
S_RETURN_TYPE
RULE_DESCRIPTION
RULE_TEXT
DEFINED_LAMP
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN