如何使表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