SQL query to display Purchase Category hierarchy

Summary:

SQL query to display Purchase Category hierarchy

Content (required):

For anyone who might find this useful, I've written a SQL to pull the Purchase Category hierarchy. My company only uses levels 1-4, with level 4 being what the end user sees on Reqs., POs, etc. I'm sure if you use the further levels, you should be able to copy the nested Select queries for them.

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

21C

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

Select Distinct

(Select

category_name

From

POR_BROWSE_CATEGORIES_TL pbct

Where

pbct.category_id = picpl.level1_cat_id) Level_1_Name,