Dispute Notification Work Flow tables in Oracle fusion

 select

-- task summary :

b.TASK_NUMBER,

t.TASK_TITLE,

b.INITIATED_BY,

b.INITIATED_DATE,

b.COMPLETED_BY,

b.COMPLETED_DATE,

b.STATUS_CODE,

b.OUTCOME_CODE,

hb.version,

hb.from_user

from FND_BPM_TASK_B b, FND_BPM_TASK_TL t,

FND_BPM_TASK_HISTORY_B hb

where b.domain = 'ICDomain'

--and b.task_number = 200381

and b.task_definition_name = 'DisputeNotificationTask'

and b.task_id = t.task_id

and t.language = USERENV('LANG')

and t.task_id=hb.task_id

order by b.task_number,hb.version desc