Purchase agreement change orders attachment link to po_versions

Content

Hello Gurus,

I have a requirement to gather information about Fusion purchase agreement change orders in BI Publisher.

For each purchase agreement change order, I need to gather the info of what is added/modified/deleted regarding the previous  for header, lines and attachments. (see attached picture)

For header and lines, I was able to retrieve the changes of each change order using the archive tables :

PO_HEADERS_ARCHIVE_ALL, PO_LINES_ARCHIVE_ALL

With these tables I was able to link the value to PO_VERSIONS using the FROM_CO_SEQ and TO_CO_SEQ attributes and reconstruct the hierarchy of modifications.