DocumentOpenFyi does not send notification to more than one user when using sql
Summary:
DocumentOpenFyi does not send notification to more than one user when using sql
Content (please ensure you mask any confidential information):
DocumentOpenFyi does not send notification to more than one user when using sql
Version (include the version you are using, if applicable):
24A
Code Snippet (add any code snippets that support your topic, if applicable):
orcl:query-database-with-bindvar('SELECT ped.username appr FROM (SELECT distinct pu.username ,pha.po_header_id FROM fusion.po_headers_all pha , fusion.per_users pu , fusion.po_lines_all pla WHERE pha.agent_id = pu.person_id AND pha.po_header_id = pla.po_header_id AND pla.attribute3 is not null AND NOT EXISTS (SELECT 1 FROM fusion.po_versions pv WHERE pv.po_header_id = pha.po_header_id AND pv.co_num = 1) union SELECT distinct pu.username ,pha.po_header_id FROM fusion.po_headers_all pha , fusion.per_users pu , fusion.po_distributions_all pda , fusion.po_lines_all pla WHERE pha.po_header_id = pda.po_header_id AND pda.deliver_to_person_id = pu.person_id AND pha.po_header_id = pla.po_header_id AND pla.po_line_id = pda.po_line_id AND pla.attribute3 is not null AND NOT EXISTS (SELECT 1 FROM fusion.po_versions pv WHERE pv.po_header_id = pha.po_header_id AND pv.co_num = 1) union