To display complete functional location hierarchy

Hi Experts!!

Please advice complete table logic to display functional location hierarchy with sub functional locations and equipments, subequipments installed

logic is required to display complete FL hierarchy in NWBC

Thanks in advance.

CHSR