Return to Snippet

Revision: 49669
at July 28, 2011 01:37 by theonlyalterego

Initial Code
select --r.rowid rrowid,p.rowid prowid,e.rowid erowid,fcp.rowid frowid,
from fnd_responsibility r,
fnd_concurrent_programs_tl p,
fnd_request_group_units u,
fnd_executables e,
fnd_concurrent_programs fcp
where r.request_group_id=u.request_group_id
and u.request_unit_id = p.concurrent_program_id
--and executable_name like '%SEARCH EXECUTABLE PATTERN%'
and fcp.executable_id = e.executable_id
and user_concurrent_program_name like '%SEARCH PATTERN%'
and fcp.concurrent_program_id = p.concurrent_program_id

Initial URL

Initial Description

Initial Title
Oracle - Find all responsibilities and concurrent program names based on the executable Name

Initial Tags
sql, search, Oracle, find

Initial Language