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.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.sql
REM 
REM Example:
REM	a_conc_prog_detail_R11.sql
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
,       'Description:       '||   FCPT.DESCRIPTION                   new_line
,       'Executable Name:   '||   EXE.EXECUTABLE_NAME                new_line
,       'Executable File:   '||   EXE.EXECUTION_FILE_NAME            new_line
,       'Execution Type:    '||   decode(EXE.EXECUTION_METHOD_CODE,
                        'B', 'Request Set Stage Function',
                        'Q', 'SQL*Plus',
                        'H', 'Host',
                        'L', 'SQL*Loader',
                        'A', 'Spawned',
                        'I', 'PL/SQL Stored Procedure',
                        'P', 'Oracle Reports',
                        'S', 'Immediate',EXE.EXECUTION_METHOD_CODE)  new_line
,       'Style Req ?:       '||   FND.REQUIRED_STYLE                 new_line
,       'Style Type:        '||   FND.OUTPUT_PRINT_STYLE             new_line
,       'Printer Name:      '||   FND.PRINTER_NAME                   new_line
,       'Min WIDTH:         '||   FND.MINIMUM_WIDTH                  new_line
,       'Max WIDTH:         '||   FND.MAXIMUM_WIDTH                  new_line
,       'Min LENGHT:        '||   FND.MINIMUM_LENGTH                 new_line
,       'Max LENGHT:        '||   FND.MAXIMUM_LENGTH                 new_line
FROM  APPLSYS.FND_EXECUTABLES             EXE
,     APPLSYS.FND_CONCURRENT_PROGRAMS     FND
,     APPLSYS.FND_CONCURRENT_PROGRAMS_TL  FCPT
WHERE FCPT.USER_CONCURRENT_PROGRAM_NAME LIKE '&NAME'
AND   FCPT.APPLICATION_ID        = FND.APPLICATION_ID
AND   FCPT.CONCURRENT_PROGRAM_ID = FND.CONCURRENT_PROGRAM_ID
AND   FND.EXECUTABLE_ID          = EXE.EXECUTABLE_ID
/