PROMPT Concurrent Programs by Request Type (RMINC)
PROMPT RMINC_req_type_progs.sql
PROMPT Copyright 2003 Reed-Matthews, Inc.
PROMPT for 11i
ttitle "Concurrent Programs by Request Type" 
set heading on
set linesize 180
set pagesize 9999
set wrap on
column REQUEST_CLASS_NAME format A20 heading 'Request Type'
column USER_CONCURRENT_PROGRAM_NAME format A50 heading 'User Program Name'
column CONCURRENT_PROGRAM_NAME format A30 heading 'Short Program Name'
select rc.REQUEST_CLASS_NAME, 
       cptl.USER_CONCURRENT_PROGRAM_NAME, 
       cp.CONCURRENT_PROGRAM_NAME
  from FND_CONCURRENT_PROGRAMS_TL cptl, 
       FND_CONCURRENT_PROGRAMS cp,
       FND_CONCURRENT_REQUEST_CLASS rc
 where rc.APPLICATION_ID = cp.CLASS_APPLICATION_ID
   and rc.REQUEST_CLASS_ID = cp.CONCURRENT_CLASS_ID
   and cp.APPLICATION_ID = cptl.APPLICATION_ID 
   and cp.CONCURRENT_PROGRAM_ID = cptl.CONCURRENT_PROGRAM_ID
   and rc.REQUEST_CLASS_NAME like nvl('&1','%')
 order by REQUEST_CLASS_NAME, USER_CONCURRENT_PROGRAM_NAME
 ;