REM RMINC_req_type_progs.sql
REM Copyright 2006, All Rights Reserved, Reed-Matthews, Inc.
REM Concurrent Program Name:  Concurrent Programs by Request Type
REM
REM Gives you a list of concurrent programs that have been 
REM assigned to a request type, ordered by request type
REM
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
 order by REQUEST_CLASS_NAME, USER_CONCURRENT_PROGRAM_NAME
 ;