This works for the Location Table, but can not seem to get it to run on the customer table   select 
BUILTIN.HIERARCHY(parent,'SELF_DISPLAY'), 
* from location