DBA Data[Home] [Help]

APPS.FND_TRANSACTION_QUEUE dependencies on FND_CONCURRENT_QUEUES

Line 63: INDEX (fcq,FND_CONCURRENT_QUEUES_N1)

59:
60: cursor tm(appl_short_name varchar2, prog_short_name varchar2,
61: resp_appl_id number, resp_id number) is
62: select /*+ ORDERED USE_NL (fa fcp fr fcpp fcq fcpr)
63: INDEX (fcq,FND_CONCURRENT_QUEUES_N1)
64: INDEX (fcpp,FND_CONC_PROCESSOR_PROGRAMS_U2) */
65: fcq.processor_application_id || '.' || fcq.concurrent_processor_id
66: from fnd_application fa,
67: fnd_concurrent_programs fcp,

Line 70: fnd_concurrent_queues fcq,

66: from fnd_application fa,
67: fnd_concurrent_programs fcp,
68: fnd_conc_processor_programs fcpp,
69: fnd_responsibility fr,
70: fnd_concurrent_queues fcq,
71: fnd_concurrent_processes fcpr
72: where fcq.processor_application_id = fcpp.processor_application_id
73: and fcq.concurrent_processor_id = fcpp.concurrent_processor_id
74: and fcpp.concurrent_program_id = fcp.concurrent_program_id