Saturday, May 17, 2014

Concurrent Program to Executable Name Drill Down Oracle R12

SELECT fcpv.concurrent_program_name,
  fcpv.user_concurrent_program_name,
  fefv.executable_name,
  fefv.execution_file_name,
  fefv.execution_file_path
FROM fnd_concurrent_programs_vl fcpv,
  fnd_executables_form_v fefv
WHERE fcpv.executable_id = fefv.executable_id
AND fcpv.user_concurrent_program_name LIKE '%File%Watcher%'

0 comments:

Post a Comment