Procure to Pay useful backend information: PO Approved

We are all aware of the Procure to Pay Cycle. However how the information moves and updates in the back-end is one useful input for debugging and obtain additional details more than what is seen in the UI. These are some cases tried out and there can be multiple scenarios. Any contribution is highly appreciated.

Situation: PO Created and Approved:

All Purchase Order Header information is stored in table PO_HEADERS_ALL.

For entire PO Header information you can run the query

SELECT * FROM PO_HEADERS_ALL WHERE SEGMENT1=4500

Purchase Order line information is stored in table PO_HEADER_ID FROM PO_HEADERS_ALL: