Concurrent Programs details

SELECT fcp.concurrent_program_id,

       fcp.concurrent_program_name,

       fcpt.user_concurrent_program_name,

       fcpt.description,

       fe.executable_name,

       fet.user_executable_name,

       fe.execution_file_name

  FROM apps.fnd_concurrent_programs fcp,

       apps.fnd_concurrent_programs_tl fcpt,

       apps.fnd_executables fe,

       apps.fnd_executables_tl fet

 WHERE     fe.executable_id = fet.executable_id

       AND fcp.concurrent_program_id = fcpt.concurrent_program_id

       AND fcpt.language = fet.language

       AND fcp.executable_id = fe.executable_id

       AND fcp.executable_application_id = fe.application_id

       AND fcpt.language = 'US'

       AND fcpt.user_concurrent_program_name LIKE

              'Averda Trial Balance All Entities Mapping Report'