Workflow Query : To get Action History details

Workflow Query to get action history details:

Inputs Needed :

WF Item Type
Ex : 'POAPPR','PABUDWF' etc.,

WF Item Key

Query :

SELECT
  TO_CHAR(ias.begin_date,'DD-MON-RR HH24:MI:SS') begin_date,
  TO_CHAR(ias.end_date,'DD-MON-RR HH24:MI:SS') end_date,
  ap.display_name
  ||'/'
  ||pa.instance_label Activity   ,
  ias.activity_status Status     ,
  ias.activity_result_code Result,
  ias.assigned_user assigned_user,
  ias.notification_id NID        ,
  ntf.status "Status"            ,
  ias.action                     ,
  ias.performed_by               ,
  ias.due_date                   ,
  ias.ERROR_NAME                 ,
  ias.ERROR_MESSAGE
FROM apps.wf_item_activity_statuses ias,
  apps.wf_process_activities pa           ,
  apps.wf_activities ac                   ,
  apps.wf_activities_vl ap                ,
  apps.wf_items i                         ,
  apps.wf_notifications ntf
  WHERE ias.item_type      = 'PABUDWF' --  Enter WF Item TypeAND ias.item_key           = '21215'   --  Enter WF Item KeyAND ias.process_activity   = pa.instance_id
AND pa.activity_name       = ac.name
AND pa.activity_item_type  = ac.item_type
AND pa.process_name        = ap.name
AND pa.process_item_type   = ap.item_type
AND pa.process_version     = ap.version
AND i.item_type            = ias.item_type
AND i.item_key             = ias.item_key
AND i.begin_date          >= ac.begin_date
AND i.begin_date           < NVL(ac.end_date, i.begin_date+1)
AND ntf.notification_id(+) = ias.notification_id
ORDER BY ias.begin_date,
         ias.execution_time;