mtl_system_items_vl 查询物料属性
select a.INVENTORY_ITEM_ID,a.SEGMENT1,a.DESCRIPTION from mtl_system_items_vl a where a.ORGANIZATION_ID='101';
获取物料属性
select * from org_organization_definitions;
获取库存组织转载请注明出处:
未经允许不得转载:lxfamn » 【笔记】EBS常用表笔记
mtl_system_items_vl 查询物料属性
select a.INVENTORY_ITEM_ID,a.SEGMENT1,a.DESCRIPTION from mtl_system_items_vl a where a.ORGANIZATION_ID='101';
获取物料属性
select * from org_organization_definitions;
获取库存组织转载请注明出处:
未经允许不得转载:lxfamn » 【笔记】EBS常用表笔记