remove hold to a concurrent request
I have a FNDGSCST approx 8 records in fnd_concurrent_requests, where latest run time (of 8 records) has correct options to remove the hold flag , I did remove HOLD with below sql, do anyother one have better sql than this?
update applsys.fnd_concurrent_requests a set hold_flag = 'N' where phase_code = 'P' and status_code in ('Q','I') and exists (select 'x'
from applsys.fnd_concurrent_programs b
where b.concurrent_program_id = a.concurrent_program_id
and application_id = program_application_id
and concurrent_program_name in ('FNDGSCST') ) and REQUEST_DATE like (SELECT MAX (fcr.REQUEST_DATE)
FROM fnd_concurrent_requests fcr,