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

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...