Invoice Receipts Holds Alert - Email Problem
SELECT
hrea1.email_address
,hrea1.FIRST_NAME||' '||hrea1.middle_name||' '||hrea1.last_name requestor_name
,hrea.FIRST_NAME||' '||hrea.middle_name||' '||hrea.last_name buyer_name
,u.location_code
,h.ORGANIZATION_code
,to_char(substr(rpad(pol.line_num,20,' '),1,15)) line_num