DBA Data[Home] [Help]

APPS.FND_TRANSACTION dependencies on FND_CONC_PROCESSOR_PROGRAMS

Line 137: INDEX (fcpp,FND_CONC_PROCESSOR_PROGRAMS_U2) */

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,
141: fnd_global.user_id, fnd_global.resp_appl_id, fnd_global.resp_id,

Line 145: fnd_conc_processor_programs fcpp,

141: fnd_global.user_id, fnd_global.resp_appl_id, fnd_global.resp_id,
142: fcq.RUNNING_PROCESSES, fcq.max_processes
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