Hold concurrent requests by name
Copy this code and paste it in your HTML
UPDATE FND_CONCURRENT_REQUESTS
FROM fnd_concurrent_programs_tl cp
, fnd_concurrent_requests cr
WHERE cp
.application_id
= cr
.program_application_id
AND cp
.concurrent_program_id
= cr
.concurrent_program_id
AND DECODE(cp
.USER_CONCURRENT_PROGRAM_NAME
,'Report Set', cr
.DESCRIPTION
, cp
.USER_CONCURRENT_PROGRAM_NAME
) = '&arg' AND cr
.phase_code
= 'P');
Report this snippet
Comments
Subscribe to comments