Saturday, July 11, 2015

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;

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect