Shortname.sql

column program_name format a20 heading 'Program Name'
column program_id format 9999999 heading 'Program ID'
column user_program format a50 heading 'User Program Name'
column executable_id format 9999999 heading 'Executable ID'
select concurrent_program_name program_name, concurrent_program_id program_id,
       user_concurrent_program_name user_program, executable_id
from apps.fnd_concurrent_programs_vl
where user_concurrent_program_name like '%&user_concurrent_program_name%'
/