Tech Trainings

Oracle Fusion – How to create procurement agent and SQL Query to get the details

June 4, 2020 by admin

N : Setup and Maintenance — Search for Task — Manage Procurement Agents

-----------------------------------------------------
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

Comments |0|