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.
Tagged:
0