Sunday, February 23, 2014

Find out Responsibility & Request Group of a Concurrent Program in Oracle Apps R12

SELECT frt.responsibility_name, frg.request_group_name,
       fcp.concurrent_program_name, fcpt.user_concurrent_program_name
  FROM fnd_request_groups frg,
       fnd_request_group_units frgu,
       fnd_concurrent_programs fcp,
       fnd_concurrent_programs_tl fcpt,
       fnd_responsibility_tl frt,
       fnd_responsibility frs
 WHERE frgu.unit_application_id = fcp.application_id
   AND frgu.request_unit_id = fcp.concurrent_program_id
   AND frg.request_group_id = frgu.request_group_id
   AND frg.application_id = frgu.application_id
   AND fcpt.source_lang = USERENV ('LANG')
   AND fcp.application_id = fcpt.application_id
   AND fcp.concurrent_program_id = fcpt.concurrent_program_id
   AND frs.application_id = frt.application_id
   AND frs.responsibility_id = frt.responsibility_id
   AND frt.source_lang = USERENV ('LANG')
   AND frs.request_group_id = frg.request_group_id
   AND frs.application_id = frg.application_id
   AND fcp.concurrent_program_name LIKE '%XXDA_DA_NAME%'
--AND   fcpt.user_concurrent_program_name LIKE '%XXDA Concurrent Program Name%'   

-- Request Set

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,
       fnd_responsibility_tl frt,
       fnd_request_groups frg,
       fnd_request_group_units frgu,
       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 'XXTEST Request Set'

No comments:

Post a Comment