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: running_processes = 0;

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: running_processes = 0;
179:

Line 180: -- Reset control codes in fnd_concurrent_queues table

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

Line 181: Update fnd_concurrent_queues

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

Line 358: from fnd_concurrent_queues

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

Line 364: from fnd_concurrent_queues

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

Line 373: -- Delete from FND_CONCURRENT_QUEUES_TL table

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

Line 374: Delete From fnd_Concurrent_Queues_tl

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

Line 377: from fnd_concurrent_queues

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

Line 380: Delete from fnd_concurrent_queues_tl

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

Line 383: from fnd_concurrent_queues

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

Line 392: -- Delete from FND_CONCURRENT_QUEUES table

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

Line 393: Delete from fnd_concurrent_queues

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

Line 396: Delete from fnd_concurrent_queues

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