VIEW: APPS.IGS_PS_UNIT_VER_RU_V

Source

View Text - Preformatted

SELECT uvr.unit_cd, uvr.version_number, uvr.s_rule_call_cd, uvr.rul_sequence_number, src.rud_sequence_number, src.select_group, rud.s_return_type, rud.rule_description, IGS_RU_GEN_003.rulp_get_rule(uvr.rul_sequence_number), '', uvr.created_by, uvr.creation_date, uvr.last_updated_by, uvr.last_update_date, uvr.last_update_login FROM IGS_RU_DESCRIPTION rud, IGS_RU_CALL src, IGS_PS_UNIT_VER_RU uvr WHERE uvr.s_rule_call_cd = src.s_rule_call_cd AND src.s_rule_type_cd = 'UNIT' AND rud.sequence_number = src.rud_sequence_number UNION SELECT uv.unit_cd, uv.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', uv.created_by, uv.creation_date, uv.last_updated_by, uv.last_update_date, uv.last_update_login FROM IGS_RU_CALL src, IGS_RU_DESCRIPTION rud, IGS_PS_UNIT_VER uv WHERE src.s_rule_type_cd = 'UNIT' AND rud.sequence_number = src.rud_sequence_number AND NOT EXISTS ( SELECT 'X' FROM IGS_PS_UNIT_VER_RU uvr WHERE uvr.unit_cd = uv.unit_cd AND uvr.version_number = uv.version_number AND uvr.s_rule_call_cd = src.s_rule_call_cd)

View Text - HTML Formatted

SELECT UVR.UNIT_CD
, UVR.VERSION_NUMBER
, UVR.S_RULE_CALL_CD
, UVR.RUL_SEQUENCE_NUMBER
, SRC.RUD_SEQUENCE_NUMBER
, SRC.SELECT_GROUP
, RUD.S_RETURN_TYPE
, RUD.RULE_DESCRIPTION
, IGS_RU_GEN_003.RULP_GET_RULE(UVR.RUL_SEQUENCE_NUMBER)
, ''
, UVR.CREATED_BY
, UVR.CREATION_DATE
, UVR.LAST_UPDATED_BY
, UVR.LAST_UPDATE_DATE
, UVR.LAST_UPDATE_LOGIN
FROM IGS_RU_DESCRIPTION RUD
, IGS_RU_CALL SRC
, IGS_PS_UNIT_VER_RU UVR
WHERE UVR.S_RULE_CALL_CD = SRC.S_RULE_CALL_CD
AND SRC.S_RULE_TYPE_CD = 'UNIT'
AND RUD.SEQUENCE_NUMBER = SRC.RUD_SEQUENCE_NUMBER UNION SELECT UV.UNIT_CD
, UV.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'
, UV.CREATED_BY
, UV.CREATION_DATE
, UV.LAST_UPDATED_BY
, UV.LAST_UPDATE_DATE
, UV.LAST_UPDATE_LOGIN
FROM IGS_RU_CALL SRC
, IGS_RU_DESCRIPTION RUD
, IGS_PS_UNIT_VER UV
WHERE SRC.S_RULE_TYPE_CD = 'UNIT'
AND RUD.SEQUENCE_NUMBER = SRC.RUD_SEQUENCE_NUMBER
AND NOT EXISTS ( SELECT 'X'
FROM IGS_PS_UNIT_VER_RU UVR
WHERE UVR.UNIT_CD = UV.UNIT_CD
AND UVR.VERSION_NUMBER = UV.VERSION_NUMBER
AND UVR.S_RULE_CALL_CD = SRC.S_RULE_CALL_CD)