APPS.WSH_PICK_CUSTOM SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 44

     SELECT SUM(NVL(L.ORDERED_QUANTITY,0) * NVL(L.UNIT_SELLING_PRICE,0))
     INTO l_order_value
     FROM OE_ORDER_HEADERS_ALL H,
          OE_ORDER_LINES_ALL L
     WHERE H.HEADER_ID = p_header_id
     AND   L.HEADER_ID = H.HEADER_ID;