SELECT ID , OKC_TREE_INDEX.GET_ID(LEVEL , LT.DISPLAY_SEQUENCE , 3) LINE_INDEX , OKC_TREE_INDEX.GET_ID_LPADED(LEVEL , LT.DISPLAY_SEQUENCE , 10 , 4) LINE_ORDER FROM OKC_K_LINES_B LT CONNECT BY PRIOR ID = CLE_ID START WITH DNZ_CHR_ID = OKC_TREE_INDEX.GET_ROOT_ID AND CHR_ID IS NOT NULL