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.
However, for the attachments, there is no such archive table. I am able to retrieve the attachment info using FND_ATTACHED_DOCUMENTS, FND_DOCUMENTS and FND_DOCUMENTS_VL and linking it to PO_HEADERS_ALL with fnd_attached_documents.pk1_value but I can't find a way to link attachment tables to PO_VERSIONS.
There must be a way to make such link, since the info is displayed in Fusion.
Any help on this would be appreciated.
Regards,
Oscar
