Advanced Search

Return to Snippet

Revision: 20885
at November 29, 2009 22:06 by kitzelh
Initial Code 
update FND_CONCURRENT_REQUESTS
set hold_flag = 'Y'
where REQUEST_ID in (
    select cr.REQUEST_ID
    from fnd_concurrent_programs_tl cp, fnd_concurrent_requests cr
    where cp.application_id = cr.program_application_id 
    AND cp.concurrent_program_id = cr.concurrent_program_id
    AND DECODE(cp.USER_CONCURRENT_PROGRAM_NAME,'Report Set', cr.DESCRIPTION, cp.USER_CONCURRENT_PROGRAM_NAME) = '&arg'
    AND cr.phase_code = 'P');
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Hold concurrent requests by name

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
Oracle

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PL/SQL