发运行
1
、视图
WSH_DELIVERABLES_V
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