Oracle EBS 物资类别查询SQL
物资类别查询SQL
物料类别查询SQL
select msi.organization_id,
msi.inventory_item_id,
msi.segment1, -- 物资编码
msi.description, -- 物资说明
mcb.segment1, -- 物资类别编码大类
mcb.segment2, -- 物资类别编码小类
mct.description , -- 物资类别名称
mct.LANGUAGE
from mtl_system_items_b msi,
mtl_item_categories icat,
MTL_CATEGORIES_B mcb,
MTL_CATEGORIES_TL mct
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 = 'ZHS'
;
--刘轶鹤