Search This Blog

Tuesday, September 23, 2014

How to get Work Flow action history

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 = 'POAPPRV' --  Enter WF Item Type
   AND ias.item_key = '21215' --  Enter WF Item Key
   AND 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;

No comments:

Post a Comment