You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

DocumentOpenFyi does not send notification to more than one user when using sql

in Purchasing 2 comments

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!