Query to get concurrent manager and program rules

  SELECT b.concurrent_queue_name, c.user_concurrent_program_name

    FROM fnd_concurrent_queue_content a,

         fnd_concurrent_queues b,

         fnd_concurrent_programs_vl c

   WHERE     a.queue_application_id = 283

         AND a.concurrent_queue_id = b.concurrent_queue_id

         AND a.type_id = c.concurrent_program_id

ORDER BY DECODE (include_flag, 'i', 1, 2), type_code;