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:

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)