Checking Request Set Parameter

For example you have a request set which will process a set of custom processes for a particular inventory organization as a parameter. You scheduled it for 5 different inventory organizations, and yet sometimes in the future, one inventory organization is no longer used. How to tell which request set is used for which inventory orgs ?

The problem is if we submit a scheduled request set several times with different parameters, normally when you see them in the Find – Requests Window, you wouldn’t be able to see the child concurrent requests parameter in it. 

Here’s one script to let you see them :

SELECT  
a.request_id,
b.user_concurrent_program_name,
c.argument1 parameter1,
a.request_date,
a.requested_start_date,
a.actual_start_date,
a.actual_completion_date,
         (SELECT meaning
            FROM apps.fnd_lookups
           WHERE lookup_type = ‘CP_STATUS_CODE’
             AND a.status_code = lookup_code) status,
         (SELECT meaning
            FROM apps.fnd_lookups
           WHERE lookup_type = ‘CP_PHASE_CODE’
             AND a.phase_code = lookup_code) phase
FROM
fnd_concurrent_requests a,
fnd_concurrent_programs_tl b,
fnd_run_requests c
WHERE a.concurrent_program_id = b.concurrent_program_id
AND a.request_id = c.parent_request_id
AND c.argument1 = <your organization id>
ORDER BY actual_start_date, user_concurrent_program_name