Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
SQL query to display Purchase Category hierarchy — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL query to display Purchase Category hierarchy

Received Response
3
Views
4
Comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!