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.

APPS.FND_CONC_CLONE dependencies on FND_CONCURRENT_QUEUES

Line 108: from fnd_concurrent_queues

104: -- Delete info from FND_CONCURRENT_QUEUE_SIZE table
105: Delete From fnd_Concurrent_Queue_Size
106: where concurrent_queue_id in
107: (Select concurrent_queue_id
108: from fnd_concurrent_queues
109: where manager_type in (2,6));
110:
111: Delete from fnd_concurrent_queue_size
112: where concurrent_queue_id in

Line 114: from fnd_concurrent_queues

110:
111: Delete from fnd_concurrent_queue_size
112: where concurrent_queue_id in
113: (select concurrent_queue_id
114: from fnd_concurrent_queues
115: where manager_type in
116: ( select service_id
117: from fnd_cp_services
118: where upper(service_handle) in

Line 123: -- Delete from FND_CONCURRENT_QUEUES_TL table

119: ('FORMSL', 'FORMSMS', 'FORMSMC',
120: 'REPSERV', 'TCF', 'APACHE',
121: 'JSERV', 'OAMGCS')));
122:
123: -- Delete from FND_CONCURRENT_QUEUES_TL table
124: Delete From fnd_Concurrent_Queues_tl
125: where concurrent_queue_id in
126: (Select concurrent_queue_id
127: from fnd_concurrent_queues

Line 124: Delete From fnd_Concurrent_Queues_tl

120: 'REPSERV', 'TCF', 'APACHE',
121: 'JSERV', 'OAMGCS')));
122:
123: -- Delete from FND_CONCURRENT_QUEUES_TL table
124: Delete From fnd_Concurrent_Queues_tl
125: where concurrent_queue_id in
126: (Select concurrent_queue_id
127: from fnd_concurrent_queues
128: where manager_type in (2,6));

Line 127: from fnd_concurrent_queues

123: -- Delete from FND_CONCURRENT_QUEUES_TL table
124: Delete From fnd_Concurrent_Queues_tl
125: where concurrent_queue_id in
126: (Select concurrent_queue_id
127: from fnd_concurrent_queues
128: where manager_type in (2,6));
129:
130: Delete from fnd_concurrent_queues_tl
131: where concurrent_queue_id in

Line 130: Delete from fnd_concurrent_queues_tl

126: (Select concurrent_queue_id
127: from fnd_concurrent_queues
128: where manager_type in (2,6));
129:
130: Delete from fnd_concurrent_queues_tl
131: where concurrent_queue_id in
132: (select concurrent_queue_id
133: from fnd_concurrent_queues
134: where manager_type in

Line 133: from fnd_concurrent_queues

129:
130: Delete from fnd_concurrent_queues_tl
131: where concurrent_queue_id in
132: (select concurrent_queue_id
133: from fnd_concurrent_queues
134: where manager_type in
135: (select service_id
136: from fnd_cp_services
137: where upper(service_handle) in

Line 142: -- Delete from FND_CONCURRENT_QUEUES table

138: ('FORMSL', 'FORMSMS', 'FORMSMC',
139: 'REPSERV', 'TCF', 'APACHE',
140: 'JSERV', 'OAMGCS')));
141:
142: -- Delete from FND_CONCURRENT_QUEUES table
143: Delete from fnd_concurrent_queues
144: where manager_type in (2,6);
145:
146: Delete from fnd_concurrent_queues

Line 143: Delete from fnd_concurrent_queues

139: 'REPSERV', 'TCF', 'APACHE',
140: 'JSERV', 'OAMGCS')));
141:
142: -- Delete from FND_CONCURRENT_QUEUES table
143: Delete from fnd_concurrent_queues
144: where manager_type in (2,6);
145:
146: Delete from fnd_concurrent_queues
147: where manager_type in

Line 146: Delete from fnd_concurrent_queues

142: -- Delete from FND_CONCURRENT_QUEUES table
143: Delete from fnd_concurrent_queues
144: where manager_type in (2,6);
145:
146: Delete from fnd_concurrent_queues
147: where manager_type in
148: (select service_id
149: from fnd_cp_services
150: where upper(service_handle) in

Line 174: -- Reset FND_CONCURRENT_QUEUES table

170: ' where fcr.cd_id = fcd.cd_id ' ||
171: ' and phase_code in (''P'', ''R''))';
172:
173:
174: -- Reset FND_CONCURRENT_QUEUES table
175: Update fnd_concurrent_queues
176: set diagnostic_level = null,
177: target_node = null, max_processes = 0,
178: node_name = null, node_name2 = null,

Line 175: Update fnd_concurrent_queues

171: ' and phase_code in (''P'', ''R''))';
172:
173:
174: -- Reset FND_CONCURRENT_QUEUES table
175: Update fnd_concurrent_queues
176: set diagnostic_level = null,
177: target_node = null, max_processes = 0,
178: node_name = null, node_name2 = null,
179: running_processes = 0;

Line 181: -- Reset control codes in fnd_concurrent_queues table

177: target_node = null, max_processes = 0,
178: node_name = null, node_name2 = null,
179: running_processes = 0;
180:
181: -- Reset control codes in fnd_concurrent_queues table
182: Update fnd_concurrent_queues
183: set control_code = NULL
184: where control_code not in ('E', 'R', 'X')
185: and control_code IS NOT NULL;

Line 182: Update fnd_concurrent_queues

178: node_name = null, node_name2 = null,
179: running_processes = 0;
180:
181: -- Reset control codes in fnd_concurrent_queues table
182: Update fnd_concurrent_queues
183: set control_code = NULL
184: where control_code not in ('E', 'R', 'X')
185: and control_code IS NOT NULL;
186:

Line 357: from fnd_concurrent_queues

353:
354: Delete From fnd_Concurrent_Queue_Size
355: where concurrent_queue_id in
356: (Select concurrent_queue_id
357: from fnd_concurrent_queues
358: where manager_type in (2,6));
359:
360: Delete from fnd_concurrent_queue_size
361: where concurrent_queue_id in

Line 363: from fnd_concurrent_queues

359:
360: Delete from fnd_concurrent_queue_size
361: where concurrent_queue_id in
362: (select concurrent_queue_id
363: from fnd_concurrent_queues
364: where manager_type in
365: ( select service_id
366: from fnd_cp_services
367: where upper(service_handle) in

Line 372: -- Delete from FND_CONCURRENT_QUEUES_TL table

368: ('FORMSL', 'FORMSMS', 'FORMSMC',
369: 'REPSERV', 'TCF', 'APACHE',
370: 'JSERV', 'OAMGCS')));
371:
372: -- Delete from FND_CONCURRENT_QUEUES_TL table
373: Delete From fnd_Concurrent_Queues_tl
374: where concurrent_queue_id in
375: (Select concurrent_queue_id
376: from fnd_concurrent_queues

Line 373: Delete From fnd_Concurrent_Queues_tl

369: 'REPSERV', 'TCF', 'APACHE',
370: 'JSERV', 'OAMGCS')));
371:
372: -- Delete from FND_CONCURRENT_QUEUES_TL table
373: Delete From fnd_Concurrent_Queues_tl
374: where concurrent_queue_id in
375: (Select concurrent_queue_id
376: from fnd_concurrent_queues
377: where manager_type in (2,6));

