REM RMINC_request_set_stage.sql
REM
REM Copyright 2006, All Rights Reserved, Reed-Matthews, Inc.
REM Concurrent Program Name:  Concurrent Request Set Stages Incompatibility
REM  
REM If you can change your request sets so that they have the
REM "Allow Incompatibilities" box checked, the program names will show up
REM in the RMINC_rpthis.sql program.  This will allow you to assign specific
REM request sets and request set stages to a particular concurrent manager,
REM which will help you control performance of your concurrent manager better.
REM First, tell us which programs have the Allow Incompatibilities box checked:
REM 
set linesize 180
set pagesize 999
column 'Request Set Name' format a23 heading 'Request Set Name'
column 'Program Name' format a40 heading 'Program Name'
column 'User Name' format a15 heading 'User Name'

ttitle 'Programs That Have The Allow Incompatibilities Box Checked' SKIP 2

select substr(a.request_set_name,1,23) "Request Set Name",
substr(a.user_request_set_name,1,40) "Program Name",
substr(b.user_name,1,15) "User Name"
from fnd_request_sets_vl a, 
fnd_user b where
a.created_by=b.user_id
and a.ALLOW_CONSTRAINTS_FLAG='Y'
order by b.user_name,a.request_set_name;

REM Then tell us which programs don't have the Allow Incompatibilities box checked:

ttitle 'Programs That Do NOT Have The Allow Incompatibilities Box Checked' SKIP 2

select substr(a.request_set_name,1,23) "Request Set Name",
substr(a.user_request_set_name,1,40) "Program Name",
substr(b.user_name,1,15) "User Name"
from fnd_request_sets_vl a,
fnd_user b where
a.created_by=b.user_id
and a.ALLOW_CONSTRAINTS_FLAG='N'
order by b.user_name,a.request_set_name;