120: l_ato_line_id,
121: l_order_quantity_uom,
122: l_ship_from_org_id,
123: l_inventory_item_id
124: FROM OE_ORDER_LINES_ALL
125: WHERE line_id = p_line_id;
126: /* Comented for bug 2193139
127: IF nvl(l_top_model_line_id,-1) = nvl(l_ato_line_id,-1) AND
128: l_top_model_line_id IS NOT NULL THEN
130: oe_debug_pub.add('It is a ATO MODEL ',3);
131:
132: SELECT line_set_id
133: INTO l_line_set_id
134: FROM OE_ORDER_LINES_ALL
135: WHERE line_id = l_top_model_line_id;
136:
137: oe_debug_pub.add('Line set id : '||l_line_set_id,3);
138:
154: , l_shipping_quantity
155: , l_ordered_quantity2
156: , l_shipped_quantity2
157: , l_shipping_quantity2
158: FROM oe_order_lines_all
159: WHERE line_set_id = l_line_set_id;
160:
161: IF l_debug_level > 0 THEN
162: oe_debug_pub.add( 'ORDER LINE SHIPPED QUANTITY '||L_SHIPPED_QUANTITY , 3 ) ;
163: oe_debug_pub.add( 'ORDER LINE SHIPPED QUANTITY2 '||L_SHIPPED_QUANTITY2 , 3 ) ; -- INVCONV
164: END IF;
165: SELECT count(*)
166: INTO l_count_unshipped
167: FROM oe_order_lines_all
168: WHERE line_set_id = l_line_set_id
169: AND shipped_quantity IS NULL
170: AND line_id <> p_line_id ;
171:
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
187: AND line_id <> p_line_id)
188: and source_code = 'OE'
459: SELECT order_quantity_uom,
460: ordered_quantity_uom2
461: INTO x_quantity_uom,
462: x_quantity_uom2
463: FROM oe_order_lines_all
464: WHERE line_id = p_line_id;
465:
466: IF l_debug_level > 0 THEN
467: oe_debug_pub.add( 'RETURN MIN REMAINING QUANTITY : '||X_MIN_REMAINING_QUANTITY , 3 ) ;