1 2 3 4 5 6 7 8 9 10 11 12 13 SELECT frv.responsibility_name, fpov.profile_option_value org_id, hou.NAME FROM apps.fnd_profile_options_vl fpo, apps.fnd_responsibility_vl frv, apps.fnd_profile_option_values fpov, apps.hr_organization_units hou WHERE hou.NAME = <OU Name> AND fpov.profile_option_value = […]
Get Org id from Responsibility Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 SELECT frv.responsibility_name, fpov.profile_option_value org_id, hou.NAME FROM apps.hr_organization_units hou, apps.fnd_profile_options_vl fpo, apps.fnd_profile_option_values fpov, apps.fnd_responsibility_vl frv WHERE […]
Lists all products and their Installation Status 1 2 3 4 5 6 7 8 9 10 11 12 13 SELECT fat.application_name, fa.application_id, fpi.patch_level, Decode(fpi.status, ‘I’, ‘Licensed’, ‘N’, ‘Not Licensed’, ‘S’, ‘Shared’, ‘Undetermined’) STATUS FROM […]
——————————————————————————- — Query to find all responsibilities of a user ——————————————————————————- SELECT fu.user_name “User Name”, frt.responsibility_name “Responsibility Name”, fu.start_date “User Access Start Date”, fu.end_date “User Access End Date”, furg.start_date “Resp Access Start Date”, furg.end_date “Resp […]
Enterprise Resource Planning and Integrations BlogSpot 