302: AND l.line_status NOT IN (5, 6)
303: AND h.header_id = l.header_id
304: AND h.move_order_type NOT IN
305: (gme_common_pvt.g_invis_move_order_type
306: ,inv_globals.g_move_order_put_away)
307: ORDER BY l.header_id, l.line_id;
308:
309: -- Bug 13076579
310: l_index NUMBER;
327: AND l.line_status NOT IN (5, 6)
328: AND h.header_id = l.header_id
329: AND h.move_order_type NOT IN
330: (gme_common_pvt.g_invis_move_order_type
331: ,inv_globals.g_move_order_put_away);
332:
333:
334: -- Bug 13076579 - get the sum across all open move orders to see what is still open.
335: CURSOR cur_pending_move_orders_sum (
347: AND l.line_status NOT IN (5, 6)
348: AND h.header_id = l.header_id
349: AND h.move_order_type NOT IN
350: (gme_common_pvt.g_invis_move_order_type
351: ,inv_globals.g_move_order_put_away)
352: GROUP BY l.txn_source_line_id;
353:
354: TYPE pend_lines_tab IS TABLE OF cur_pending_move_orders%ROWTYPE
355: INDEX BY BINARY_INTEGER;