VIEW: APPS.IMC_DUPL_PERSON_V

Source

View Text - Preformatted

SELECT a.dupl_rng,a.total_cnt, to_char(round((a.total_cnt*100)/b.total,2)) dupl_pct,a.rng_no from (select a.dupl_rng,nvl(b.total_cnt,0) total_cnt, a.rng_no from imc_dupl_range_v a, (select a.dupl_rng,sum(b.party_count) total_cnt, a.rng_no from imc_dupl_range_v a, imc_dupl_per_key_v b WHERE b.party_count between a.min and a.max group by a.dupl_rng,a.rng_no) b where a.dupl_rng = b.dupl_rng(+) UNION select '>10001' dupl_rng, nvl(sum(party_count),0) total_cnt, 7 rng_no from imc_dupl_per_key_v where party_count > 10001) a, (select sum(party_count) total from imc_dupl_per_key_v) b

View Text - HTML Formatted

SELECT A.DUPL_RNG
, A.TOTAL_CNT
, TO_CHAR(ROUND((A.TOTAL_CNT*100)/B.TOTAL
, 2)) DUPL_PCT
, A.RNG_NO
FROM (SELECT A.DUPL_RNG
, NVL(B.TOTAL_CNT
, 0) TOTAL_CNT
, A.RNG_NO
FROM IMC_DUPL_RANGE_V A
, (SELECT A.DUPL_RNG
, SUM(B.PARTY_COUNT) TOTAL_CNT
, A.RNG_NO
FROM IMC_DUPL_RANGE_V A
, IMC_DUPL_PER_KEY_V B
WHERE B.PARTY_COUNT BETWEEN A.MIN
AND A.MAX GROUP BY A.DUPL_RNG
, A.RNG_NO) B
WHERE A.DUPL_RNG = B.DUPL_RNG(+) UNION SELECT '>10001' DUPL_RNG
, NVL(SUM(PARTY_COUNT)
, 0) TOTAL_CNT
, 7 RNG_NO
FROM IMC_DUPL_PER_KEY_V
WHERE PARTY_COUNT > 10001) A
, (SELECT SUM(PARTY_COUNT) TOTAL
FROM IMC_DUPL_PER_KEY_V) B