Purchase agreement change orders attachment link to po_versions

Oscar Bourat

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

 

Vinay Swarnkar

Hi Oscar, Can you please provie me the query to join PO_VERSION with all PO archive tables? i am also building the BI report where for each purchase order change order, I need to gather the info of what is added/modified/deleted regarding the previous for header, lines 

User_0XAUE

Hi Oscar, Vinay

Can I get the SQL query if it was build ?

Regards

Kishore S