APPS.FND_TRANSACTION_QUEUE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 62

    select /*+ ORDERED USE_NL (fa fcp fr fcpp fcq fcpr)
            INDEX (fcq,FND_CONCURRENT_QUEUES_N1)
            INDEX (fcpp,FND_CONC_PROCESSOR_PROGRAMS_U2) */
         fcq.processor_application_id || '.' || fcq.concurrent_processor_id
    from fnd_application fa,
         fnd_concurrent_programs fcp,
         fnd_conc_processor_programs fcpp,
         fnd_responsibility fr,
         fnd_concurrent_queues fcq,
         fnd_concurrent_processes fcpr
       where fcq.processor_application_id = fcpp.processor_application_id
         and fcq.concurrent_processor_id =  fcpp.concurrent_processor_id
         and fcpp.concurrent_program_id = fcp.concurrent_program_id
         and fcpp.program_application_id = fcp.application_id
         and fcp.application_id = fa.application_id
         and fa.application_short_name = appl_short_name
         and fcp.concurrent_program_name = prog_short_name
         and fr.responsibility_id = resp_id
         and fr.application_id = resp_appl_id
         and fr.data_group_id = fcq.data_group_id
         and fcq.manager_type = '3'
         and fcpr.concurrent_queue_id = fcq.concurrent_queue_id
         and fcpr.queue_application_id = fcq.application_id
         and fcpr.process_status_code = 'A';