APPS.FND_TRANSACTION_PIPE SQL Statements

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

Line: 47

     select /*+ ORDERED USE_NL (fa fcp fr fcpp fcq)
            INDEX (fcq,FND_CONCURRENT_QUEUES_N1)
            INDEX (fcpp,FND_CONC_PROCESSOR_PROGRAMS_U2) */
          fcq.concurrent_queue_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'
          and fcpr.instance_number = userenv('instance')
         order by DBMS_RANDOM.RANDOM;