VIEW: APPS.IGS_PS_VER_RU_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)