Advanced Search

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,
e.executable_name,responsibility_key,user_concurrent_program_name
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 
http://www.oappssurd.com/2009/04/find-request-group-based-on-concurrent.html
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
                                        

                                    

                                    
SQL