Oracle E-Business Suite: Bir Kullanıcının Sahip Olduğu Request Set'ler - Var Olan Bütün Request Set'ler

Bir kullanıcıya ait bütün concurrent request'ler:

  SELECT frt.responsibility_name,  
      frg.request_group_name,  
      frgu.request_unit_type,  
      frgu.request_unit_id,  
      fcpt.user_request_set_name  
   FROM apps.fnd_Responsibility fr,  
      apps.fnd_responsibility_tl frt,  
      apps.fnd_request_groups frg,  
      apps.fnd_request_group_units frgu,  
      apps.fnd_request_Sets_tl fcpt  
   WHERE   frt.responsibility_id = fr.responsibility_id  
      AND frg.request_group_id = fr.request_group_id  
      AND frgu.request_group_id = frg.request_group_id  
      AND fcpt.request_set_id = frgu.request_unit_id  
      AND frt.LANGUAGE = USERENV ('LANG')  
      AND fcpt.LANGUAGE = USERENV ('LANG')  
      AND fcpt.user_request_set_name LIKE '%'  
      AND frt.responsibility_name IN  
         (SELECT b.responsibility_name NAME  
           FROM apps.fnd_user_resp_groups a,  
             apps.fnd_responsibility_vl b,  
             apps.fnd_user u  
          WHERE   a.user_id = u.user_id  
             AND u.user_id = (SELECT user_id  
                       FROM apps.FND_USER  
                      WHERE user_name = :User_name)  
             AND a.responsibility_id = b.responsibility_id  
             AND a.responsibility_application_id = b.application_id  
             AND SYSDATE BETWEEN a.start_date  
                     AND NVL (a.end_date, SYSDATE + 1)  
             AND b.end_date IS NULL  
             AND u.end_date IS NULL)  
 ORDER BY 1,  
      2,  
      3,  
      4; 

Uygulamada bulunan bütün concurrent request'ler:

  SELECT frt.responsibility_name, frg.request_group_name,  
   frgu.request_unit_type,frgu.request_unit_id,  
   fcpt.user_request_set_name  
   FROM apps.fnd_Responsibility fr, apps.fnd_responsibility_tl frt,  
   apps.fnd_request_groups frg, apps.fnd_request_group_units frgu,  
   apps.fnd_request_Sets_tl fcpt  
   WHERE frt.responsibility_id = fr.responsibility_id  
   AND frg.request_group_id = fr.request_group_id  
   AND frgu.request_group_id = frg.request_group_id  
   AND fcpt.request_set_id = frgu.request_unit_id  
   AND frt.LANGUAGE = USERENV('LANG')  
   AND fcpt.LANGUAGE = USERENV('LANG')  
   AND fcpt.user_request_set_name like '%'  
   ORDER BY 1,2,3,4