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
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));
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
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
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));
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