奥客

摘要： --不能入库的物料1 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_COMPARISO.. 阅读全文

摘要： select * from fnd_lookup_values where lookup_type='VENDOR TYPE'FND_LOOKUP_VALUES_VL 阅读全文