SQL & PL/SQL

Apologies for a potentially vague and irritating question.

Using Oracle Purchasing, I go to PO Summary > Find PO > Inquire > View Approval Through Workflow

This lists the WFLow Activities associated with the PO Approval - below is a sample.

----------------------------------------------------------------------------------------------------------------------------------------------
| Status           | Activity                         | Parent Activity     | Started              | Completed            | Activity Result  |
----------------------------------------------------------------------------------------------------------------------------------------------
| Complete         | PO New Communication             | Email PO            | 21-Sep-2007 15:12:55 | 21-Sep-2007 15:12:55 | Yes              |
| Complete         | Does User want document e-mailed | Email PO            | 21-Sep-2007 15:12:55 | 21-Sep-2007 15:12:55 | Yes              |
| Complete         | Email PO                         | PO Approval Process | 21-Sep-2007 15:12:55 | 21-Sep-2007 15:13:11 |                  |
| Complete         | End                              | Fax Document Process| 21-Sep-2007 15:12:55 | 21-Sep-2007 15:12:55 |                  |
| Complete         | Does User Want Document Faxed?   | Fax Document Process| 21-Sep-2007 15:12:55 | 21-Sep-2007 15:12:55 | No               |
----------------------------------------------------------------------------------------------------------------------------------------------

I would really like to know what SQL to use to extract this information, as it would be useful at work.

However, I'm very stuck in finding it.

I can do a very simple join between the PO and one of the WFlow tables:

SELECT pha.segment1
     , pha.wf_item_type
     , pha.wf_item_key
     , wi.*
  FROM po.po_headers_all pha
     , applsys.wf_items wi
 WHERE pha.wf_item_type = wi.item_type
   AND pha.wf_item_key = wi.item_key
   AND pha.segment1 = 1425280;

However, I don't know which tables contain the details WFlow info which is listed above.

There are 2 other related tables:

applsys.wf_item_activity_statuses
applsys.wf_item_attribute_values

But when I look at them, they don't contain values that could tie up with the 'Activity' or 'Parent Activity' above.

Plus I am not 100% sure about the relationships between Activities and Parent Activities.

I can see that thw wf_item and wf_item_key link back to the PO.

But after that I am stuck.

Please feel free to tell me to clear off for asking stupid questions.

Thank you