Line 376: from fnd_concurrent_queues

372: -- Delete from FND_CONCURRENT_QUEUES_TL table
373: Delete From fnd_Concurrent_Queues_tl
374: where concurrent_queue_id in
375: (Select concurrent_queue_id
376: from fnd_concurrent_queues
377: where manager_type in (2,6));
378:
379: Delete from fnd_concurrent_queues_tl
380: where concurrent_queue_id in

Line 379: Delete from fnd_concurrent_queues_tl

375: (Select concurrent_queue_id
376: from fnd_concurrent_queues
377: where manager_type in (2,6));
378:
379: Delete from fnd_concurrent_queues_tl
380: where concurrent_queue_id in
381: (select concurrent_queue_id
382: from fnd_concurrent_queues
383: where manager_type in

Line 382: from fnd_concurrent_queues

378:
379: Delete from fnd_concurrent_queues_tl
380: where concurrent_queue_id in
381: (select concurrent_queue_id
382: from fnd_concurrent_queues
383: where manager_type in
384: (select service_id
385: from fnd_cp_services
386: where upper(service_handle) in

Line 391: -- Delete from FND_CONCURRENT_QUEUES table

387: ('FORMSL', 'FORMSMS', 'FORMSMC',
388: 'REPSERV', 'TCF', 'APACHE',
389: 'JSERV', 'OAMGCS')));
390:
391: -- Delete from FND_CONCURRENT_QUEUES table
392: Delete from fnd_concurrent_queues
393: where manager_type in (2,6);
394:
395: Delete from fnd_concurrent_queues

Line 392: Delete from fnd_concurrent_queues

388: 'REPSERV', 'TCF', 'APACHE',
389: 'JSERV', 'OAMGCS')));
390:
391: -- Delete from FND_CONCURRENT_QUEUES table
392: Delete from fnd_concurrent_queues
393: where manager_type in (2,6);
394:
395: Delete from fnd_concurrent_queues
396: where manager_type in

Line 395: Delete from fnd_concurrent_queues

391: -- Delete from FND_CONCURRENT_QUEUES table
392: Delete from fnd_concurrent_queues
393: where manager_type in (2,6);
394:
395: Delete from fnd_concurrent_queues
396: where manager_type in
397: (select service_id
398: from fnd_cp_services
399: where upper(service_handle) in

Line 418: -- Reset FND_CONCURRENT_QUEUES table

414: from fnd_concurrent_requests fcr
415: where fcr.cd_id = fcd.cd_id
416: and phase_code in ('P', 'R'));
417:
418: -- Reset FND_CONCURRENT_QUEUES table
419: Update fnd_concurrent_queues
420: set diagnostic_level = null,
421: target_node = null, max_processes = 0,
422: node_name = null, node_name2 = null,

Line 419: Update fnd_concurrent_queues

415: where fcr.cd_id = fcd.cd_id
416: and phase_code in ('P', 'R'));
417:
418: -- Reset FND_CONCURRENT_QUEUES table
419: Update fnd_concurrent_queues
420: set diagnostic_level = null,
421: target_node = null, max_processes = 0,
422: node_name = null, node_name2 = null,
423: running_processes = 0;

Line 425: -- Reset control codes in fnd_concurrent_queues table

421: target_node = null, max_processes = 0,
422: node_name = null, node_name2 = null,
423: running_processes = 0;
424:
425: -- Reset control codes in fnd_concurrent_queues table
426: Update fnd_concurrent_queues
427: set control_code = NULL
428: where control_code not in ('E', 'R', 'X')
429: and control_code IS NOT NULL;

Line 426: Update fnd_concurrent_queues

422: node_name = null, node_name2 = null,
423: running_processes = 0;
424:
425: -- Reset control codes in fnd_concurrent_queues table
426: Update fnd_concurrent_queues
427: set control_code = NULL
428: where control_code not in ('E', 'R', 'X')
429: and control_code IS NOT NULL;
430: