Approval Process Name in Transaction Console vs BPM Worklist

 

SELECT 
   HAPT.NAME,
   HAPT.DESCRIPTION,
   HRPB.TASK_FILE_NAME TaskName,
   HRPB.TXN_MODULE_IDENTIFIER,
   HAPT.CATEGORY_NAME,
   HRPB.CATEGORY_CODE,
   HAPT.SUBCATEGORY_NAME,
   HRPB.SUBCATEGORY_CODE,
   HRPB.FAMILY,
   DECODE(HAAO.APPROVAL_DISABLED,'true','Bypassed','false','Enabled') "Enabled Status"
FROM 
   FUSION.HRC_ARM_PROCESS_B HRPB,
   FUSION.HRC_ARM_PROCESS_TL HAPT,
   FUSION.HRC_ARM_APPROVAL_OPTIONS HAAO
WHERE 
   HRPB.PROCESS_ID = HAAO.PROCESS_ID
   AND HRPB.PROCESS_ID = HAPT.PROCESS_ID
   AND HAPT.LANGUAGE = 'US'
   AND HRPB.FAMILY = 'HCM'
ORDER BY 1

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

SQL Queries (SQLQ)
Posted by : Mohammad