REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	a_conc_man_prog_R11.sql
REM
REM <SQLDIR_GRP>APPS_CONC_MAN</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy (vit100gain@earthlink.net)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	Reports program names for a given concurent 
REM	manager based on the library link
REM	</SQLDIR_TXT>
REM
REM Usage:
REM	a_conc_man_prog_R11.sql
REM 
REM Example:
REM	a_conc_man_prog_R11.sql
REM
REM
REM History:
REM	MM-DD-RRRR	VMOGILEV	Created
REM
REM

clear breaks
clear col
ttitle off
btitle off

set verify off
set pages 90

col manager noprint    new_value n_manager
col cprocn  noprint    new_value n_cprocn
col d       noprint    new_value n_d
col cprogn  format a10 heading "Program|Name"
col cprogd  format a55 heading "Program|Description"

break on manager skip page

ttitle   -
         "Manager Name ............ : " n_manager -
         skip 1 -
         "Processor Name .......... : " n_cprocn -
         skip 1 -
         "Processor Description ... : " n_d -
         skip 2 -

select    fcqv.USER_CONCURRENT_QUEUE_NAME     manager
,         fcproc.concurrent_processor_name    cprocn
,         fcproc.description                  d
,         fcprog.concurrent_program_name      cprogn
,         fcprogtl.description                cprogd
from       fnd_concurrent_queues_vl        fcqv
,          fnd_concurrent_processors       fcproc
,          fnd_conc_processor_programs     fcpp
,          fnd_concurrent_programs         fcprog
,          fnd_concurrent_programs_tl      fcprogtl
where     fcqv.USER_CONCURRENT_QUEUE_NAME like '&Enter_manager_name_like'
and       fcqv.concurrent_processor_id    = fcproc.concurrent_processor_id
and       fcproc.concurrent_processor_id  = fcpp.concurrent_processor_id
and       fcpp.concurrent_program_id      = fcprog.concurrent_program_id
and       fcprog.concurrent_program_id    = fcprogtl.concurrent_program_id
order by   fcproc.concurrent_processor_name
,          fcproc.description
,          fcprog.concurrent_program_name
/