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_prog_detail_R11_2.sql
REM
REM <SQLDIR_GRP>APPS_CONC_PROG</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy (www.dbatoolz.com)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	Reports concurrent program definition
REM	</SQLDIR_TXT>
REM
REM Usage:
REM	a_conc_prog_detail_R11_2.sql <P1> <P2> <Pn>
REM 
REM Example:
REM	a_conc_prog_detail_R11_2.sql <P1> <P2> <Pn>
REM
REM
REM History:
REM	08-01-1999	VMOGILEV	Created
REM
REM

set lines 132
ttitle off
btitle off
set pages 0

col new_line format a132


SELECT  'Program User Name:      '||   FCPT.USER_CONCURRENT_PROGRAM_NAME  new_line
,       'Program Short Name:     '||   FND.CONCURRENT_PROGRAM_NAME        new_line
,       'Application Short Name: '||   FA.application_Short_name          new_line
FROM  applsys.fnd_application             FA
,     APPLSYS.FND_CONCURRENT_PROGRAMS     FND
,     APPLSYS.FND_CONCURRENT_PROGRAMS_TL  FCPT
WHERE lower(FCPT.USER_CONCURRENT_PROGRAM_NAME) LIKE '&user_program_name'
AND   FCPT.APPLICATION_ID        = FND.APPLICATION_ID
AND   FCPT.CONCURRENT_PROGRAM_ID = FND.CONCURRENT_PROGRAM_ID
AND   FCPT.APPLICATION_ID        = FA.APPLICATION_ID
/