VIEW: APPS.OE_BIS_CUSTOMER_RETURNS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)