Friday, 21 October 2011

Query to find out concurrent program details

select
prog.user_concurrent_program_name "program name",
prog.concurrent_program_name "program short name",
appl.application_name "program application name",
prog.description "program description",
exe.executable_name "executable name",
exe.execution_file_name "executable file name",
decode( exe.execution_method_code, 'I', 'PLSQL Stored Procedure', 'P', 'Report', 'L', 'SQL Loader','Q','SQL*Plus', exe.execution_method_code) "execution method"
from
fnd_executables exe,
fnd_application_tl appl,
fnd_concurrent_programs_vl prog
where exe.application_id = appl.application_id
AND exe.executable_id = prog.executable_id
AND appl.language='US'
AND prog.user_concurrent_program_name =:p_conc_prog_name
Posted by at

4 comments:

  1. _____20 January 2013 at 22:52

    Thankooo :)

    ReplyDelete
  2. MadhusudhanPadamatinti21 January 2013 at 00:06

    Most Welcome ...

    ReplyDelete
  3. Anonymous27 December 2014 at 12:26

    This query is useful.

    FYI,

    Note the values for Spawned is 'A', Java Concurrent Program is 'K', Request Set Stage Function is 'B', Host is 'H', Immediate is 'S' , Java Stored Procedure is 'J' and Multi-Language Function is 'M'

    Thanks,
    S Anees

    ReplyDelete

Subscribe to: Post Comments (Atom)