REM RMINC_trace_enabled.sql
REM
REM Copyright 2006, All Rights Reserved, Reed-Matthews, Inc.
REM Concurrent Program Name:  Concurrent Programs With Trace Enabled
REM
REM Shows which programs are defined with Trace enabled. Generally, 
REM you should enable trace for a program while you are debugging, 
REM but then you should turn it off when you're done.
REM 
set feedback on
set heading on
ttitle center 'Programs That Have Trace Enabled' SKIP 2
set pagesize 999
set linesize 180

column 'Program Name' format a23 heading 'Program Name'
column 'User Program Name' format a40 heading 'User Program Name'
column 'Last Updated By' format a15 heading 'Last Updated By'
column Description format a25 heading 'Description'

select a.concurrent_program_name "Program Name",
substr(a.user_concurrent_program_name,1,40) "User Program Name",
substr(b.user_name,1,15) "Last Updated By",
substr(b.description,1,25) Description
from fnd_concurrent_programs_vl a,fnd_user b
where a.enable_trace='Y'
and a.last_updated_by=b.user_id;