Change Order Total in Bi Publisher custom report

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"