Change Order Total in Bi Publisher custom report
Summary
Pl/Sql Function to obtain the order total of a specific historical change orderContent
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
19ACode Snippet
PO_BIP_HELPER.get_ordered_display(h.po_header_id, pv.co_sequence , 'TXN', 'H', h.CURRENCY_CODE) AS "Order Total"
Tagged:
1