Query to find Concurrent Request Details against input Concurrent Program
SELECT concurrent_program_name, fcr.*
FROM fnd_concurrent_programs fcp, fnd_concurrent_requests fcr
WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
AND fcp.concurrent_program_name = 'XX_TECHHARDS';
***********************************************************************************
#Oracle Apps #EBS #Concurrent Request #Concurrent Programs
#How to get concurrent Request Details