Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Unit Section Version Rules |
Implementation/DBA Data: | Not implemented in this database |
SELECT USR.UOO_ID
, USR.S_RULE_CALL_CD
, USR.RUL_SEQUENCE_NUMBER
, SRC.RUD_SEQUENCE_NUMBER
, SRC.SELECT_GROUP
, RUD.S_RETURN_TYPE
, RUD.RULE_DESCRIPTION
, IGS_RU_GEN_003.RULP_GET_RULE(USR.RUL_SEQUENCE_NUMBER)
, ''
, USR.CREATED_BY
, USR.CREATION_DATE
, USR.LAST_UPDATED_BY
, USR.LAST_UPDATE_DATE
, USR.LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_RU USR
, IGS_RU_DESCRIPTION RUD
, IGS_RU_CALL SRC
WHERE USR.S_RULE_CALL_CD = SRC.S_RULE_CALL_CD
AND SRC.S_RULE_TYPE_CD = 'USEC'
AND RUD.SEQUENCE_NUMBER = SRC.RUD_SEQUENCE_NUMBER UNION SELECT UOO.UOO_ID
, SRC.S_RULE_CALL_CD
, TO_NUMBER(NULL)
, SRC.RUD_SEQUENCE_NUMBER
, SRC.SELECT_GROUP
, RUD.S_RETURN_TYPE
, RUD.RULE_DESCRIPTION
, ''
, 'UNDEFINED'
, UOO.CREATED_BY
, UOO.CREATION_DATE
, UOO.LAST_UPDATED_BY
, UOO.LAST_UPDATE_DATE
, UOO.LAST_UPDATE_LOGIN
FROM IGS_RU_CALL SRC
, IGS_RU_DESCRIPTION RUD
, IGS_PS_UNIT_OFR_OPT UOO WHERE SRC.S_RULE_TYPE_CD = 'USEC' AND RUD.SEQUENCE_NUMBER = SRC.RUD_SEQUENCE_NUMBER
AND NOT EXISTS (SELECT 'X' FROM IGS_PS_USEC_RU USR WHERE USR.UOO_ID = UOO.UOO_ID AND USR.S_RULE_CALL_CD = SRC.S_RULE_CALL_CD)