PROMPT cost manager and worker requests that have not completed

select wrk.request_id ,
decode(wrk.phase_code,
'C','Complete',
'I','Inactive',
'P','Pending',
'R','Running',
'Unknown')
phase_code,
decode(wrk.status_code,
'C','Normal',
'D','Cancelled',
'E','Error',
'F','Scheduled',
'I','Normal',
'M','No Manager',
'Q','Standby',
'R','Normal',
'S','Suspended',
'T','Terminating',
'U','Disabled',
'W','Paused',
'Z','Waiting'
,'Unknown') status_code,
prg.concurrent_program_name,
substr(argument1,1,10) arg1,
substr(argument2,1,10) arg2,
substr(argument3,1,10) arg3
from fnd_concurrent_programs prg,
fnd_concurrent_requests wrk
where prg.application_id = wrk.program_application_id
and prg.concurrent_program_id =
wrk.concurrent_program_id
and prg.concurrent_program_name IN ('CMCICU','CMCMCW','CMCTCM','CMCACW','CMCCTW','CMCOCW')
and phase_code <> 'C'