Informatica PC Repository Query - Get Session Run statistics

Below query returns session run statistics with rows processed by sources/targets of a session. It supports multiple sources/targets.
(tested on Informatica 9.5 repository setup on Oracle)

SELECT distinct
a.workflow_run_id
,d.workflow_name
,e.instance_name as session_name
,case when widget_type = 2 then 'Target'
  when widget_type = 3 then 'Source'
end as Instance_Type
,a.instance_name
,a.applied_rows
,a.rejected_rows
,a.start_time
,a.end_time
FROM
opb_swidginst_log a,
opb_mapping b,
opb_session c,
opb_wflow_run d,
opb_task_inst e
WHERE
b.mapping_id = c.mapping_id
and c.session_id = e.task_id
and a.task_instance_id = e.instance_id
and a.workflow_run_id = d.workflow_run_id
and a.widget_type in (2,3)
and d.workflow_name = 'wf_XXXXX'
and e.instance_name = 's_XXXXX'
--and a.workflow_run_id = 'wf_Run_ID_XXXXX';