VIEW: APPS.IMC_DUPL_RANGE_V

Source

View Text - Preformatted

SELECT '0' dupl_rng, 1 min, 1 max,0 rng_no from dual union select '1' dupl_rng, 2 min, 2 max,1 rng_no from dual union select '2' dupl_rng, 3 min, 3 max,2 rng_no from dual union select '3' dupl_rng, 4 min, 4 max,3 rng_no from dual union select '4-10' dupl_rng, 5 min, 11 max,4 rng_no from dual union select '11-100' dupl_rng, 12 min, 101 max,5 rng_no from dual union select '101-10000' dupl_rng, 102 min, 10001 max,6 rng_no from dual union select '> 10000' dupl_rng, 10002 min,10000000000 max,7 rng_no from dual

View Text - HTML Formatted

SELECT '0' DUPL_RNG
, 1 MIN
, 1 MAX
, 0 RNG_NO
FROM DUAL UNION SELECT '1' DUPL_RNG
, 2 MIN
, 2 MAX
, 1 RNG_NO
FROM DUAL UNION SELECT '2' DUPL_RNG
, 3 MIN
, 3 MAX
, 2 RNG_NO
FROM DUAL UNION SELECT '3' DUPL_RNG
, 4 MIN
, 4 MAX
, 3 RNG_NO
FROM DUAL UNION SELECT '4-10' DUPL_RNG
, 5 MIN
, 11 MAX
, 4 RNG_NO
FROM DUAL UNION SELECT '11-100' DUPL_RNG
, 12 MIN
, 101 MAX
, 5 RNG_NO
FROM DUAL UNION SELECT '101-10000' DUPL_RNG
, 102 MIN
, 10001 MAX
, 6 RNG_NO
FROM DUAL UNION SELECT '> 10000' DUPL_RNG
, 10002 MIN
, 10000000000 MAX
, 7 RNG_NO
FROM DUAL