APPS.FND_TRANSACTION dependencies on FND_CONCURRENT_QUEUES

Line 112: fnd_concurrent_queues fcq,

108: fcp.application_id, fcp.concurrent_program_id,
109: fnd_global.user_id, fnd_global.resp_appl_id, fnd_global.resp_id,
110: fcq.RUNNING_PROCESSES, fcq.max_processes
111: from fnd_concurrent_programs fcp,
112: fnd_concurrent_queues fcq,
113: fnd_application fa
114: where fcp.concurrent_program_name = program
115: and fcq.concurrent_queue_id = queue_id
116: and fcp.application_id = fa.application_id

Line 136: INDEX (fcq,FND_CONCURRENT_QUEUES_N1)

132: USER_ID, RESP_APPL_ID, RESPONSIBILITY_ID,
133: RUNNING_PROCESSES, TARGET_PROCESSES)
134: SELECT
135: /*+ ORDERED USE_NL (fa fcp fr fcpp fcq)
136: INDEX (fcq,FND_CONCURRENT_QUEUES_N1)
137: INDEX (fcpp,FND_CONC_PROCESSOR_PROGRAMS_U2) */
138: 3, sysdate, request_id,
139: FCQ.application_id, FCQ.concurrent_queue_id,
140: fcp.application_id, fcp.concurrent_program_id,

Line 147: fnd_concurrent_queues fcq

143: from fnd_application fa,
144: fnd_concurrent_programs fcp,
145: fnd_conc_processor_programs fcpp,
146: fnd_responsibility fr,
147: fnd_concurrent_queues fcq
148: where fcp.concurrent_program_name = program
149: and fcq.processor_application_id = fcpp.processor_application_id
150: and fcq.concurrent_processor_id = fcpp.concurrent_processor_id
151: and fcpp.concurrent_program_id = fcp.concurrent_program_id

Line 183: from fnd_concurrent_queues fcq

179: FCQ.application_id, fcq.concurrent_queue_id,
180: temp_fcp_application_id, temp_fcp_concurrent_program_id,
181: fnd_global.user_id, fnd_global.resp_appl_id, fnd_global.resp_id,
182: fcq.RUNNING_PROCESSES, fcq.max_processes, timeout
183: from fnd_concurrent_queues fcq
184: where fcq.concurrent_queue_id = to_number(substr(tm_pipe,11));
185: else
186: insert into fnd_tm_events
187: (EVENT_TYPE, TIMESTAMP, TRANSACTION_ID,