Oracle EBS-SQL (PO-15):检查不能审批的PO.sql

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;*/

转载于:https://www.cnblogs.com/st-sun/p/3782190.html