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...
/ Posted by Kapil