PAY_TASK_STATUS_OV_SUMMARY

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
FLOW_INSTANCE_ID FLOW_NAME STATUS TASK_NUM

Name

FLOW_INSTANCE_ID

FLOW_NAME

STATUS

TASK_NUM

Query

SQL_Statement
select FLOW_INSTANCE_ID, FLOW_NAME,DECODE(TASK_STATUS,'COMPLETE','Completed','COMPLETE_WITH_ISSUES','Completed','SKIPPED', 'Skipped','Pending') as status, COUNT(*) Task_Num from PAY_TASK_STATUS_VL GROUP BY FLOW_INSTANCE_ID,FLOW_NAME,DECODE(TASK_STATUS,'COMPLETE','Completed','COMPLETE_WITH_ISSUES','Completed','SKIPPED', 'Skipped','Pending')

SQL_Statement

select FLOW_INSTANCE_ID, FLOW_NAME,DECODE(TASK_STATUS,'COMPLETE','Completed','COMPLETE_WITH_ISSUES','Completed','SKIPPED', 'Skipped','Pending') as status, COUNT(*) Task_Num

from PAY_TASK_STATUS_VL

GROUP BY FLOW_INSTANCE_ID,FLOW_NAME,DECODE(TASK_STATUS,'COMPLETE','Completed','COMPLETE_WITH_ISSUES','Completed','SKIPPED', 'Skipped','Pending')