-- --------------------------------------------------------------------------------
-- File Name	:	scheduled_programs.sql
-- --------------------------------------------------------------------------------
-- Author	:	Danilo Vizzarro (http://www.danilovizzarro.it)
-- Download	:	http://www.danilovizzarro.it/scripts/
-- Date		:	6-FEB-2009
-- Version	:	1.0
-- --------------------------------------------------------------------------------
-- Usage	:	This script return the scheduled concurrent programs and
--			request sets			
-- --------------------------------------------------------------------------------
-- License	:	http://creativecommons.org/licenses/by-nc/3.0/
--			You are free:
--			-> to Share - to copy, distribute and transmit the work
--			-> to Remix - to adapt the work
--			Under the following conditions:
--			-> Attribution. You must attribute the work in the manner 
--			specified by the author or licensor (but not in any way that 
--			suggests that they endorse you or your use of the work).
--			-> Noncommercial. You may not use this work for commercial 
--			purposes.
-- --------------------------------------------------------------------------------

SELECT A.REQUEST_ID, B.USER_NAME, C.USER_CONCURRENT_PROGRAM_NAME, C.ARGUMENT_TEXT
FROM FND_CONCURRENT_REQUESTS A, FND_USER B, FND_CONC_REQ_SUMMARY_V C
WHERE B.USER_ID = A.REQUESTED_BY
AND A.REQUEST_ID = C.REQUEST_ID
AND A.REQUESTED_START_DATE > SYSDATE
AND A.HOLD_FLAG = 'N'
AND A.STATUS_CODE IN ('Q','I')
AND B.USER_NAME LIKE '%'
AND A.DESCRIPTION LIKE '%'
ORDER BY A.REQUEST_ID
/