Saturday, December 18, 2021

Query to get the Menu Name in Oracle APPS

SELECT frt.responsibility_name
      ,fm.menu_id
      ,fm.menu_name
  FROM fnd_menus fm
      ,fnd_responsibility fr
  ,fnd_responsibility_tl frt
 WHERE fm.menu_id = fr.menu_id
   AND fr.responsibility_id = frt.responsibility_id
   AND fr.responsibility_id = frt.responsibility_id
   AND frt.responsibility_name = 'Receivables Manager'

4 comments:

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)