Query para pesquisa de Concurrents no EBS ARTIGO EXCLUSIVO  

Query para pesquisa de Concurrents no EBS

Olá pessoal !

Me pediram uma query que trouxesse os detalhes dos concurrents em execução e programados no EBS. Aproveitei e montei algo um pouco mais completo e vou compartilhar com vocês. 🙂

SELECT
TO_CHAR
        (
         fcr.requested_start_date
        ,'DD/MM/RRRR hh24:mi:ss'
        ) requested_start_date
 ,fcr.request_id
 ,fcr.concurrent_program_id
 ,fcr.requested_by
 ,DECODE
 (
 fcr.status_code
 ,'A','Waiting' ,'B','Resuming'   ,'C','Normal'  ,'D','Cancelled'
 ,'E','Error' ,'F','Scheduled'  ,'G','Warning' ,'H','On Hold'
 ,'I','Normal','M','No Manager' ,'Q','Standby' ,'R','Normal'
 ,'S','Suspended' ,'T','Terminating','U','Disabled','W','Paused'
 ,'X','Terminated','Z','Waiting'
 ,fcr.status_code
 ) "status code"
 ,DECODE
(
 fcr.phase_code
 ,'C','Completed','I','Inactive','P','Pending','R','Running'
 ,fcr.phase_code
 ) "phase code"
 ,fcp.user_concurrent_program_name
 ,fre.responsibility_name
 ,fcr.request_date
 ,fcr.argument_text
 ,fcr.logfile_name
 ,fcr.outfile_name
 ,fcr.output_file_type
 ,fus.user_name
FROM fnd_concurrent_requests fcr 
    ,fnd_concurrent_programs_tl fcp
    ,fnd_responsibility_tl fre
    ,fnd_user fus
WHERE fcr.concurrent_program_id = fcp.concurrent_program_id
AND fcr.responsibility_id = fre.responsibility_id
AND fcr.requested_by = fus.user_id
AND TRUNC(fcr.requested_start_date) = TRUNC(SYSDATE)
-- AND user_name = '<USER>' - POR OWNER DO CONCURRENT
-- AND status_code IN ('S','T','U','W','X') -- ERRO, PARADA OU FALHA
-- AND status_code IN ('H') -- Concurrent parado 
-- AND fcr.phase_code = 'R'-- EXECUTANDO

ORDER BY fcr.requested_start_date DESC;

Espero que essa Query seja útil a outros ! 🙂

Um grande abraço