PJR_RESOURCE_POOLS_CF

Details

Schema: FUSION
Object owner: PJR
Object type: VIEW

Columns

Name
DEP0_PK1_VALUE DEP1_PK1_VALUE DEP2_PK1_VALUE DEP3_PK1_VALUE DEP4_PK1_VALUE DEP5_PK1_VALUE DEP6_PK1_VALUE DEP7_PK1_VALUE DEP8_PK1_VALUE DEP9_PK1_VALUE DEP10_PK1_VALUE DEP11_PK1_VALUE DEP12_PK1_VALUE DEP13_PK1_VALUE DEP14_PK1_VALUE DEP15_PK1_VALUE DEP16_PK1_VALUE DEP17_PK1_VALUE DEP18_PK1_VALUE DEP19_PK1_VALUE DISTANCE

Name

DEP0_PK1_VALUE

DEP1_PK1_VALUE

DEP2_PK1_VALUE

DEP3_PK1_VALUE

DEP4_PK1_VALUE

DEP5_PK1_VALUE

DEP6_PK1_VALUE

DEP7_PK1_VALUE

DEP8_PK1_VALUE

DEP9_PK1_VALUE

DEP10_PK1_VALUE

DEP11_PK1_VALUE

DEP12_PK1_VALUE

DEP13_PK1_VALUE

DEP14_PK1_VALUE

DEP15_PK1_VALUE

DEP16_PK1_VALUE

DEP17_PK1_VALUE

DEP18_PK1_VALUE

DEP19_PK1_VALUE

DISTANCE

Query

SQL_Statement
SELECT pool_id DEP0_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, DECODE(DISTANCE, 13, pool_id, DECODE(DISTANCE, 14, pool_id, DECODE(DISTANCE, 15, pool_id, DECODE(DISTANCE, 16, pool_id, DECODE(DISTANCE, 17, pool_id, DECODE(DISTANCE, 18, pool_id, DECODE(DISTANCE, 19, pool_id, SUBSTR( scbp, instr(scbp,'-',1,19) +1, instr(scbp,'-',1,20)-instr(scbp,'-',1,19)-1)))))))))))))))))))) DEP1_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, DECODE(DISTANCE, 13, pool_id, DECODE(DISTANCE, 14, pool_id, DECODE(DISTANCE, 15, pool_id, DECODE(DISTANCE, 16, pool_id, DECODE(DISTANCE, 17, pool_id, DECODE(DISTANCE, 18, pool_id, SUBSTR( scbp, instr(scbp,'-',1,18) +1, instr(scbp,'-',1,19)-instr(scbp,'-',1,18)-1))))))))))))))))))) DEP2_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, DECODE(DISTANCE, 13, pool_id, DECODE(DISTANCE, 14, pool_id, DECODE(DISTANCE, 15, pool_id, DECODE(DISTANCE, 16, pool_id, DECODE(DISTANCE, 17, pool_id, SUBSTR( scbp, instr(scbp,'-',1,17) +1, instr(scbp,'-',1,18)-instr(scbp,'-',1,17)-1)))))))))))))))))) DEP3_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, DECODE(DISTANCE, 13, pool_id, DECODE(DISTANCE, 14, pool_id, DECODE(DISTANCE, 15, pool_id, DECODE(DISTANCE, 16, pool_id, SUBSTR( scbp, instr(scbp,'-',1,16) +1, instr(scbp,'-',1,17)-instr(scbp,'-',1,16)-1))))))))))))))))) DEP4_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, DECODE(DISTANCE, 13, pool_id, DECODE(DISTANCE, 14, pool_id, DECODE(DISTANCE, 15, pool_id, SUBSTR( scbp, instr(scbp,'-',1,15) +1, instr(scbp,'-',1,16)-instr(scbp,'-',1,15)-1)))))))))))))))) DEP5_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, DECODE(DISTANCE, 13, pool_id, DECODE(DISTANCE, 14, pool_id, SUBSTR( scbp, instr(scbp,'-',1,14) +1, instr(scbp,'-',1,15)-instr(scbp,'-',1,14)-1))))))))))))))) DEP6_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, DECODE(DISTANCE, 13, pool_id, SUBSTR( scbp, instr(scbp,'-',1,13) +1, instr(scbp,'-',1,14)-instr(scbp,'-',1,13)-1)))))))))))))) DEP7_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, SUBSTR( scbp, instr(scbp,'-',1,12) +1, instr(scbp,'-',1,13)-instr(scbp,'-',1,12)-1))))))))))))) DEP8_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, SUBSTR( scbp, instr(scbp,'-',1,11) +1, instr(scbp,'-',1,12)-instr(scbp,'-',1,11)-1)))))))))))) DEP9_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, SUBSTR( scbp, instr(scbp,'-',1,10) +1, instr(scbp,'-',1,11)-instr(scbp,'-',1,10)-1))))))))))) DEP10_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, SUBSTR( scbp, instr(scbp,'-',1,9) +1, instr(scbp,'-',1,10)-instr(scbp,'-',1,9)-1)))))))))) DEP11_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, SUBSTR( scbp, instr(scbp,'-',1,8) +1, instr(scbp,'-',1,9)-instr(scbp,'-',1,8)-1))))))))) DEP12_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, SUBSTR( scbp, instr(scbp,'-',1,7) +1, instr(scbp,'-',1,8)-instr(scbp,'-',1,7)-1)))))))) DEP13_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, SUBSTR( scbp, instr(scbp,'-',1,6) +1, instr(scbp,'-',1,7)-instr(scbp,'-',1,6)-1))))))) DEP14_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, SUBSTR( scbp, instr(scbp,'-',1,5) +1, instr(scbp,'-',1,6)-instr(scbp,'-',1,5)-1)))))) DEP15_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, SUBSTR( scbp, instr(scbp,'-',1,4) +1, instr(scbp,'-',1,5)-instr(scbp,'-',1,4)-1))))) DEP16_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, SUBSTR( scbp, instr(scbp,'-',1,3) +1, instr(scbp,'-',1,4)-instr(scbp,'-',1,3)-1)))) DEP17_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, SUBSTR( scbp, instr(scbp,'-',1,2) +1, instr(scbp,'-',1,3)-instr(scbp,'-',1,2)-1))) DEP18_PK1_VALUE , DECODE(DISTANCE, 1, pool_id, SUBSTR( scbp, instr(scbp,'-',1,1) +1, instr(scbp,'-',1,2)-instr(scbp,'-',1,1)-1)) DEP19_PK1_VALUE , DISTANCE FROM (SELECT sys_connect_by_path (pool_id, '-') \|\| '-' scbp , level DISTANCE, pool_id FROM pjr_resource_pools_b START WITH parent_pool_id = 0 CONNECT BY PRIOR pool_id = parent_pool_id )

