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 Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...