eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ALR_SCHEDULED_PROGRAMS

Source

View Text - Preformatted


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

View Text - HTML Formatted

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