View: IGS_PS_STAGE_RU_V

View Text

SELECT CSR.COURSE_CD
, CSR.VERSION_NUMBER
, CSR.CST_SEQUENCE_NUMBER
, CSR.S_RULE_CALL_CD
, CSR.RUL_SEQUENCE_NUMBER
, SRC.RUD_SEQUENCE_NUMBER
, SRC.SELECT_GROUP
, RUD.S_RETURN_TYPE
, RUD.RULE_DESCRIPTION
, IGS_RU_GEN_003.RULP_GET_RULE(CSR.RUL_SEQUENCE_NUMBER)
, ''
, CSR.CREATED_BY
, CSR.CREATION_DATE
, CSR.LAST_UPDATED_BY
, CSR.LAST_UPDATE_DATE
, CSR.LAST_UPDATE_LOGIN
FROM IGS_PS_STAGE_RU CSR
, IGS_RU_DESCRIPTION RUD
, IGS_RU_CALL SRC
WHERE CSR.S_RULE_CALL_CD = SRC.S_RULE_CALL_CD AND SRC.S_RULE_TYPE_CD = 'CRS-STAGE' AND RUD.SEQUENCE_NUMBER = SRC.RUD_SEQUENCE_NUMBER UNION SELECT CST.COURSE_CD
, CST.VERSION_NUMBER
, CST.SEQUENCE_NUMBER
, SRC.S_RULE_CALL_CD
, TO_NUMBER(NULL)
, SRC.RUD_SEQUENCE_NUMBER
, SRC.SELECT_GROUP
, RUD.S_RETURN_TYPE
, RUD.RULE_DESCRIPTION
, ''
, 'UNDEFINED'
, CST.CREATED_BY
, CST.CREATION_DATE
, CST.LAST_UPDATED_BY
, CST.LAST_UPDATE_DATE
, CST.LAST_UPDATE_LOGIN
FROM IGS_RU_CALL SRC
, IGS_RU_DESCRIPTION RUD
, IGS_PS_STAGE CST WHERE SRC.S_RULE_TYPE_CD = 'CRS-STAGE' AND RUD.SEQUENCE_NUMBER = SRC.RUD_SEQUENCE_NUMBER
AND NOT EXISTS ( SELECT 'X' FROM IGS_PS_STAGE_RU CSR WHERE CSR.COURSE_CD = CST.COURSE_CD AND CSR.VERSION_NUMBER = CST.VERSION_NUMBER AND CSR.CST_SEQUENCE_NUMBER = CST.SEQUENCE_NUMBER AND CSR.S_RULE_CALL_CD = SRC.S_RULE_CALL_CD)

Columns