CREATE OR REPLACE VIEW TEST_VIEW AS 
WITH HT AS 
    (SELECT 29 AS NUM, '0899' AS CODE, '00845086' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 25 AS NUM, '0908' AS CODE, '00462770' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 28 AS NUM, '0916' AS CODE, '00484274' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 2 AS NUM, '0915' AS CODE, '00607122' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 2 AS NUM, '0917' AS CODE, '00420602' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 24 AS NUM, '0922' AS CODE, '00490903' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 30 AS NUM, '0970' AS CODE, '01117194' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 30 AS NUM, '1044' AS CODE, '00100531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 30 AS NUM, '1044' AS CODE, '00160531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 30 AS NUM, '1044' AS CODE, '00240531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 30 AS NUM, '1044' AS CODE, '00370531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 30 AS NUM, '1044' AS CODE, '00590531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 30 AS NUM, '1044' AS CODE, '00820531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 30 AS NUM, '1044' AS CODE, '00850531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 30 AS NUM, '0777' AS CODE, '05590531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 30 AS NUM, '0555' AS CODE, '50180531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 30 AS NUM, '0555' AS CODE, '50240531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 30 AS NUM, '0555' AS CODE, '55120531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 28 AS NUM, '1044' AS CODE, '00830531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 2 AS NUM, '1054' AS CODE, '00132025' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 2 AS NUM, '1049' AS CODE, '00556515' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 1 AS NUM, '1026' AS CODE, '00813135' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 2 AS NUM, '1026' AS CODE, '00050689' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 2 AS NUM, '1026' AS CODE, '00388950' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 2 AS NUM, '1030' AS CODE, '00364158' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 28 AS NUM, '0899' AS CODE, '00845086' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 24 AS NUM, '0908' AS CODE, '00462770' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL     
    SELECT 23 AS NUM, '0916' AS CODE, '00484274' AS LONG_NUM, 1 AS INDEXE FROM DUAL 
    UNION ALL 
    SELECT 17 AS NUM, '0915' AS CODE, '00607122' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 24 AS NUM, '0917' AS CODE, '00420602' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 23 AS NUM, '0922' AS CODE, '00490903' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 26 AS NUM, '0970' AS CODE, '01117194' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 25 AS NUM, '1044' AS CODE, '00100531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 24 AS NUM, '1044' AS CODE, '00160531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 24 AS NUM, '1044' AS CODE, '00240531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 23 AS NUM, '1044' AS CODE, '00370531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 27 AS NUM, '1044' AS CODE, '00590531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 22 AS NUM, '1044' AS CODE, '00820531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 24 AS NUM, '1044' AS CODE, '00850531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 26 AS NUM, '0777' AS CODE, '05590531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 27 AS NUM, '0555' AS CODE, '50180531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 26 AS NUM, '0555' AS CODE, '50240531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 27 AS NUM, '0555' AS CODE, '55120531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 25 AS NUM, '1044' AS CODE, '00830531' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 25 AS NUM, '1054' AS CODE, '00132025' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 21 AS NUM, '1049' AS CODE, '00556515' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 27 AS NUM, '1026' AS CODE, '00813135' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 26 AS NUM, '1026' AS CODE, '00050689' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 23 AS NUM, '1026' AS CODE, '00388950' AS LONG_NUM, 1 AS INDEXES FROM DUAL 
    UNION ALL 
    SELECT 27 AS NUM, '1030' AS CODE, '00364158' AS LONG_NUM, 1 AS INDEXES FROM DUAL) 
    
SELECT * FROM HT