All the history of PO SELECT PHA.SEGMENT1 PO_NUM, PHA.REVISION_NUM, PLA.LINE_NUM PO_LINE_NUM, PLLA.SHIPMENT_NUM, PLA.ITEM_DESCRIPTION, PLA.UNIT_MEAS_LOOKUP_CODE, PLA.LIST_PRICE_PER_UNIT, PLA.CANCEL_FLAG, PLA.CANCEL_DATE, PLA.QUANTITY PO_LINE_QUANTITY, PHA.AUTHORIZATION_STATUS HEADER_APPROVAL_STATUS,PHA.APPROVED_FLAG HEADER_APPROVED_FLAG,PHA.APPROVED_DATE HEADER_APPROVED_DATE, PHA.CLOSED_CODE HEADER_CLOSURE_STATUS, PLA.CLOSED_CODE LINE_CLOSURE_STATUS, PLLA.CLOSED_CODE SHIPMENT_CLORSURE_STATUS, PLLA.APPROVED_FLAG...

Check the approval status of purchase order  SELECT poh.segment1 "PO NUM", poh.authorization_status "STATUS", pla.line_num "SEQ NUM", plla.line_location_id, d.po_distribution_id, poh.type_lookup_code "TYPE" FROM po.po_headers_all poh, po.po_lines_all pla, po.po_line_locations_all plla, po.po_distributions_all d WHERE...