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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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