发运行
1.1 显示条件
1.1.1 Nvl (Wdd.Line_Direction, ‘O‘) IN (‘O‘ , ‘IO‘)
Nvl(Wda.Type, ‘S‘ ) IN ( ‘S‘, ‘C‘ )
1.1.2 有发运行和分配
2、表
WSH_DELIVERY_DETAILS --Wdd
WSH_DELIVERY_ASSIGNMENTS --Wda
3、相关值集
--Wdd.Source_Code
SELECT Flv.Lookup_Code
,Flv.Meaning
FROM Fnd_Lookup_Values Flv
WHERE Flv.Lookup_Type = ‘SOURCE_SYSTEM‘
AND Flv.Language = ‘ZHS‘ --Userenv(‘LANG‘)
AND Flv.View_Application_Id = 665
AND Flv.Security_Group_Id = 0 ;
--Wdd.Released_Status
SELECT Meaning
,Flv_Released.Lookup_Code
FROM Fnd_Lookup_Values Flv_Released
WHERE Flv_Released.Lookup_Type = ‘PICK_STATUS‘
AND Flv_Released.Language = ‘ZHS‘ --Userenv(‘LANG‘)
AND Flv_Released.View_Application_Id = 665
AND Flv_Released.Security_Group_Id = 0
交货行
1、视图
WSH_DLVB_DLVY_V
1.1 显示条件
1.1.1 Wnd.Delivery_Type = ‘STANDARD‘
Nvl(Wnd.Shipment_Direction, ‘O‘ ) IN ( ‘O‘, ‘IO‘ )
Nvl(Wda.Type, ‘S‘ ) IN ( ‘S‘, ‘O‘ )
1.1.2 有发货行和分配行
2、表
WSH_NEW_DELIVERIES --Wnd
WSH_DELIVERY_ASSIGNMENTS --Wda
关联字段：Delivery_Id
3、相关值集
--Wnd.Status_Code --交货状态
SELECT Lookup_Code
,Meaning
, Description
FROM Fnd_Lookup_Values Lv
WHERE LANGUAGE = ‘ZHS‘ --Userenv(‘LANG‘)
AND View_Application_Id = 665
AND Security_Group_Id = 0
AND Lookup_Type = ‘DELIVERY_STATUS‘ ;
保留
1、视图
MTL_RESERVATIONS_ALL_V
查询条件：
Demand_Source_Type_Id = 2 ---需求来源 SELECT * FROM Apps.Mtl_Txn_Source_Types; 2-->销售订单
Demand_Source_Header_Id = 147461 -- Mtl_Sales_Orders.Sales_Order_Id
Demand_Source_Line_Id = 207663 -- Oe_Order_Lines.Line_Id
销售出库流程
原文：http://www.cnblogs.com/hemerocallis/p/5126634.html
