APPS.OE_RMA_TOTAL SQL Statements

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

Line: 8

  PROCEDURE SELECT_SUMMARY (
			P_HEADER_ID 	IN OUT	NUMBER,
			P_TOTAL		IN OUT  NUMBER,
			P_TOTAL_RTOT_DB IN OUT  NUMBER ) IS

  BEGIN

    SELECT NVL(SUM(L.SELLING_PRICE *
	           (NVL(ORDERED_QUANTITY, 0)
                     - NVL(L.CANCELLED_QUANTITY,0))), 0)
    INTO   P_TOTAL
    FROM   SO_LINES L
    WHERE  L.HEADER_ID = P_HEADER_ID;