Purchasing

Update PO status to APPROVED

 UPDATE po_headers_all
         SET authorization_status = ‘APPROVED’
           , approved_flag = ‘Y’
           , approved_date = sysdate
           , last_updated_by = last_updated_by
           , last_update_login = last_update_login
           , last_update_date = sysdate
       WHERE segment1 = ‘&po_number’
       
      UPDATE po_line_locations_all
         SET approved_flag = ‘Y’
           , approved_date = sysdate
       WHERE po_header_id in (select po_header_id from po_headers_all where segment1 = ‘&po_number’)