DBA Data[Home] [Help]

APPS.FND_TRANSACTION_PIPE dependencies on FND_CONCURRENT_QUEUES

Line 48: INDEX (fcq,FND_CONCURRENT_QUEUES_N1)

44:
45: cursor tm(appl_short_name varchar2, prog_short_name varchar2,
46: resp_appl_id number, resp_id number) is
47: select /*+ ORDERED USE_NL (fa fcp fr fcpp fcq)
48: INDEX (fcq,FND_CONCURRENT_QUEUES_N1)
49: INDEX (fcpp,FND_CONC_PROCESSOR_PROGRAMS_U2) */
50: fcq.concurrent_queue_id
51: from fnd_application fa,
52: fnd_concurrent_programs fcp,

Line 55: fnd_concurrent_queues fcq,

51: from fnd_application fa,
52: fnd_concurrent_programs fcp,
53: fnd_conc_processor_programs fcpp,
54: fnd_responsibility fr,
55: fnd_concurrent_queues fcq,
56: fnd_concurrent_processes fcpr
57: where fcq.processor_application_id = fcpp.processor_application_id
58: and fcq.concurrent_processor_id = fcpp.concurrent_processor_id
59: and fcpp.concurrent_program_id = fcp.concurrent_program_id