How to create a LOV with connect by prior in where clause

Summary:

Create a LOV with connect by prior in where clause

Content (required):

I need to create a Position LOV based on hierarchy. Is there a way to use the connect by prior in where clause of a List of Value.

Version (include the version you are using, if applicable):

22 C

Code Snippet (add any code snippets that support your topic, if applicable):