Query to get Open FYI notifications in Oracle Workflow

SELECT wfn.recipient_role

  ,wfn.notification_id

  ,wfn.status

  ,wfn.mail_status

  ,wfn.subject

  FROM wf_item_activity_statuses wias

      ,wf_notifications wfn

 WHERE wias.notification_id=wfn.notification_id

   AND wfn.status='OPEN'

   AND wias.activity_status='COMPLETE'

   AND wfn.end_date is null

   AND wfn.message_type = 'REQAPPRV'

ORDER BY wfn.recipient_role;