Trying to add the buyers name to the Blanket Notification Expiration alert
Hello Gurus,
I would like to add the buyers name to the below sql statement. The requirement is to add the buyers name who is creating the blanket agreement. Below is screen shot of how the output looks like. Please advise.
SELECT email_address,
po_num,
end_date,
start_date_active,
notification_id
INTO &EMAIL,
&PO_NUM,
&EXP_DATE,
&MSG_DATE,
&NOTIFICATION_ID
FROM po_alert_blanket_view
WHERE notification_condition_code = 'EXPIRATION'
AND trunc(sysdate) >= start_date_active
AND trunc(sysdate) <= end_date_active
AND end_date IS NOT NULL