View: ALR_SCHEDULED_PROGRAMS

Product:	ALR - Alert
Description:	- Retrofitted
Implementation/DBA Data:	APPS.ALR_SCHEDULED_PROGRAMS

View Text

SELECT APPLICATION_ID
, CONCURRENT_PROGRAM_ID
, CONCURRENT_PROGRAM_NAME
, USER_CONCURRENT_PROGRAM_NAME
, 'ALR'
FROM FND_CONCURRENT_PROGRAMS_VL
WHERE APPLICATION_ID = 160
AND CONCURRENT_PROGRAM_NAME IN ('ALEPPE'
, 'ALPPIM') UNION ALL SELECT APPLICATION_ID
, CONCURRENT_QUEUE_ID
, 'ICM'
, CONCURRENT_QUEUE_NAME
, 'FND'
FROM FND_CONCURRENT_QUEUES
WHERE APPLICATION_ID = 0
AND CONCURRENT_QUEUE_ID = 1

Columns