Friday, February 16, 2018


Query to find log file count

SELECT 
         fcr.logfile_node_name,count(1)
    FROM apps.fnd_concurrent_requests fcr,
         apps.fnd_concurrent_programs fcp,
         apps.fnd_concurrent_programs_tl fcpt,
         apps.fnd_user fu,
         apps.fnd_responsibility_tl fr
   WHERE 1 = 1
     AND fcr.actual_start_date >= to_date('2/16/2017 10:10','MM/DD/RRRR hh24:mi')
     AND fcr.concurrent_program_id = fcp.concurrent_program_id
     AND fcp.concurrent_program_id = fcpt.concurrent_program_id
     AND fcr.program_application_id = fcp.application_id
     AND fcp.application_id = fcpt.application_id
     AND fcr.requested_by = fu.user_id
     AND fcpt.LANGUAGE = 'US'
     AND fcr.responsibility_id = fr.responsibility_id
     AND fr.LANGUAGE = 'US'
group by fcr.logfile_node_name;


No comments:

Post a Comment