Saturday, October 23, 2021

Query to get the Request Group of a Concurrent Program in Oracle APPS

SELECT resp_tl.responsibility_name
      ,req_grp.request_group_name
  ,cp.user_concurrent_program_name
  FROM fnd_request_groups req_grp
  ,fnd_request_group_units req_grp_unit
  ,fnd_responsibility resp
  ,fnd_responsibility_tl resp_tl
  ,fnd_concurrent_programs_tl cp
 WHERE req_grp.request_group_id = req_grp_unit.request_group_id
   AND resp.responsibility_id = resp_tl.responsibility_id
   AND resp.request_group_id = req_grp_unit.request_group_id
   AND resp_tl.language = USERENV('LANG')
   AND cp.language = USERENV('LANG')
   AND req_grp_unit.request_unit_id = cp.concurrent_program_id
   AND cp.user_concurrent_program_name LIKE '%XX%' 

1 comment:

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...