Oracle Fusion – How to create procurement agent and SQL Query to get the details
N : Setup and Maintenance — Search for Task — Manage Procurement Agents
![](http://oratrainings.com/wp-content/uploads/2020/06/image-1.png)
![](http://oratrainings.com/wp-content/uploads/2020/06/image-2.png)
----------------------------------------------------- SQL Query to get the procurement agent details ----------------------------------------------------- SELECT ppf.display_name, pu.username, hou.name BU_NAME, paa.access_action_code, paa.active_flag, paa.access_others_level_code FROM po_agent_accesses paa, per_person_names_f_v ppf, per_users pu, hr_organization_units hou WHERE 1 = 1 AND paa.agent_id = ppf.person_id AND pu.person_id = ppf.person_id AND hou.organization_id = paa.prc_bu_id