Tuesday, 1 November 2011

po_approved_query

UPDATE
PO_HEADERS_ALL POHSET AUTHORIZATION_STATUS = 'APPROVED',APPROVED_DATE = CREATION_DATE,APPROVED_FLAG = 'Y'WHERE POH.SEGMENT1 IN





UPDATE   PO_HEADERS_ALL POH
   SET   AUTHORIZATION_STATUS = 'APPROVED',
         APPROVED_DATE = CREATION_DATE,
         APPROVED_FLAG = 'Y'
 WHERE   POH.SEGMENT1 IN
               ('42406266')
('44402551')

No comments:

Post a Comment