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