Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
get item category from top to down — 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

get item category from top to down

Question
15
Views
0
Comments
edited Jun 12, 2020 11:20PM in Reporting and Analytics for SCM

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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