DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: how to find request# from request name

  1. #1
    Join Date
    Dec 2005
    Posts
    6

    how to find request# from request name

    How to find the concurrent request number using a concurrent request name from back end tables?

    Thanks
    Mahipal

  2. #2
    Join Date
    Mar 2006
    Posts
    9

    you can change the %Gather% to your concurrrent program name

    select fcr.*,fcp.user_concurrent_program_name from fnd_concurrent_programs_tl fcp,
    fnd_concurrent_requests fcr
    where fcp.concurrent_program_id=fcr.concurrent_program_id
    and fcp.user_concurrent_program_name ='&YourConcurrentProgramName'



    you can try

    Edward china
    www.dba-oracle.org

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width