摘要：
--不能入库的物料6N137-500E 6000 PO 20332 / 1.1 select mc.INVENTORY_ITEM_ID,ms.segment1,mc.SEGMENT1,mc.SEGMENT2 ,scv.DEPARTMENT from MTL_ITEM_CATEGORIES_V mc , mtl_system_items_b ms, ( --关联有效的厂牌、产品线与之对应的业务类型 select scv.ITEM_CATEGORY_SEGMENT1,scv.ITEM_CATEGORY_SEGMENT2,scv.DEPARTMENT from SECOM_COMPARISON_.. 阅读全文
posted @ 2012-08-08 14:42 奥客 阅读(368) 评论(0) 推荐(0) 编辑