PO_LINE_LOC_STATUS_UPDATE

UPDATE   PO_LINE_LOCATIONS_ALL
   SET   APPROVED_FLAG = 'Y',
         APPROVED_DATE = SYSDATE,
         RECEIVING_ROUTING_ID = '3'
 WHERE   PO_HEADER_ID IN
               (SELECT   PO_HEADER_ID
                  FROM   PO_HEADERS_ALL POH
                 WHERE   NVL (APPROVED_FLAG, 'N') = 'N'
                         AND NVL (UPPER(AUTHORIZATION_STATUS), 'INCOMPLETE') =
                               'INCOMPLETE'
                         AND POH.SEGMENT1 IN
                                  ('42405708',