APPS.WSH_PR_CUSTOM SQL Statements

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

Line: 59

	SELECT SUM(NVL(L.ORDERED_QUANTITY,0) * NVL(L.SELLING_PRICE,0))
	INTO order_value
	FROM SO_HEADERS_ALL H,
	     SO_LINES_ALL L
	WHERE H.HEADER_ID = p_header_id
	AND   L.HEADER_ID = H.HEADER_ID;