What's the table name and the column name where Hierarchy Name of customer or party hierarchies is stored?

You must refer to the TREE_NAME column of the FND_TREE_VL table for hierarchy names.