Oracle Fusion table containing items within browsing categories?

Summary:

Hi Oracle community,

I need a SQL statement that will select the items within a browsing category. Our setup is as below:

A is the root category à B à C à items D, D, D

This table “POR_BROWSE_CATEGORIES_TL” contains browsing categories B and C. Which table in Oracle Fusion contains the items (in this example D?)

Any help would be appreciated.

Thanks

Regards,

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

25A