DBA Data[Home] [Help]

APPS.FND_TM_TESTER SQL Statements

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

Line: 42

  SELECT -1, fr.application_id, fr.responsibility_id
        into userid, appid, respid
        from fnd_concurrent_queues fcq,
             fnd_conc_processor_programs fcpp,
             fnd_concurrent_programs fcp,
             fnd_responsibility fr
        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.concurrent_program_name = 'FNDTMSUCCEED'
         and fr.data_group_id = fcq.data_group_id
         and fcq.manager_type = '3'
         and rownum < 2;