[Home] [Help]
1626: AND inventory_item_id = p_inventory_item_id
1627: AND transaction_action_id = 28
1628: AND trx_source_line_id = p_trx_source_line_id;
1629:
1630: -- l_quantity_to_pick is required by 'wsh_details_validations.check_quantity_to_pick' to decide if any more
1631: -- allocation is allowed or not and will return value of l_allowed_flag. This is not being used currently here.
1632: l_quantity_to_pick := l_other_alloc + l_mo_quantity;
1633:
1634: /* Shipping API returns the following:
1634: /* Shipping API returns the following:
1635: l_max_quantity: Maximum quantity(including order line tolerance) that can be staged (e.g. 110 - already staged)
1636: l_avail_req_qty: Minimum quantity remaining to be staged to satify the actual sales order line quantity
1637: (e.g. 100 - already staged) */
1638: wsh_details_validations.check_quantity_to_pick
1639: ( p_order_line_id => p_trx_source_line_id
1640: , p_quantity_to_pick => l_quantity_to_pick
1641: , x_allowed_flag => l_allowed_flag
1642: , x_max_quantity_allowed => l_max_quantity