Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Change Order Total in Bi Publisher custom report — Cloud Customer Connect
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

Change Order Total in Bi Publisher custom report

Received Response
198
Views
3
Comments
edited Feb 19, 2019 8:31AM in Purchasing 3 comments

Summary

Pl/Sql Function to obtain the order total of a specific historical change order

Content

Hi all,

I am writing a custom report report where I have to bring the Ordered total on each change order for a given PO.

I tried to use PO_BIP_HELPER.get_ordered_display function but it seem to always bring the Ordered Total of the latest change order, which is not what I am looking for.

Is there any other function that I could use for this purpose?

Thanks,

Mihai

Version

19A

Code Snippet

PO_BIP_HELPER.get_ordered_display(h.po_header_id, pv.co_sequence , 'TXN', 'H', h.CURRENCY_CODE) AS "Order Total"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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