eg:
select SPARE_PARTS_SN from FP_00000202
where LEVEL_NO = '2'
start with SPARE_PARTS_SN = '54000-003'
connect by prior PARENT_SN = SPARE_PARTS_SN
eg:
select SPARE_PARTS_SN from FP_00000202
where LEVEL_NO = '2'
start with SPARE_PARTS_SN = '54000-003'
connect by prior PARENT_SN = SPARE_PARTS_SN