DBA Data[Home] [Help]

APPS.EAM_MATERIAL_ALLOCATIONS_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 75: update mtl_txn_request_lines

71: begin
72: -- Propagate changes to Move Order header,line and WRO if propagate parameter is set
73: -- As per Inventory, if a move order line has no allocations, it should be
74: -- closed (status 5), not cancelled (status 6)
75: update mtl_txn_request_lines
76: set quantity = quantity - p_qty_to_reduce,
77: quantity_detailed = quantity_detailed - p_qty_to_reduce,
78: line_status = decode(quantity,p_qty_to_reduce,5,line_status)
79: where line_id = p_move_order_line_id