Thursday, July 12, 2012

Concurrent program Request Groups

SELECT e.executable_name , concurrent_program_name , user_concurrent_program_name , grp.REQUEST_GROUP_NAME FROM fnd_request_group_units u , fnd_request_groups grp , fnd_executables e , fnd_concurrent_programs_vl fcp WHERE u.request_unit_id = fcp.concurrent_program_id AND fcp.executable_id = e.executable_id --AND concurrent_program_name IN --AND user_concurrent_program_name like '%Clear Orphan%' AND grp.request_group_id = u.request_group_id ORDER BY 1

No comments:

Post a Comment