Wednesday, 30 July 2014

To find the Request set and Concurrent Program attached responcibility

--------------------------------------
  Query to find concurrent program:-
--------------------------------------

/* Formatted on 7/30/2014 6:36:53 PM (QP5 v5.115.810.9015) */
SELECT frt.responsibility_name,
       frg.request_group_name,
       frgu.request_unit_type,
       frgu.request_unit_id,
       fcpt.user_concurrent_program_name
FROM fnd_responsibility fr,
     fnd_responsibility_tl frt,
     fnd_request_groups frg,
     fnd_request_group_units frgu,
     fnd_concurrent_programs_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.concurrent_program_id = frgu.request_unit_id
      AND frt.language = USERENV ('LANG')
      AND fcpt.language = USERENV ('LANG')
      AND fcpt.user_concurrent_program_name = :conc_prg_name
ORDER BY 1, 2, 3, 4


----------------------------------
   Query to find Request Set:-
----------------------------------

/* Formatted on 7/30/2014 6:37:22 PM (QP5 v5.115.810.9015) */
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 = :request_set_name
ORDER BY 1, 2, 3, 4

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete