Oracle EBS OM 预留和挑选

最新推荐文章于 2025-08-06 11:24:57 发布

原创最新推荐文章于 2025-08-06 11:24:57 发布 · 2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #processing #c

Oracle EBS 专栏收录该内容

35 篇文章

订阅专栏

本文介绍了如何建立表MTL_RESERVATIONS与表oe_order_lines_all之间的联接关系，通过DEMAND_SOURCE_LINE_IDNUMBERLineID进行匹配，并详细解释了WSH_DELIVERY_DETAILS.RELEASED_STATUS的不同状态及其含义。

如何使表MTL_RESERVATIONS和表oe_order_lines_all之间的联接关系?

DEMAND_SOURCE_LINE_ID NUMBER Line ID for demand source.

For Sales Order: OE_ORDER_LINES.LINE_ID

MTL_TRX_SOURCE_TYPES.Transaction_Source_type_id=MTL_REVERSATIONS.Demand_Source_type_id, OE_order_lines_all.Line_id=MTL_REVERSATIONS.Demand_Source_Line_id,）然后MTL_TRX_SOURCE_TYPES.Transaction_Source_type_Name='Sales Order'

---------------------------------------------------

WSH_DELIVERY_DETAILS.RELEASED_STATUS的意義

B Backordered Line failed to be allocated in Inventory
C Shipped Line has been shipped
D Cancelled Line is Cancelled
I Interfaced Line has been shipped and interfaced to Order Management and Inventory
N Not Ready to Release Line is not ready to be released
R Ready to Release Line is ready to be released
S Released to Warehouse Line has been released to Inventory for processing
X Not Applicable Line is not applicable for Pick Release
Y Staged/Pick Confirmed Line has been picked and staged by Inventory