Need query/Table details to fetch the Status details like the Number of a Task of Flow pattern

we used the following query but its showing only the Total count, but not the details like success/error count . attached the screenshot showing the same.

Query

=====

SELECT

fti.*

FROM

pay_flow_task_instances fti,

pay_flow_tasks_vl ft,

pay_flow_instances pfi

WHERE

1 = 1

--FTI.STATUS = 'SCHEDULED'

--AND PFI.STATUS = 'SCHEDULED'

AND fti.base_flow_task_id = ft.base_flow_task_id

AND pfi.flow_instance_id = fti.flow_instance_id

--AND FTI.SCHEDULED_DATE IS NOT NULL

AND pfi.instance_name = 'GS Payroll Flow 29OCT'

AND flow_task_name = 'Calculate Payroll'