get item category from top to down
Content
if we create category vehicle --> kia
this select statement get kia but i want to get vehicle
select ecb.CATEGORY_CODE
from egp_system_items_b Esi,
EGP_ITEM_CATEGORIES eic,
EGP_CATEGORIES_B ecb,
EGP_CATEGORY_SETS_B ecsb,
EGP_CATEGORY_SETS_TL ecstl
where eic.inventory_item_id = esi.inventory_item_id
and eic.organization_id = esi.organization_id
and eic.category_id = ecb.category_id
and eic.category_set_id = ecsb.category_set_id
and ecsb.CATEGORY_SET_ID = ecstl.CATEGORY_SET_ID
and ecstl.language = 'US'
and ECSB.CATALOG_CODE = 'PIM_Catalog'
and Esi.INVENTORY_ITEM_ID = 300000001703720
0