VIEW: APPS.IGS_EN_UNIT_SET_RULE_V

Source

View Text - Preformatted

SELECT usr.unit_set_cd, usr.version_number, 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_RU_DESCRIPTION rud, IGS_RU_CALL src, IGS_EN_UNIT_SET_RULE usr WHERE usr.s_rule_call_cd = src.s_rule_call_cd AND src.s_rule_type_cd = 'USET' AND rud.sequence_number = src.rud_sequence_number UNION SELECT us.unit_set_cd, us.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', us.created_by, us.creation_date, us.last_updated_by, us.last_update_date, us.last_update_login FROM IGS_RU_CALL src, IGS_RU_DESCRIPTION rud, IGS_EN_UNIT_SET us WHERE src.s_rule_type_cd = 'USET' AND rud.sequence_number = src.rud_sequence_number AND NOT EXISTS ( SELECT 'X' FROM IGS_EN_UNIT_SET_RULE usr WHERE usr.unit_set_cd = us.unit_set_cd AND usr.version_number = us.version_number AND usr.s_rule_call_cd = src.s_rule_call_cd)

View Text - HTML Formatted

SELECT USR.UNIT_SET_CD
, USR.VERSION_NUMBER
, 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_RU_DESCRIPTION RUD
, IGS_RU_CALL SRC
, IGS_EN_UNIT_SET_RULE USR
WHERE USR.S_RULE_CALL_CD = SRC.S_RULE_CALL_CD
AND SRC.S_RULE_TYPE_CD = 'USET'
AND RUD.SEQUENCE_NUMBER = SRC.RUD_SEQUENCE_NUMBER UNION SELECT US.UNIT_SET_CD
, US.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'
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
, US.LAST_UPDATE_LOGIN
FROM IGS_RU_CALL SRC
, IGS_RU_DESCRIPTION RUD
, IGS_EN_UNIT_SET US
WHERE SRC.S_RULE_TYPE_CD = 'USET'
AND RUD.SEQUENCE_NUMBER = SRC.RUD_SEQUENCE_NUMBER
AND NOT EXISTS ( SELECT 'X'
FROM IGS_EN_UNIT_SET_RULE USR
WHERE USR.UNIT_SET_CD = US.UNIT_SET_CD
AND USR.VERSION_NUMBER = US.VERSION_NUMBER
AND USR.S_RULE_CALL_CD = SRC.S_RULE_CALL_CD)