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_UNIT_VER_RU_V

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

View Text

SELECT UVR.UNIT_CD
, UVR.VERSION_NUMBER
, UVR.S_RULE_CALL_CD
, UVR.RUL_SEQUENCE_NUMBER
, SRC.RUD_SEQUENCE_NUMBER
, SRC.SELECT_GROUP
, RUD.S_RETURN_TYPE
, RUD.RULE_DESCRIPTION
, IGS_RU_GEN_003.RULP_GET_RULE(UVR.RUL_SEQUENCE_NUMBER)
, ''
, UVR.CREATED_BY
, UVR.CREATION_DATE
, UVR.LAST_UPDATED_BY
, UVR.LAST_UPDATE_DATE
, UVR.LAST_UPDATE_LOGIN
FROM IGS_RU_DESCRIPTION RUD
, IGS_RU_CALL SRC
, IGS_PS_UNIT_VER_RU UVR
WHERE UVR.S_RULE_CALL_CD = SRC.S_RULE_CALL_CD AND SRC.S_RULE_TYPE_CD = 'UNIT' AND RUD.SEQUENCE_NUMBER = SRC.RUD_SEQUENCE_NUMBER UNION SELECT UV.UNIT_CD
, UV.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'
, UV.CREATED_BY
, UV.CREATION_DATE
, UV.LAST_UPDATED_BY
, UV.LAST_UPDATE_DATE
, UV.LAST_UPDATE_LOGIN
FROM IGS_RU_CALL SRC
, IGS_RU_DESCRIPTION RUD
, IGS_PS_UNIT_VER UV WHERE SRC.S_RULE_TYPE_CD = 'UNIT' AND RUD.SEQUENCE_NUMBER = SRC.RUD_SEQUENCE_NUMBER
AND NOT EXISTS ( SELECT 'X' FROM IGS_PS_UNIT_VER_RU UVR WHERE UVR.UNIT_CD = UV.UNIT_CD AND UVR.VERSION_NUMBER = UV.VERSION_NUMBER AND UVR.S_RULE_CALL_CD = SRC.S_RULE_CALL_CD)

Columns

Name
UNIT_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