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_reqsch.sql
REM
REM <SQLDIR_GRP>APPS_CONC_MAN APPS_ADMIN</SQLDIR_GRP>
REM
REM SQLDIR Group Descriptions:
REM	APPS		-	APPS General
REM	APPS_INST	-	APPS Installation
REM	APPS_CONC_PROG	-	APPS Concurrent Programs
REM	APPS_CONC_MAN	-	APPS Concurrent Managers
REM	APPS_ADMIN	-	APPS Administration
REM	DBF		- 	Data Files
REM	TABSP		- 	Tablespace
REM	UTIL		- 	Utility
REM	INDX		- 	Index
REM	LOG		- 	Redo Log
REM	RBS		- 	Rollback
REM	MAINT		- 	Maintenance
REM	REVERSE		- 	Reverse Engineering
REM	SGA		- 	SGA Maintenance
REM	TAB		- 	Table
REM	USER		- 	User Management
REM	STATS		- 	Statistics
REM	STORAGE		- 	Storage Management
REM	INIT		- 	Database Init Parameters
REM	LATCH		- 	Latches
REM	LOCK		- 	Locks
REM	SEGMENT		- 	Segment Management
REM	BACKUP		- 	Backup Management
REM	PQ		- 	Parallel Query
REM	TRACE		- 	SQL Tracing Tuning
REM	PART		- 	Partitioning
REM	MOST		- 	Favorite Scripts
REM 
REM Author:
REM	Vitaliy Mogilevskiy vit100gain@earthlink.net
REM
REM
REM 
REM Purpose:
REM     <SQLDIR_TXT>
REM	11i: reports all pending and running requests from 
REM	FND_CONCURRENT_REQUESTS table with details of USER
REM	START TIME, ARGS and PROG NAME.  Allows to limit the
REM	list to a certain PROGRAM.
REM     </SQLDIR_TXT>
REM
REM Usage:
REM     a_conc_reqsch.sql
REM 
REM Example:
REM     a_conc_reqsch.sql
REM
REM
REM History:
REM	03-29-2002	Vitaliy Mogilevskiy	Created
REM
REM


alter session set nls_date_format='DD-MON-RR HH24:MI';

set lines 132
set trims on
set echo off
set feed on
set pages 60

col request_id heading "Request ID"
col requested_start_date heading "Start Date"
col user_name format a10 trunc heading "APPS User"
col prg_name format a30 trunc heading "Program Name"
col args format a45 trunc heading "Agruments [first 45 chars]"

prompt Scheduled or running requests by date:
prompt

select /*+ ORDERED */
       reqs.request_id
,      reqs.requested_start_date requested_start_date
,      reqs.phase_code
,      reqs.status_code
,      reqs.hold_flag
,      reqs.cancel_or_hold
,      usr.user_name
,      prg.user_concurrent_program_name prg_name
,      argument_text args
from  apps.fnd_user usr
,     apps.fnd_concurrent_requests reqs
,     apps.fnd_concurrent_programs_tl prg
where reqs.phase_code IN ('P','R')
and   reqs.concurrent_program_id = prg.concurrent_program_id
and   prg.user_concurrent_program_name like '%&prog_like%'
and   reqs.requested_by = usr.user_id
order by DECODE(reqs.phase_code,'R',1,2)
,        reqs.requested_start_date
,        usr.user_name
/