SQL To get query security tree navigation based on record name/node name  :

select a.tree_name
        ||'-->'||(select B.parent_node_name from PSTREENODE B where B.TREE_NODE=(select C.parent_node_name from PSTREENODE C where C.TREE_NODE=(select C1.parent_node_name from PSTREENODE C1 where C1.TREE_NODE=D.parent_node_name and C1.tree_name=D.tree_name and rownum=1 ) and C.tree_name=D.tree_name and rownum=1 ) and B.tree_name=A.tree_name and rownum=1 )
       ||'-->'||(select C.parent_node_name from PSTREENODE C where C.TREE_NODE=(select C1.parent_node_name from PSTREENODE C1 where C1.TREE_NODE=D.parent_node_name and C1.tree_name=D.tree_name and rownum=1 ) and C.tree_name=D.tree_name and rownum=1 )
       ||'-->'||(select C1.parent_node_name from PSTREENODE C1 where C1.TREE_NODE=D.parent_node_name and C1.tree_name=D.tree_name and rownum=1 )
       ||'-->'||(select B.parent_node_name from PSTREENODE B where B.TREE_NODE=A.parent_node_name and B.tree_name=A.tree_name and rownum=1 )
        ||'-->'||A.parent_node_name
        ||'-->'||A.TREE_NODE
        from PSTREENODE A,PSTREENODE D where
        D.TREE_NODE=A.parent_node_name AND a.tree_name=D.TREE_NAME AND
      
        A.TREE_NODE='Reocrd-name'