SELECT
PHA.SEGMENT1,
PHA.WF_ITEM_KEY,
PHA.*
FROM PO.PO_HEADERS_ALL PHA
WHERE PHA.AUTHORIZATION_STATUS='IN PROCESS'
ORDER BY PHA.SEGMENT1
-----------------------------------------------------------------------
/*update po.po_headers_all pha
set pha.authorization_status = 'APPROVED'
where pha.segment1 = 3005081005
and pha.po_header_id = 7309 commit;*/