--销售预测表：供应链-预测-CUX:集SELECT MFD.CREATION_DATE, --下单日期       MFD.CREATED_BY,--下单人       MFD.FORECAST_DESIGNATOR--客户名称  FROM MRP_FORECAST_DESIGNATORS MFD  SELECT * FROM MRP_FORECAST_DESIGNATO

SELECT MCIX.CUSTOMER_ITEM_ID,--客户物料ID       MCI.CUSTOMER_ITEM_NUMBER--客户物料编码  FROM MTL_CUSTOMER_ITEMS        MCI,--客户物料表       MTL_CUSTOMER_ITEM_XREFS   MCIX--客户物料交叉参考表（客户料号和长盈料号对照表） WHERE MCI

转自：http://blog.youkuaiyun.com/pan_tian/article/details/7693447基本流程创建订单路径：Order Management > Orders,Returns > Sales Orders填写订单头信息，客户，订单类型，销售人员填写订单体信息，输入物料，数量...然后B