Query to find Org ID attached to responsibility
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 […]