APPS.OE_SHIPPING_TOLERANCES_PUB dependencies on WSH_DELIVERY_DETAILS
Line 182: FROM wsh_delivery_details
178: BEGIN
179:
180: SELECT nvl(sum(shipped_quantity),0),requested_quantity_uom
181: INTO l_del_shipping_quantity,l_shipping_quantity_uom 182: FROM wsh_delivery_details 183: where source_line_id in (SELECT line_id
184: FROM oe_order_lines_all
185: WHERE line_set_id = l_line_set_id
186: AND shipped_quantity IS NULL