Query to get Notifications sent by a given Oracle Workflow

SELECT wn.notification_id nid

      ,wn.context

      ,wn.group_id

      ,wn.status

      ,wn.mail_status

      ,wn.message_type

      ,wn.message_name

      ,wn.access_key

      ,wn.priority

      ,wn.begin_date

      ,wn.end_date

      ,wn.due_date

      ,wn.callback

      ,wn.recipient_role

      ,wn.responder

      ,wn.original_recipient

      ,wn.from_user

      ,wn.to_user

      ,wn.subject

  FROM wf_notifications wn

      ,wf_item_activity_statuses wias

 WHERE wn.group_id = wias.notification_id

   AND wias.item_type = 'XXITEMTP'

   AND wias.item_key = 'XXITEMTP001'