APPS.WF_ALERT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 27

select 'errors exist'
from   wf_item_activity_statuses
where  activity_status = 'ERROR'
and    begin_date >= nvl(lastrun,begin_date);

Line: 101

select  ias.item_type,
        ias.item_key,
        ac.name Activity,
        ias.activity_result_code Result,
--	ias.error_name ERROR_NAME,
	ias.error_message ERROR_MESSAGE,
	ias.error_stack ERROR_STACK
from    wf_item_activity_statuses ias,
        wf_process_activities pa,
        wf_activities ac,
        wf_activities ap,
        wf_items i
where   ias.activity_status     = 'ERROR'
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)
order by ias.begin_date, ias.execution_time;