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;
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