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