home

appsnotes

The related tables to get some information on gl batch are as follows:

WF_NOTIFICATIONS
WF_ITEMS
WF_ITEM_ACTIVITY_STATUSES
WF_PROCESS_ACTIVITIES

You can run the following SQL scripts in sequence and check the results that you need.


Select * from wf_notifications where message_type = 'GLBATCH'



Select * from wf_items where item_key = '&item_key'


Select P.PROCESS_NAME, S.*
from wf_item_activity_statuses S,
wf_process_activities P
where item_key = '&item_key'
AND P.INSTANCE_ID = S.PROCESS_ACTIVITY
order by begin_date, end_date