select case when connect_by_isleaf = 1 then 0
            when level = 1             then 1
            else                           -1
       end as status, 
       level, 
       "NAME" as title, 
       null as icon, 
       "ID" as value, 
       "NAME" as tooltip, 
'javascript:pageItemValue('||apex_escape.js_literal(id)||')' as link 
from "#OWNER#"."REGIONS"
start with "REFERE_ID" is null 
connect by prior "ID" = "REFERE_ID"
order siblings by "NAME"

'javascript:pageItemValue('||apex_escape.js_literal(id)||')' as link 

function pageItemValue(somevalue)
{
  $s("P22_TREE_ID", somevalue);
/*alert($v('P22_TREE_ID'));*/
}