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