Concurrent programs which uses a value set

  SELECT fcpl.user_concurrent_program_name "Concurrent Program Name",

         fcp.concurrent_program_name "Short Name",

         fdfcuv.column_seq_num "Column Seq Number",

         fdfcuv.end_user_column_name "Parameter Name",

Code to get the RTF files from database

SELECT xtt.template_name "Template Name", xtb.template_code "Template Code",

       fat.application_name "Application Name",

       xddt.data_source_name "Data Definition",

       xtb.template_type_code "Template Type",

       xtb.default_language "Language", xtb.default_territory "Territory",

Query to display long running concurrent requests.

SET LINESIZE 200;

SET PAGES 9999;

SET HEAD ON;

--

SET HEAD OFF;

ACCEPT enddt  PROMPT 'ENTER the date (ex: 01-AUG-99) > ';

PROMPT;

SET HEAD ON;

--