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