Facing an Issue to ge the PIM Default Buyer Details

Summary:

HI Team,

We need to get the PIM Default buyer details to an Item.
We have used the below query to get the buyer details.

(
select
max(ppn.display_name)
from po_agent_assignments paa,
per_person_names_f ppn,
egp_system_items esi
where 1=1
and ppn.person_id=paa.agent_id
and paa.assignment_id=esi.buyer_id
and ppn.name_type ='GLOBAL'
and esi.item_number='400-0058-02'
and esi.organization_id=300000005779845
)

Here even though if item is not assigned to Buyer, in back end we have the Buyer ID details and we are getting buyer data for this query.