VIEW: APPS.IMC_DUPL_ORG_RPT_V

Source

View Text - Preformatted

SELECT m.range, m.range_no, m.sum_key, to_char(round(m.sum_key*100/n.tot_cust,2)) percent from (select range, range_no, sum(key_cust) sum_key from (select dup.dupl_rng range, dup.rng_no range_no, nvl(sum(key.customers),0) key_cust from IMC_DUPL_RANGE_V dup, IMC_DUPL_ORG_KEY_V key WHERE key.customers(+) between dup.min AND dup.max group by dup.dupl_rng, dup.rng_no) group by range, range_no UNION select '>10000', 7, nvl(sum(customers),0) from IMC_DUPL_ORG_KEY_V where customers>10000) m, (select sum(customers) tot_cust from IMC_DUPL_ORG_KEY_V) n UNION select 'Total', 8, sum(customers), '100.00' from IMC_DUPL_ORG_KEY_V order by 4 asc

View Text - HTML Formatted

SELECT M.RANGE
, M.RANGE_NO
, M.SUM_KEY
, TO_CHAR(ROUND(M.SUM_KEY*100/N.TOT_CUST
, 2)) PERCENT
FROM (SELECT RANGE
, RANGE_NO
, SUM(KEY_CUST) SUM_KEY
FROM (SELECT DUP.DUPL_RNG RANGE
, DUP.RNG_NO RANGE_NO
, NVL(SUM(KEY.CUSTOMERS)
, 0) KEY_CUST
FROM IMC_DUPL_RANGE_V DUP
, IMC_DUPL_ORG_KEY_V KEY
WHERE KEY.CUSTOMERS(+) BETWEEN DUP.MIN
AND DUP.MAX GROUP BY DUP.DUPL_RNG
, DUP.RNG_NO) GROUP BY RANGE
, RANGE_NO UNION SELECT '>10000'
, 7
, NVL(SUM(CUSTOMERS)
, 0)
FROM IMC_DUPL_ORG_KEY_V
WHERE CUSTOMERS>10000) M
, (SELECT SUM(CUSTOMERS) TOT_CUST
FROM IMC_DUPL_ORG_KEY_V) N UNION SELECT 'TOTAL'
, 8
, SUM(CUSTOMERS)
, '100.00'
FROM IMC_DUPL_ORG_KEY_V ORDER BY 4 ASC