Oracle Apps Knowledge Sharing

Test Instance: R12.2.5

Query:

SELECT
   workflowitemeo.item_type,
   workflowitemeo.item_key,
   workflowitemeo.begin_date,
   workflowitemeo.end_date,
   workflowitemtypeeo.display_name,
   wf_fwkmon.getitemstatus(workflowitemeo.item_type, 
                                         workflowitemeo.item_key, 
                                         workflowitemeo.end_date, 
                                         workflowitemeo.root_activity, 
                                         workflowitemeo.root_activity_version 
                                         ) AS workflow_status,
   ias.error_name error_name,
   ias.error_message error_message,
   ias.error_stack error_stack 
FROM
   wf_items workflowitemeo,
   wf_item_types_vl workflowitemtypeeo,
   wf_activities_vl activityeo,
   wf_item_activity_statuses ias 
WHERE
   ias.activity_status = 'ERROR' 
   AND ias.item_type = workflowitemeo.item_type 
   AND ias.item_key = workflowitemeo.item_key 
   AND workflowitemeo.item_type = workflowitemtypeeo.name 
   AND activityeo.item_type = workflowitemeo.item_type 
   AND activityeo.name = workflowitemeo.root_activity 
   AND activityeo.version = workflowitemeo.root_activity_version 
   AND workflowitemeo.begin_date > SYSDATE - 1 
   AND workflowitemeo.item_type <> 'WFERROR';