You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to know whether the PO are archived?

Hi Experts,

I'm drafting a SQL for a report that our end users will be able to retrieve their approval history.

While there are 2 tables having the PO information: PO_HEADERS_ARCHIVE_ALL and PO_HEADERS_ALL

May I know from where I can understand our current system setup on how long the PO forms will be archived?

Also, it looks like the 2 tables are having distinguish data - for those PO details that are in PO_HEADERS_ALL, they are not in PO_HEADERS_ARCHIVE.

Does it mean that when I need to pull out all the approval histories, I need to do UNION on the results joined with PO_HEADERS_ARCHIVE_ALL and PO_HEADERS_ALL respectively?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!