You can use the function m_pck_ewn.usr_id in your query to create a user-specific alert. This function can be used for any column that corresponds to the User field of A.20.05 User. When the alerts are processed, the current alert user for whom the alert is generated will be returned by this function.
The value of this function is not defined outside of alert processing.
Example of the Query Text value for a user-specific query:
select i.inq_code, i.i_supp, inqn.short_desc, i.bid_req_return_date, i.inq_id
from m_inquiries i,
m_inquiry_nls inqn
where i.inq_id = inqn.inq_id
and inqn.nls_id = 1
and issue_date is not null
and po_buyer = m_pck_ewn.usr_id
and proj_id = 'XYZ'
order by 1,2