SELECT APPLICATION_ID , ALERT_ID , RESPONSE_SET_ID , NAME FROM ALR_RESPONSE_VARIABLES UNION SELECT APPLICATION_ID , ALERT_ID , TO_NUMBER( NULL) RESPONSE_SET_ID , NAME FROM ALR_ALERT_OUTPUTS
View Text - HTML Formatted
SELECT APPLICATION_ID , ALERT_ID , RESPONSE_SET_ID , NAME FROM ALR_RESPONSE_VARIABLES UNION SELECT APPLICATION_ID , ALERT_ID , TO_NUMBER( NULL) RESPONSE_SET_ID , NAME FROM ALR_ALERT_OUTPUTS