ebs 物料类别关联表关系

kelly_yun

已于 2022-09-22 19:05:03 修改

阅读量573

点赞数

分类专栏： INV 文章标签： erp

于 2022-09-22 18:53:32 首次发布

本文链接：https://blog.csdn.net/kelly_yun/article/details/126997585

版权

INV 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

涉及到物料类别和物料类别代码段

select msi.organization_id,
msi.inventory_item_id,
msi.segment1,
icat.category_set_id,
mcb.category_id,
mcb.segment1,
mcb.segment2,
mct.description,
mcst.CATEGORY_SET_NAME

from
mtl_system_items_b msi,
mtl_item_categories icat,
MTL_CATEGORIES_B mcb,
MTL_CATEGORIES_TL mct,
MTL_CATEGORY_SETS_TL MCST
where msi.inventory_item_id = icat.inventory_item_id
and msi.organization_id = icat.organization_id
and icat.category_id = mcb.category_id
and mcb.CATEGORY_ID = mct.CATEGORY_ID
and mct.LANGUAGE = userenv('LANG')
and icat.CATEGORY_SET_ID = MCSt.CATEGORY_SET_ID
and mcst.LANGUAGE = userenv('LANG')
and mcst.CATEGORY_SET_NAME ='EMR Inventory Global'
;