VIEW: APPS.IGS_PS_STAGE_RU_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)