Identify executable name of concurrent program

Easily identify executable file name of concurrent request.

SELECT fcpv.user_concurrent_program_name concurrent_program_name,
       fe.execution_file_name source_name,
       fl.meaning program_type
  FROM apps.fnd_concurrent_programs_vl fcpv,
       apps.fnd_executables fe,
       apps.fnd_lookups fl
 WHERE     fe.executable_id = fcpv.executable_id
       AND fl.lookup_type = 'CP_EXECUTION_METHOD_CODE'
       AND fl.lookup_code = fe.execution_method_code
       AND fcpv.user_concurrent_program_name LIKE '&concurrent_program_name';

Identify executable name of concurrent program

Tags