Monday, October 23, 2017

Query to get Finanace Responsibilities in Oracle APPS

SELECT fat.application_name, frt.RESPONSIBILITY_NAME, hou.name operating_unit
    FROM fnd_responsibility_tl frt,
         fnd_application_tl fat,
         fnd_profile_options_vl fpo,
         fnd_profile_option_values fpov,
         hr_operating_units hou
   WHERE     frt.language = fat.language
         AND frt.language = USERENV ('LANG')
         AND frt.application_id = fat.application_id
         AND fat.application_name IN ('Payables',
                                      'Receivables',
                                      'Cash Management',
                                      'General Ledger',
                                      'Assets',
                                      'Cost Management',
                                      'Order Management')
         AND profile_option_name = 'ORG_ID'
         AND fpo.profile_option_id = fpov.profile_option_id
         AND fpov.level_value = frt.responsibility_id
         AND TO_CHAR (hou.organization_id) = fpov.profile_option_value
ORDER BY hou.name, fat.application_name

No comments:

Post a 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)