Show certain terms from custom taxonomy but exclude ‘parent’ terms?

I have a custom post type “mycustom_products” (hierarchical) that has custom taxonomies called ‘categories’ and ‘tags’ (as many other custom post types do). My custom category is called “myprod_category” (also hierarchical) and my tag taxonomy is called “product_tag” (not hierarchical).