Query to get all Approval Task Category Names from BPM Worklist

Hi All,

I have a situation, where there are lot of categories we need to hide from Me--> Roles and Delegation-->Approval Delegation--> Category list. As per Oracle Product team, we can remove it from BPM Worklist from a specific Approval Task.

But, there are some approval task was already customized and put down the category name of that task. As of now we do not have any other way to go through one by one and check if a specific approval task contains category name or not.

We would like to have a query to get all the task names and the attached category name against each task.