View: OE_BIS_CUSTOMER_RETURNS_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.OE_BIS_CUSTOMER_RETURNS_V

View Text

SELECT DECODE( SUM(DECODE(L.LINE_TYPE_CODE
, 'RETURN'
, 0
, 1))
, 0
, 0
, SUM(DECODE(L.LINE_TYPE_CODE
, 'RETURN'
, 1
, 0)) / SUM(DECODE(L.LINE_TYPE_CODE
, 'RETURN'
, 0
, 1))* 100) RETURN_PERCENT
, TRUNC(L.CREATION_DATE) DAY
FROM SO_LINES_ALL L
, SO_HEADERS_ALL H
WHERE L.HEADER_ID = H.HEADER_ID
AND H.S1 = 1
AND H.CUSTOMER_ID IN (SELECT CUSTOMER_ID
FROM OE_BIS_TOP_CUSTOMERS) GROUP BY TRUNC(L.CREATION_DATE)

Columns