SQL_Statement

SELECT

pool_id DEP0_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, DECODE(DISTANCE, 13, pool_id, DECODE(DISTANCE, 14, pool_id, DECODE(DISTANCE, 15, pool_id, DECODE(DISTANCE, 16, pool_id, DECODE(DISTANCE, 17, pool_id, DECODE(DISTANCE, 18, pool_id, DECODE(DISTANCE, 19, pool_id, SUBSTR( scbp, instr(scbp,'-',1,19) +1, instr(scbp,'-',1,20)-instr(scbp,'-',1,19)-1)))))))))))))))))))) DEP1_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, DECODE(DISTANCE, 13, pool_id, DECODE(DISTANCE, 14, pool_id, DECODE(DISTANCE, 15, pool_id, DECODE(DISTANCE, 16, pool_id, DECODE(DISTANCE, 17, pool_id, DECODE(DISTANCE, 18, pool_id, SUBSTR( scbp, instr(scbp,'-',1,18) +1, instr(scbp,'-',1,19)-instr(scbp,'-',1,18)-1))))))))))))))))))) DEP2_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, DECODE(DISTANCE, 13, pool_id, DECODE(DISTANCE, 14, pool_id, DECODE(DISTANCE, 15, pool_id, DECODE(DISTANCE, 16, pool_id, DECODE(DISTANCE, 17, pool_id, SUBSTR( scbp, instr(scbp,'-',1,17) +1, instr(scbp,'-',1,18)-instr(scbp,'-',1,17)-1)))))))))))))))))) DEP3_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, DECODE(DISTANCE, 13, pool_id, DECODE(DISTANCE, 14, pool_id, DECODE(DISTANCE, 15, pool_id, DECODE(DISTANCE, 16, pool_id, SUBSTR( scbp, instr(scbp,'-',1,16) +1, instr(scbp,'-',1,17)-instr(scbp,'-',1,16)-1))))))))))))))))) DEP4_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, DECODE(DISTANCE, 13, pool_id, DECODE(DISTANCE, 14, pool_id, DECODE(DISTANCE, 15, pool_id, SUBSTR( scbp, instr(scbp,'-',1,15) +1, instr(scbp,'-',1,16)-instr(scbp,'-',1,15)-1)))))))))))))))) DEP5_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, DECODE(DISTANCE, 13, pool_id, DECODE(DISTANCE, 14, pool_id, SUBSTR( scbp, instr(scbp,'-',1,14) +1, instr(scbp,'-',1,15)-instr(scbp,'-',1,14)-1))))))))))))))) DEP6_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, DECODE(DISTANCE, 13, pool_id, SUBSTR( scbp, instr(scbp,'-',1,13) +1, instr(scbp,'-',1,14)-instr(scbp,'-',1,13)-1)))))))))))))) DEP7_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, DECODE(DISTANCE, 12, pool_id, SUBSTR( scbp, instr(scbp,'-',1,12) +1, instr(scbp,'-',1,13)-instr(scbp,'-',1,12)-1))))))))))))) DEP8_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, DECODE(DISTANCE, 11, pool_id, SUBSTR( scbp, instr(scbp,'-',1,11) +1, instr(scbp,'-',1,12)-instr(scbp,'-',1,11)-1)))))))))))) DEP9_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, DECODE(DISTANCE, 10, pool_id, SUBSTR( scbp, instr(scbp,'-',1,10) +1, instr(scbp,'-',1,11)-instr(scbp,'-',1,10)-1))))))))))) DEP10_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, DECODE(DISTANCE, 9, pool_id, SUBSTR( scbp, instr(scbp,'-',1,9) +1, instr(scbp,'-',1,10)-instr(scbp,'-',1,9)-1)))))))))) DEP11_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, DECODE(DISTANCE, 8, pool_id, SUBSTR( scbp, instr(scbp,'-',1,8) +1, instr(scbp,'-',1,9)-instr(scbp,'-',1,8)-1))))))))) DEP12_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, DECODE(DISTANCE, 7, pool_id, SUBSTR( scbp, instr(scbp,'-',1,7) +1, instr(scbp,'-',1,8)-instr(scbp,'-',1,7)-1)))))))) DEP13_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, DECODE(DISTANCE, 6, pool_id, SUBSTR( scbp, instr(scbp,'-',1,6) +1, instr(scbp,'-',1,7)-instr(scbp,'-',1,6)-1))))))) DEP14_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, DECODE(DISTANCE, 5, pool_id, SUBSTR( scbp, instr(scbp,'-',1,5) +1, instr(scbp,'-',1,6)-instr(scbp,'-',1,5)-1)))))) DEP15_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, DECODE(DISTANCE, 4, pool_id, SUBSTR( scbp, instr(scbp,'-',1,4) +1, instr(scbp,'-',1,5)-instr(scbp,'-',1,4)-1))))) DEP16_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, DECODE(DISTANCE, 3, pool_id, SUBSTR( scbp, instr(scbp,'-',1,3) +1, instr(scbp,'-',1,4)-instr(scbp,'-',1,3)-1)))) DEP17_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, DECODE(DISTANCE, 2, pool_id, SUBSTR( scbp, instr(scbp,'-',1,2) +1, instr(scbp,'-',1,3)-instr(scbp,'-',1,2)-1))) DEP18_PK1_VALUE ,

DECODE(DISTANCE, 1, pool_id, SUBSTR( scbp, instr(scbp,'-',1,1) +1, instr(scbp,'-',1,2)-instr(scbp,'-',1,1)-1)) DEP19_PK1_VALUE ,

DISTANCE

FROM

(SELECT sys_connect_by_path (pool_id, '-')

|| '-' scbp ,

level DISTANCE,

pool_id

FROM pjr_resource_pools_b START

WITH parent_pool_id = 0 CONNECT BY PRIOR pool_id = parent_pool_id

)