SELECT *
FROM   ( SELECT DISTINCT 'FYI'           action
         ,      wfi.display_name         item_type
         ,      wfn.message_type         item_type_internal
         ,      wfmt.display_name        message_name
         ,      wfn.message_name         message_internal
         ,      wfn.notification_id      
         FROM   wf_notifications        wfn
         ,      wf_message_attributes   wfma
         ,      wf_item_types_tl        wfi
         ,      wf_messages_tl          wfmt
         WHERE  wfn.message_type  = wfma.message_type
         AND    wfn.message_name  = wfma.message_name
         AND    wfma.message_type = wfi.name
         AND    wfma.SUBTYPE     != 'RESPOND'
         AND    wfma.message_type = wfmt.type
         AND    wfma.message_name = wfmt.name
         AND    (wfn.message_type, wfn.message_name) NOT IN ( SELECT DISTINCT wfn2.message_type
                                                            ,      wfn2.message_name
                                                            FROM   wf_notifications        wfn2
                                                            ,      wf_message_attributes   wfma2
                                                            WHERE  wfn2.message_type  = wfma2.message_type
                                                            AND    wfn2.message_name  = wfma2.message_name
                                                            AND    wfma2.SUBTYPE      = 'RESPOND' )
         UNION
         SELECT DISTINCT 'Response Required'
         ,      wfi.display_name         item_type
         ,      wfn.message_type         item_type_internal
         ,      wfmt.display_name        message_name
         ,      wfn.message_name         message_internal
         ,      wfn.notification_id      
         FROM   wf_notifications        wfn
         ,      wf_message_attributes   wfma
         ,      wf_item_types_tl        wfi
         ,      wf_messages_tl          wfmt
         WHERE  wfn.message_type  = wfma.message_type
         AND    wfn.message_name  = wfma.message_name
         AND    wfma.message_type = wfi.name
         AND    wfma.SUBTYPE      = 'RESPOND'
         AND    wfma.message_type = wfmt.type
         AND    wfma.message_name = wfmt.name
       ) notifications
ORDER BY item_type_internal