Do you guys have any idea on how to query this?
Kindly see attached screenshot.
Really appreciate if you could advice on what tables to look for them.
Thanks in advace.
Take a peek at KWFL_STEP_TRANSACTION_HISTORY - you'll have to join to a couple other tables to complete the picture but that should get you started.
An easy way to get the SQL query is to use the JDBC Logging.
You can activate the JDBC logging at runtime in the workbench.
It is in the menu under Edit->Debug Settings
Then you have to tick Enable JDBC Logging... After that you should open a request in the browser.
Then you should deactivate the login as fast as possible, so the JDBC log file stay small...
You find the JDBC logfile with your query in the log directory of your application server.
Here you go...
select * from KWFL_STEP_TRANSACTION_HIST_V where TOP_INSTANCE_SOURCE_SET_ID =<Request ID..>
select LAST_UPDATED_BY, LAST_UPDATE_DATE from KWFL_STEP_TRANSACTIONS
WHERE WORKFLOW_STEP_ID =(SELECT WORKFLOW_STEP_ID FROM KWFL_WORKFLOW_STEPS_NLS WHERE STEP_NAME
LIKE'<--your step name--->')
AND WORKFLOW_INSTANCE_STEP_ID in(select WORKFLOW_INSTANCE_STEP_ID
from KWFL_WORKFLOW_INSTANCE_STEPS WHERE WORKFLOW_INSTANCE_ID IN
(select WORKFLOW_INSTANCE_ID from KWFL_WORKFLOW_INSTANCES
where INSTANCE_SOURCE_ID =<--Reuqest ID-->)) ;